Changes between Version 3 and Version 4 of AdvancedReports


Ignore:
Timestamp:
01/23/26 19:25:17 (7 days ago)
Author:
231136
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdvancedReports

    v3 v4  
    197197    CONCAT(EXTRACT(YEAR FROM oy.year_start),'-',m.month_name) AS month,
    198198    COALESCE(u.full_name,'n/a') AS artist_name,
    199     COALESCE(mp.max_month_counter,0) AS aonthly_listens
     199    COALESCE(mp.max_month_counter,0) AS monthly_listens
    200200FROM months m
    201201LEFT JOIN most_popular mp ON mp.month=m.month_num