Changes between Version 2 and Version 3 of Ticket #11, comment 4


Ignore:
Timestamp:
07/31/2024 07:46:47 PM (2 years ago)
Author:
Bart

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11, comment 4

    v2 v3  
    22
    33{{{
    4 SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE ad_id = ads.ad_id) AS i FROM ads
    5 JOIN tags ON tags.ad_id = ads.ad_id WHERE tags = (SELECT tags FROM publisher WHERE property = referrer)
    6 GROUP BY ads.ad_id ORDER BY i DESC
     4SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE tags.ad_id = ads.ad_id) AS interest FROM ads
     5JOIN tags ON tags.ad_id = ads.ad_id WHERE ads.crude < crude AND charity = s AND tags = (SELECT tags FROM publisher WHERE property = referrer)
     6GROUP BY ads.ad_id ORDER BY interest DESC
    77}}}
    88// Had ik tot nu