Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/12/22 16:40:49 (3 years ago)

Author:

195115

Comment:

--

AdvancedReports

@@ -29 +29 @@
 
 {{{#!sql
- select sum(mp.projection_price) as vkupna_potroshuvacka,u.user_name from users as u
+  select c.user_id,sum(mp.projection_price) as vkupna_potroshuvacka,u.user_name,u.user_surname from users as u
      join client as c on c.user_id = u.user_id
      join reservation as r on r.user_id = c.user_id
@@ -35 +35 @@
      join movieprojection as mp on mp.projection_id = r.projection_id
      where mp.projection_id = 12732  --?--
-     group by u.user_name
+     group by c.user_id,u.user_name,u.user_surname
      order by vkupna_potroshuvacka desc
      limit 1;