CREATE VIEW media_dups AS 
SELECT media.* FROM media INNER JOIN md5_dups
ON media.md5=md5_dups.md5 ORDER BY media.md5