CREATE VIEW md5_dups AS
SELECT md5, COUNT(*) AS instances FROM media GROUP BY md5 HAVING COUNT(*)>1

##</code><code>##

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