Changes between Version 37 and Version 38 of AdvancedReports

Timestamp:

12/24/22 16:21:35 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -70 +70 @@
   {{{#!sql 
 select e2."name", q4.max_broj_zainteresirani
-from
-((select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
+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 
@@ -77 +77 @@
 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
+group by e.id_event 
+) q1
 
 join 
 
-(
-select max(q2.broj_na_zainteresirani_kupuvaci) as max_broj_zainteresirani
+(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
@@ -91 +91 @@
 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)
+) q2 ) q3 
+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 
 
   }}}