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