Changes between Version 3 and Version 4 of AdvancedReports
- Timestamp:
- 01/23/26 19:25:17 (7 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v3 v4 197 197 CONCAT(EXTRACT(YEAR FROM oy.year_start),'-',m.month_name) AS month, 198 198 COALESCE(u.full_name,'n/a') AS artist_name, 199 COALESCE(mp.max_month_counter,0) AS aonthly_listens199 COALESCE(mp.max_month_counter,0) AS monthly_listens 200 200 FROM months m 201 201 LEFT JOIN most_popular mp ON mp.month=m.month_num
