selectRemixes:
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 and pl.bg_audio_id=10030 ) s1 LEFT JOIN playlistviews plv  
							ON s1.id=plv.playlist_id group by s1.id order by sumc desc LIMIT 0, 20
Couples
rdhyee Filter by Remixer
DIRECTOR’S CLIP Hide And Seek DIRECTOR Charlie Canfield Filter by Clip more info
DIRECTOR’S CLIP 2-14 DIRECTOR Xi-Yan Chen Filter by Clip more info
DIRECTOR’S CLIP Big Girl DIRECTOR Renuka Jeyapalan Filter by Clip more info
DIRECTOR’S CLIP Dazed DIRECTOR Anne Pinheiro Guimarães Filter by Clip more info
DIRECTOR’S CLIP Happy Birthday DIRECTOR Justin Reckart Filter by Clip more info
DIRECTOR’S CLIP Never Live Above a Psychic DIRECTOR Steve Gentile Filter by Clip more info
DIRECTOR’S CLIP Roberto the Insect Architect DIRECTOR Galen Fott Filter by Clip more info
DIRECTOR’S CLIP Slip of the Tongue DIRECTOR Karen Lum Filter by Clip more info
BACKGROUND AUDIO: Classical Strings 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.