Changes between Version 14 and Version 15 of AdvancedReports

Timestamp:

02/28/23 13:43:37 (21 months ago)

Author:

201065

Comment:

--

AdvancedReports

@@ -7 +7 @@
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
     where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
-    limit 1) as topArticleName,
+    ) as topArticleName,
 (select i2.price  from project.articles a
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
     where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
-    limit 1) as topArticlePrice,
+    ) as topArticlePrice,
 (select i2.quantity from project.articles a
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
     where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
-    limit 1) as topArticleQuantity,
+    ) as topArticleQuantity,
 max(ba.totalPrice) as topArticleTotalPrice from project.workers w
         left join project.users u on u.userid=w.userid