Changes between Version 48 and Version 49 of AdvancedReports

Timestamp:

12/24/22 17:30:04 (3 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -98 +98 @@
 {{{#!div style="font-size: 90%"
   {{{#!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 
+select e2."name", e2."date", e2.city, e2.price, 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 
 ) q1
 
@@ -113 +113 @@
 
 (
-        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)
+        q1.broj_na_zainteresirani_kupuvaci = q3.max_broj_zainteresirani)
 as q4
 join events e2 on q4.id_event = e2.id_event