Skip to content

Instantly share code, notes, and snippets.

@williamjacksn
Created May 20, 2011 14:47
Show Gist options
  • Save williamjacksn/983060 to your computer and use it in GitHub Desktop.
Save williamjacksn/983060 to your computer and use it in GitHub Desktop.
Rainwave SQL / Top songs by requests
select
song_title,
album_name,
song_totalrequests,
song_rating_avg,
rw_songs.sid
from
rw_songs
join
rw_albums using (album_id)
where
rw_songs.sid = 1 and
song_verified is true
order by
song_totalrequests desc
limit 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment