Changes between Initial Version and Version 1 of AddSongImportant

Timestamp:

01/20/26 16:10:23 (10 days ago)

Author:

231017

Comment:

--

AddSongImportant

@@ +1 @@
+== Заследување на корисник
+=== Актери
+- Најавен артист 
+=== Чекор 1 
+Артистот прристапува до својот личен профил
+
+
+{{{
+SELECT u.username,
+       u.full_name,
+       u.profile_photo,
+
+        COUNT(DISTINCT follower)as follower_cnt,
+        COUNT(DISTINCT followee) as followee_cnt
+
+FROM Artists a
+JOIN Non_admin_users nau ON a.user_id=8 AND nau.user_id=8
+JOIN Users u ON u.user_id=nau.user_id
+JOIN Follows f ON f.followee=u.user_id OR f.follower=u.user_id
+GROUP BY u.username ,u.full_name, u.profile_photo
+
+
+
+SELECT me.title,
+       ac.role,
+       me.genre
+
+FROM Artists a
+         JOIN Non_admin_users nau on a.user_id=8 and nau.user_id=8
+         JOIN Users u on u.user_id=nau.user_id
+
+         JOIN Artist_contributions ac on ac.artist_id=8
+         JOIN Musical_entities me on me.id=ac.musical_entity_id
+        ORDER BY
+            CASE
+                WHEN ac.role='MAIN_VOCAL'  THEN 0
+                ELSE 1
+                END
+}}}
+
+
+=== Чекор 2
+
+
+
+
+
+
+
+
+