Выбрать все НЕуникальные значения mysql

SELECT * FROM `photos` WHERE `hash` IN (SELECT `hash` FROM `photos` GROUP BY `PID` HAVING COUNT(*) > 1)