Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

01/26/26 19:57:02 (4 days ago)

Author:

231136

Comment:

--

AdvancedReports

@@ -43 +43 @@
 LEFT JOIN listenCount lc ON lc.album_id = lk.album_id
 LEFT JOIN averageGrade ag ON ag.album_id = lk.album_id
-ORDER BY total_likes DESC, total_listens DESC
+ORDER BY total_likes DESC, total_listens DESC;
 }}}
 
@@ -202 +202 @@
 LEFT JOIN users u ON mp.user_id=u.user_id
 CROSS JOIN one_year oy
-ORDER BY m.month_num
+ORDER BY m.month_num;
 }}}
 
@@ -260 +260 @@
     CONCAT(s.pct_change, '%')
 FROM stats s
-ORDER BY pct_change DESC
-
-}}}
+ORDER BY pct_change DESC;
+
+}}}