sql:
SELECT c00, dateadded AS DateAdded,

         'Dupe Movie' AS description,

 strfilename AS FILE, 

 strPath AS FILE

FROM movie_view a

JOIN (

SELECT uniqueid_value

FROM movie_view

GROUP BY uniqueid_value

HAVING COUNT(*) > 1) b ON a.uniqueid_value = b.uniqueid_value

ORDER BY strfilename ASC;

(2018-03-30, 13:10)menno Wrote:   Now is there a way to nicely clean return of this command (aka the duplicates) from the database.
For me finding them is step 1, now how to clean them, and clean them from all tables?
Simply replace select with delete?

(2017-04-07, 23:55)zerocool_ie Wrote: if you're SQL-savvy, this is what I use for Krypton dupe finding

Code:

SELECT c00 as 'Title',
strPath AS 'Path',
strfilename AS 'File'
FROM movie_view a
JOIN (
SELECT uniqueid_value
FROM movie_view
GROUP BY uniqueid_value
HAVING COUNT(*) > 1) b ON a.uniqueid_value = b.uniqueid_value
ORDER BY strfilename ASC;