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


Ignore:
Timestamp:
07/31/2024 06:55:05 PM (2 years ago)
Author:
Bart

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11, comment 4

    initial v1  
    22
    33{{{
    4 SELECT ads.ad_id, count(*)/(count(SELECT tags FROM tags WHERE tags.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
     4SELECT ads.ad_id, count(*)/count(SELECT tags FROM tags WHERE ad_id = ads.ad_id) AS identity FROM ads
     5JOIN 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
    66}}}
    77// Had ik tot nu