Changes between Version 41 and Version 42 of AdvancedReports

Timestamp:

12/24/22 17:06:38 (3 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -137 +137 @@
   {{{#!sql 
 select q4."location", q4.max_broj_nastani
-from (
-
-(select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
-from ticket t 
-join events e on t.id_event=e.id_event 
-group by godina, t."location" 
+from
+        (
+
+(
+        select extract (year from t.date) as godina, count(distinct e.id_event) broj_nastani, t."location"
+        from ticket t
+        join events e on t.id_event = e.id_event
+        group by godina, t."location" 
 ) q1
-                
 join 
 
 (
-select max(q2.broj_nastani) as max_broj_nastani
-from (
-select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
-from ticket t 
-join events e on t.id_event=e.id_event 
-group by godina, t."location"
+        select max(q2.broj_nastani) as max_broj_nastani
+        from
+                (
+                select extract (year from t.date) as godina, count(distinct e.id_event) broj_nastani, t."location"
+                from ticket t
+                join events e on t.id_event = e.id_event
+                group by godina, t."location"
 ) q2 ) q3
-on q1.broj_nastani=q3.max_broj_nastani) 
+on
+        q1.broj_nastani = q3.max_broj_nastani) 
 
 as q4