Rainwave SQL / High-rated songs and whether they are favourites

rw_high_rated_songs_favourites.sql

select
	rw_songs.sid,
	album_name,
	song_title,
	song_rating,
	case when f.user_id = 9575 then true else false end as fav
from
	rw_songratings
		join
	rw_songs using (song_id)
		join
	rw_albums using (album_id)
		left join (
			select
				*
			from
				rw_songfavourites
			where
				user_id = 9575
		) as f using (song_id)
where
	rw_songratings.user_id = 9575 and
	song_rating > 4 and
	song_verified is true
order by
	rw_songs.sid,
	album_name,
	song_title;