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


Ignore:
Timestamp:
07/31/2024 07:16:14 PM (2 years ago)
Author:
Bart

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11, comment 4

    v1 v2  
    22
    33{{{
    4 SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE ad_id = ads.ad_id) AS identity FROM ads
    5 JOIN tags ON tags.ad_id = ads.ad_id WHERE tags = (SELECT tags FROM publisher WHERE property = referrer) GROUP BY ads.ad_id ORDER BY identity DESC
     4SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE ad_id = ads.ad_id) AS i FROM ads
     5JOIN tags ON tags.ad_id = ads.ad_id WHERE tags = (SELECT tags FROM publisher WHERE property = referrer)
     6GROUP BY ads.ad_id ORDER BY i DESC
    67}}}
    78// Had ik tot nu