Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

12/27/22 14:41:36 (3 years ago)

Author:

201065

Comment:

--

AdvancedReports

@@ -87 +87 @@
 
 }}}
+
+===  Извештај за категориите со најмногу продадаени артикли===
+
+{{{#!sql
+select c.categoryname, a.articlename, coalesce(sum(i.quantity),0) as vkol from articles a
+        left join article_belongs_to_category abtc on abtc.articleid=a.articleid 
+        left join categories c on c.categoryid=abtc.categoryid 
+        left join invoicedarticles i on i.articleid=a.articleid 
+        group by c.categoryid, a.articleid 
+        having coalesce(sum(i.quantity), 0)=(
+                select max(vkol) from
+                (
+                        select coalesce(sum(i.quantity),0) as vkol from articles a
+                        left join article_belongs_to_category abtc on abtc.articleid=a.articleid 
+                        left join categories c on c.categoryid=abtc.categoryid 
+                        left join invoicedarticles i on i.articleid=a.articleid 
+                        group by c.categoryid, a.articleid
+                ) q1
+        )
+
+
+}}}