selectRemixes:
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=10001 and pl.author_id=u.id and pl.deleted=false and pl.submitted=true order by pl.mod_time desc LIMIT 0, 20
Wade Remix
bmcferren Filter by Remixer
DIRECTOR’S CLIP 2-14 DIRECTOR Xi-Yan Chen Filter by Clip more info
DIRECTOR’S CLIP The Boat DIRECTOR Alexandra Hontales-Adams Filter by Clip more info
BACKGROUND AUDIO: Froggy 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.