Changes between Version 10 and Version 11 of AdvancedReports

Timestamp:

01/25/22 20:39:10 (3 years ago)

Author:

193288

Comment:

--

AdvancedReports

@@ -11 +11 @@
 group by k2.korisnicko_ime
 order by br desc limit 1
+
+select  konstantacija , count( konstantacija) as brpt from kazna as k
+join kontrola as kk on kk.id_kazna=k.id_kazna
+group by konstantacija
+order by brpt desc limit 1
   }}}
 
@@ -32 +37 @@
 == Листа на контролери кои што изрекле најмногу казни
 {{{#!sql
-select  konstantacija , count( konstantacija) as brpt from kazna as k
-join kontrola as kk on kk.id_kazna=k.id_kazna
-group by konstantacija
-order by brpt desc limit 1
+select korisnicko_ime,count(korisnicko_ime) as br from kontrola as k2
+group by k2.korisnicko_ime
+order by br desc limit 1
+
   }}}