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

Timestamp:

01/30/22 23:29:36 (3 years ago)

Author:

186102

Comment:

--

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

@@ -28 +28 @@
 }}}
 
+== Најпопуларен производ во wishlists на корисниците ==
+{{{#!sql
+select p."name" as Product, p.description as Description
+from project.product as p
+join(
+        select ptw.prod_id, count(ptw.prod_id) as cnt
+        from project.product_to_wishlist as ptw
+        group by ptw.prod_id
+) as pw on p.prod_id = pw.prod_id
+group by p."name", p.description, pw.cnt
+order by pw.cnt desc
+limit 1;
+}}}
+
+