Changes between Version 9 and Version 10 of QueryOptimization

Timestamp:

05/18/26 10:40:25 (8 days ago)

Author:

231017

Comment:

--

QueryOptimization

@@ -555 +555 @@
     a.display_name AS artist_display_name,
     s.visibility AS song_visibility,
-    u.username AS label_admin_username,
     l.name AS label_name,
     sc.total_streams
@@ -561 +560 @@
 JOIN songs s ON s.id = sc.song_id
 JOIN artists a ON s.owner_artist_id = a.id
-LEFT JOIN label_admins la ON s.published_by_label_admin_id = la.id
-LEFT JOIN labels l ON l.id = la.label_id
-LEFT JOIN users u ON u.id = la.user_id;
+LEFT JOIN labels l ON l.id = s.published_by_label_id;
+
 }}}