Changes between Version 15 and Version 16 of AdvancedReports

Timestamp:

03/10/22 18:47:29 (2 years ago)

Author:

191151

Comment:

--

AdvancedReports

@@ -5 +5 @@
 {{{#!sql
 select 
-        o.artist_id,
+        u."name" ,
         SUM(t.stripe_price)
-from transactions t 
-inner join offers o on 
-                t.offer_id = o.id 
+from artists a 
+join users u on 
+        u.id = a.user_id 
+join offers o on 
+    o.artist_id = u.id 
+join transactions t on 
+        t.offer_id = o.id 
 where 
-        extract (year from t.created_at) = extract (year from now() - interval '1 year')
-group by o.artist_id 
+    extract (year from t.created_at) = extract (year from now() - interval '1 year')
+group by u.id 
 }}}