Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

01/11/23 00:37:55 (18 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -124 +124 @@
 
 
+== Рангирани корисници според бројот на медали кои ги освоиле
+
+
+{{{
+select u.username, count(miatq.medalid) as medal_count from quiztaker qt
+left join medal_is_awarded_to_quiztaker miatq on qt.userid = miatq.userid 
+left join user_table u on qt.userid = u.userid 
+group by 1
+order by medal_count
+}}}