SELECT a.path,a.name, a.UnratedType
FROM TypedBaseItems a
JOIN (SELECT name, path, UnratedType
FROM TypedBaseItems
WHERE UnratedType = 'Movie'
GROUP BY name
HAVING COUNT(*) > 1 ) b
ON a.name = b.name
ORDER BY a.name