Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save deviationist/72d763ff57fdf51e6ee8e302a0c04ca8 to your computer and use it in GitHub Desktop.
Save deviationist/72d763ff57fdf51e6ee8e302a0c04ca8 to your computer and use it in GitHub Desktop.
rekordbox-duplicate-track-finder.sql
SELECT
FullTitle,
COUNT(FullTitle) as COUNT
FROM (
SELECT
CONCAT(Title, " - ", Name) AS FullTitle
FROM djmdContent AS c
INNER JOIN djmdArtist AS a ON c.ArtistID = a.ID
WHERE
a.rb_local_deleted = 0
AND c.rb_local_deleted = 0
)
GROUP BY FullTitle
HAVING Count > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment