select s1.id, s1.title, s1.username, sum(plv.view_count) sumc from (SELECT pl.id, pl.title, u.username from playlist pl, user u where pl.author_id=u.id and pl.deleted=false and pl.submitted=true) s1 LEFT JOIN playlistviews plv
ON s1.id=plv.playlist_id group by s1.id order by sumc desc LIMIT 20, 20
DESTROY RATIONAL THOUGHT
Filter by Remixer
No bg audio?: audID from playlist is:
April 25, 2006: Thanks to everyone who made a remix, who played with the remixer and who made the trek to Edinburgh Castle on Monday night.
The event rawked. But it's not too late, keep on making remixes, we'll be leaving the best remixes up for posterity after the festival.