Changes between Version 23 and Version 24 of AdvancedReports

Timestamp:

12/23/22 21:15:12 (3 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -100 +100 @@
 {{{#!div style="font-size: 90%"
   {{{#!sql 
-select count (*) from (
-with tempTable as (select 
-        o.* 
-from organizers o 
-join reviews as r on 
-       r.organizer_id = o.user_id and 
-       r.rating > 3
-group by o.user_id)
-select 
-        t.*
-from events as e
-join tempTable as tt on 
-       tt.user_id = e.organizer_id 
-join offers as o2 on 
-       o2.event_id = e.id 
-join transactions as t on 
-     t.offer_id = o2.id 
-) as temp
+select c.id_user, r.rating, count(t.id_transaction) 
+from customer c join review r on c.id_user =r.id_user_customer 
+join cart c2 on c.id_user =c2.id_user_customer 
+join transactions t on c2.id_user_customer =t.id_user_customer 
+where r.rating >7
+group by c.id_user, r.rating 
   }}}
 }}}