selectRemixes:
select s1.id, s1.title, s1.username, sum(plv.view_count) sumc from (SELECT DISTINCT pl.id, pl.title, u.username from playlist pl, user u, segment s, playlistsegs pls where pl.id=pls.playlist_id and pls.segment_id=s.id and s.media_id=10002 and 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 0, 20
My Remix
kwlt69 Filter by Remixer
DIRECTOR’S CLIP Home Delivery DIRECTOR Elio Quiroga Filter by Clip more info
DIRECTOR’S CLIP Happy Birthday DIRECTOR Justin Reckart Filter by Clip more info
DIRECTOR’S CLIP A Drive Thru Society DIRECTOR Sandra Wong Filter by Clip more info
DIRECTOR’S CLIP Expectations DIRECTOR Gilberto Francisco Filter by Clip more info
BACKGROUND AUDIO: Light Orchestra Filter by Audio
Don't forget!
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.