Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT rp.song_id, COUNT(rp.song_id) AS times_played FROM radios_playlists AS rp WHERE rp.start_date >= '2009-11-30 00:00:00' AND rp.start_date <= '2009-12-06 23:59:59' GROUP BY rp.song_id ORDER BY times_played DESC LIMIT 5
Add Comment
Please, Sign In to add comment
