Changes between Version 15 and Version 16 of AdvancedReports

Timestamp:

01/21/22 18:26:12 (2 years ago)

Author:

196021

Comment:

--

AdvancedReports

@@ -82 +82 @@
  join movie as m on is1.movie_id=m.movie_id
  join movieprojection as mp on m.movie_id=mp.movie_id
- join reservation as r on mp.projection_id=r.reservation_id
+ join reservation as r on mp.projection_id=r.projection_id
  join (
      select g2.genre_id,g2.genre_name,count(p1.payment_id) as prodadena_karta 
@@ -89 +89 @@
  join movie as m2 on is2.movie_id=m2.movie_id
  join movieprojection as mp2 on m2.movie_id=mp2.movie_id
- join reservation as r2 on mp2.projection_id=r2.reservation_id
+ join reservation as r2 on mp2.projection_id=r2.projection_id
  join payment as p1 on r2.reservation_id=p1.reservation_id 
  group by 1,2