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) s1 LEFT JOIN playlistviews plv  
							ON s1.id=plv.playlist_id group by s1.id order by sumc desc LIMIT 20, 20
Something Inside
The Video Doctor Filter by Remixer
DIRECTOR’S CLIP The Fish DIRECTOR Sarah Blake Filter by Clip more info
DIRECTOR’S CLIP Shoes DIRECTOR Jake Sawyer Filter by Clip more info
DIRECTOR’S CLIP Big Girl DIRECTOR Renuka Jeyapalan Filter by Clip more info
DIRECTOR’S CLIP The Light DIRECTOR Mark Decena Filter by Clip more info
DIRECTOR’S CLIP Expectations DIRECTOR Gilberto Francisco Filter by Clip more info
DIRECTOR’S CLIP Indio Nacional DIRECTOR Raya Martin Filter by Clip more info
DIRECTOR’S CLIP Remain Upright DIRECTOR Kristijan Risteski Filter by Clip more info
BACKGROUND AUDIO: Marimba 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.