Changes between Version 14 and Version 15 of AdvancedReports


Ignore:
Timestamp:
08/05/26 11:04:20 (21 hours ago)
Author:
231136
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdvancedReports

    v14 v15  
    231231    JOIN listensCount lc ON lc.user_id=fc.user_id
    232232    JOIN users u ON u.user_id=lc.user_id
    233     WHERE not exists(
     233    WHERE NOT EXISTS(
    234234        SELECT 1
    235         FROM artists a
    236         JOIN followersCount fc1 ON a.user_id=fc1.user_id
     235        FROM followersCount fc1
    237236        JOIN listensCount lc1 ON lc1.user_id=fc1.user_id
    238237        WHERE fc.event_id=fc1.event_id