Changes between Version 1 and Version 2 of AdvancedReports

Timestamp:

12/20/22 13:32:32 (2 years ago)

Author:

201045

Comment:

--

AdvancedReports

@@ -17 +17 @@
 group by pr.id_mesto, pa.paket_id
 having sum(nip.kolicina)
-= max((
+= (
 select sum(nipp.kolicina) 
 from prodazhnomesto prr join prodazhnomesto_nudi_paket pnpp on prr.id_mesto = pnpp.id_mesto 
@@ -27 +27 @@
 order by sum(nipp.kolicina) 
 limit 1
-));
+);
 }}}