Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

02/02/26 20:43:05 (4 days ago)

Author:

231136

Comment:

--

AdvancedReports

@@ -204 +204 @@
 
 WITH followersCount AS (
-    SELECT a.user_id AS artist,
+    SELECT a.user_id,
         pa.event_id,
         COALESCE(COUNT(f.follower),0) AS followers
@@ -214 +214 @@
 listensCount AS (
     SELECT
-        a.user_id AS artist,
+        a.user_id,
         COALESCE(COUNT(l.timestamp),0) AS listen_count
     FROM artists a
@@ -230 +230 @@
     FROM events e
     JOIN performs_at pa ON pa.event_id=e.event_id
-    JOIN followersCount fc ON fc.artist=pa.artist_id
-    JOIN listensCount lc ON lc.artist=fc.artist
-    JOIN users u ON u.user_id=lc.artist
+    JOIN followersCount fc ON fc.user_id=pa.artist_id
+    JOIN listensCount lc ON lc.user_id=fc.user_id
+    JOIN users u ON u.user_id=lc.user_id
     WHERE not exists(
         SELECT 1
         FROM artists a
-        JOIN followersCount fc1 ON a.user_id=fc1.artist
-        JOIN listensCount lc1 ON lc1.artist=fc1.artist
+        JOIN followersCount fc1 ON a.user_id=fc1.user_id
+        JOIN listensCount lc1 ON lc1.user_id=fc1.user_id
         WHERE fc.event_id=fc1.event_id 
             AND (fc.followers<fc1.followers
                 OR (fc.followers=fc1.followers AND lc.listen_count<lc1.listen_count)
-                OR (fc.followers=fc1.followers AND lc.listen_count=lc1.listen_count AND lc.artist<lc1.artist)
+                OR (fc.followers=fc1.followers AND lc.listen_count=lc1.listen_count AND lc.user_id<lc1.user_id)
                 )
 );
+
 }}}
 
 ==== Релациона Алгебра
+
 {{{
 FollowersCount <-
-γ artist := a.user_id,
+γ user_id := a.user_id,
   event_id := pa.event_id;
   followers := COUNT(f.follower)
@@ -258 +260 @@
 
 ListensCount <-
-γ artist := a.user_id;
+γ user_id := a.user_id;
   listen_count := COUNT(l.timestamp)
 (
@@ -276 +278 @@
         ⨝ (e.event_id = pa.event_id) performs_at pa
       )
-      ⨝ (pa.artist_id = fc.artist) FollowersCount fc
-    )
-    ⨝ (fc.artist = lc.artist) ListensCount lc
-  )
-  ⨝ (lc.artist = u.user_id) users u
+      ⨝ (pa.artist_id = fc.user_id) FollowersCount fc
+    )
+    ⨝ ListensCount lc
+  )
+  ⨝ users u
 )
 
@@ -289 +291 @@
     fc.followers < fc1.followers
     ∨ (fc.followers = fc1.followers ∧ lc.listen_count < lc1.listen_count)
-    ∨ (fc.followers = fc1.followers ∧ lc.listen_count = lc1.listen_count ∧ lc.artist < lc1.artist)
+    ∨ (fc.followers = fc1.followers ∧ lc.listen_count = lc1.listen_count ∧ lc.user_id < lc1.user_id)
   )
 (
@@ -300 +302 @@
 BaseResult − π attributes(BaseResult)
 (
-  BaseResult ⨝ (BaseResult.artist = ToRemove.artist) ToRemove
+  BaseResult ⨝ ToRemove
 )