Changes between Version 16 and Version 17 of AdvancedReports

Timestamp:

03/10/22 18:49:24 (3 years ago)

Author:

191151

Comment:

--

AdvancedReports

@@ -23 +23 @@
 {{{#!sql
 select 
-        o.user_id as organizer_id,
-        at2.name
+        distinct at2.name
 from organizers o 
 left join events e on e.organizer_id = o.user_id 
@@ -31 +30 @@
 join artist_types at2 on at2.id = a.artist_type_id 
 where 
-        o2.status = 1 and 
-        o2.completed_at between now() - interval '6 months' and now()
+        o2.status = 'COMPLETED'and
+        o2.completed_at between now() - interval '6 months' and now()
 group by o.user_id, at2.name
 }}}