Changes between Version 33 and Version 34 of AdvancedReports

Timestamp:

12/24/22 16:07:31 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -158 +158 @@
   {{{#!sql 
 select u."name", u.surname, count(e.id_event) as broj_nastani 
-from artist a join users u on a.id_user=u.id_user
+from artist a 
+join users u on a.id_user=u.id_user
 join events e on a.id_user=e.id_user_artist
-where u.id_user in (
+where u.id_user in(
 select u.id_user 
-from artist a join users u on a.id_user=u.id_user
+from artist a 
+join users u on a.id_user=u.id_user
 join events e on a.id_user=e.id_user_artist
 where e.id_event=1
-group by  u.id_user )
-group by  u."name", u.surname
+group by u.id_user)
+group by u."name", u.surname
   }}}
 }}}