Code: Select all
SELECT p.member_id, COUNT(v.song) total
FROM votes v
JOIN playlist p
ON v.song = p.song_id
WHERE WEEK(`v.timestamp`,1) = WEEK(CURDATE(),1)
GROUP
BY v.song
ORDER BY total DESC
Thanks
Moderator: General Moderators
Code: Select all
SELECT p.member_id, COUNT(v.song) total
FROM votes v
JOIN playlist p
ON v.song = p.song_id
WHERE WEEK(`v.timestamp`,1) = WEEK(CURDATE(),1)
GROUP
BY v.song
ORDER BY total DESC