Changes between Version 4 and Version 5 of AdvancedDatabaseDevelopment

Timestamp:

02/11/26 21:40:48 (2 weeks ago)

Author:

231136

Comment:

--

AdvancedDatabaseDevelopment

@@ -379 +379 @@
 
 {{{
-create materialized view top_songs_by_listens as
+CREATE materialized VIEW top_songs_by_listens AS
 SELECT s.id, me.title, me.genre, u.full_name, u.username, me.cover, s.album_id
 FROM songs s
-JOIN listens l on l.song_id = s.id
-JOIN musical_entities me on s.id = me.id
-JOIN users u on u.user_id = me.released_by
+JOIN listens l ON l.song_id = s.id
+JOIN musical_entities me ON s.id = me.id
+JOIN users u ON u.user_id = me.released_by
 GROUP BY
     s.id, me.title, me.genre, u.full_name, u.username, me.cover, s.album_id
-ORDER BY count(*) desc
+ORDER BY count(*) DESC
 LIMIT 10;
 }}}