Changes between Version 20 and Version 21 of AdvancedReports

Timestamp:

03/10/22 18:55:24 (2 years ago)

Author:

191151

Comment:

--

AdvancedReports

@@ -285 +285 @@
 {{{#!sql
 select 
-        asg.genre_id,
-        count(asg.genre_id) as popularity
+        g."name",
+        count(asg.genre_id) as popularity
 from artist_sings_genres asg
-group by asg.genre_id
+join genres g on 
+        g.id = asg.genre_id 
+group by asg.genre_id, g.id 
 order by popularity desc 
 }}}