Changes between Version 55 and Version 56 of AdvancedReports

Timestamp:

12/24/22 22:51:57 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -225 +225 @@
 }}}
 
-== За даден настан, листа на сите артисти на настанот со број на активни настани во кои учествува артисот
-
-{{{#!div style="font-size: 90%"
-  {{{#!sql 
-select u."name", u.surname, count(e.id_event) as broj_nastani
+== Прикажување на сите настани во кој учествува одреден тип на артист
+
+{{{#!div style="font-size: 90%"
+  {{{#!sql 
+select e."name", e."date", e.city, e.price, u."name", u.surname 
 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(
-        select 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
+        select u2.id_user
+        from artist a2
+        join users u2 on a2.id_user = u2.id_user
+        join events e2 on a2.id_user = e2.id_user_artist
+        where a2.type_of_artist = 'actress'
+        group by u2.id_user)
+order by e."date" desc
   }}}
 }}}