Changes between Version 24 and Version 25 of Напредни извештаи од базата

Timestamp:

02/13/22 21:13:58 (3 years ago)

Author:

186102

Comment:

--

Напредни извештаи од базата

@@ -34 +34 @@
 == 5 Најпопуларни производи во изминатите 6 месеци ==
 {{{#!sql
-select distinct p."name" as Name, p.description as description, cnt
+select distinct p.prod_id, count(cp.prod_id) as cnt
 from project.product as p
-join 
-(
-        select cp.prod_id, count(cp.prod_id) as cnt
-        from project.contains_product as cp
-        group by cp.prod_id
-)as t1 on t1.prod_id = p.prod_id
-join project.contains_product as ccp on ccp.prod_id = p.prod_id
-join project.cart as crt on crt.cart_id = ccp.cart_id
+join project.contains_product as cp on cp.prod_id = p.prod_id
+join project.cart as crt on crt.cart_id = cp.cart_id
 join project.checkout as chk on chk.cart_id = crt.cart_id
 join project.order as o on o.order_id = chk.order_id
 join project.delivery as dlv on o.delivery_id = dlv.delivery_id
 where dlv.status = 'Delivered' and now()-interval'6 months' <= dlv."date"
+group by p.prod_id,cp.prod_id 
 order by cnt desc
 limit 5;