Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

01/05/23 05:22:05 (2 years ago)

Author:

201094

Comment:

--

AdvancedReports

@@ -151 +151 @@
 === Извештај за секое кино, кој филм има направено најмногу профит во последните 3 месеци ===
 {{{#!sql
-select c.id_cinema,c.name,max(sum_cena.sum1) as m
+select c.id_cinema,c.name,
+max(sum_cena.sum1) as m
 from cinemas c 
 join cinema_plays_film cpf on cpf.id_cinema=c.id_cinema 
@@ -165 +166 @@
 where t1.date_reserved between now()-interval'3 months' and now()
 group by c2.id_cinema,f2.id_film 
-) as sum_cena on sum_cena.id=c.id_cinema 
+) 
+as sum_cena on sum_cena.id=c.id_cinema 
 group by c.id_cinema
 order by c.id_cinema