Changes between Version 40 and Version 41 of AdvancedReports

Timestamp:

12/24/22 17:03:02 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -101 +101 @@
   {{{#!sql 
 select e2."name", q4.max_broj_zainteresirani
-from (
-(select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
-from ticket t  
-join events e on t.id_event=e.id_event 
-join users u on t.id_user_customer=u.id_user 
-join cart c on c.id_user_customer=t.id_user_customer 
-where e."date" between current_date - interval '100 days' and current_date
-group by e.id_event 
+from
+        (
+(
+        select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
+        from ticket t
+        join events e on t.id_event = e.id_event
+        join users u on t.id_user_customer = u.id_user
+        join cart c on c.id_user_customer = t.id_user_customer
+        where e."date" between current_date - interval '100 days' and current_date
+        group by e.id_event 
 ) q1
-
 join 
 
-(select max(q2.broj_na_zainteresirani_kupuvaci) as max_broj_zainteresirani
-from (
-select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
-from ticket t  
-join events e on t.id_event=e.id_event 
-join users u on t.id_user_customer=u.id_user 
-join cart c on c.id_user_customer=t.id_user_customer 
-where e."date" between current_date - interval '100 days' and current_date
-group by e.id_event 
+(
+        select max(q2.broj_na_zainteresirani_kupuvaci) as max_broj_zainteresirani
+        from
+                (
+                select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
+                from ticket t
+                join events e on t.id_event = e.id_event
+                join users u on t.id_user_customer = u.id_user
+                join cart c on c.id_user_customer = t.id_user_customer
+                where e."date" between current_date - interval '100 days' and current_date
+                group by e.id_event 
 ) q2 ) q3 
-on q1.broj_na_zainteresirani_kupuvaci=q3.max_broj_zainteresirani)
+on q1.broj_na_zainteresirani_kupuvaci = q3.max_broj_zainteresirani)
 
 as q4
-join events e2 on q4.id_event=e2.id_event 
+join events e2 on q4.id_event = e2.id_event
   }}}
 }}}