Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

12/20/22 14:07:14 (2 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -40 +40 @@
 {{{#!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
   }}}
 }}}