Changes between Version 9 and Version 10 of AdvancedReports

Timestamp:

02/01/22 14:38:27 (2 years ago)

Author:

191215

Comment:

--

AdvancedReports

@@ -138 +138 @@
 }}}
 
-== Број на барања испратени кон одреден артист за одреден настан.
-
-{{{#!sql
-select a.user_id, count(o.artist_id) as num_of_offers_received 
+== Број на барања испратени кон артисти.
+
+{{{#!sql
+select 
+        a.user_id,
+        count(o.id) as num_of_offers_received 
 from artists a 
 join users u on u.id = a.user_id
 join offers o on o.artist_id = a.user_id 
 join events e on e.id = o.event_id
-where 
-        e.title = 'Igor''s Birthday' and 
-        u.username = 'test_artist_1'
 group by a.user_id 
 }}}