[DB Find duplicates in multiple fields]

duplicates.sql

SELECT c.uid as "CE uid", c.pid as "CE pid", uid_foreign, uid_local, count(*) as NumDuplicates

FROM sys_file_reference s
JOIN tt_content c ON (c.uid = s.uid_foreign)

WHERE s.tablenames = "tt_content"
    AND s.deleted = 0
    AND c.deleted = 0

GROUP BY uid_foreign, uid_local 
HAVING NumDuplicates > 1
#ORDER BY c.pid ASC
;