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


Ignore:
Timestamp:
08/01/2024 09:12:18 AM (2 years ago)
Author:
Bart

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11, comment 4

    v3 v4  
    22
    33{{{
    4 SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE tags.ad_id = ads.ad_id) AS interest FROM ads
     4SELECT ads.ad_id, count(*)/(SELECT count(tags) FROM tags WHERE tags.ad_id = ads.ad_id) AS interest FROM ads
    55JOIN tags ON tags.ad_id = ads.ad_id WHERE ads.crude < crude AND charity = s AND tags = (SELECT tags FROM publisher WHERE property = referrer)
    66GROUP BY ads.ad_id ORDER BY interest DESC