Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

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

Author:

191285

Comment:

--

AdvancedReports

@@ -45 +45 @@
 from organizers o 
 join reviews as r on 
-                                        r.organizer_id = o.user_id and 
-                                        r.rating > 3
+       r.organizer_id = o.user_id and 
+       r.rating > 3
 group by o.user_id)
 select 
@@ -52 +52 @@
 from events as e
 join tempTable as tt on 
-                                                tt.user_id = e.organizer_id 
+       tt.user_id = e.organizer_id 
 join offers as o2 on 
-                                        o2.event_id = e.id 
+       o2.event_id = e.id 
 join transactions as t on 
-                                        t.offer_id = o2.id 
+     t.offer_id = o2.id 
 ) as temp
   }}}