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

Timestamp:

02/12/22 00:50:01 (3 years ago)

Author:

186102

Comment:

--

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

@@ -34 +34 @@
 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
+        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
+join(
+                select u.time_stamp, u.product_id
+                from project.updates as u
+                group by u.product_id, u.time_stamp
+)as u on u.product_id = p.prod_id
+where now()-interval'6 months' <= u.time_stamp
+group by p."name", p.description, pw.cnt, p.prod_id, u.time_stamp
 order by pw.cnt desc
 limit 1;