Changes between Version 5 and Version 6 of Complex DB Reports

Timestamp:

02/07/26 17:00:24 (21 hours ago)

Author:

231035

Comment:

--

Complex DB Reports

@@ -428 +428 @@
   final_score := (m.cf_score * 3 + m.content_score * 2)
 (
-  σ l.status = 'ACTIVE'
-  ((Merged m ⨝ (m.listing_id = l.listing_id) listings l))
-)
+  σ (l.status = 'ACTIVE' ∧ l.owner_id ≠ p.user_id)
+  (
+    (Merged m ⨝ (m.listing_id = l.listing_id) listings l)
+    × Params p
+  )
+)
+
 Result <-
 topK_{N := p.top_n}