Skip to content

Instantly share code, notes, and snippets.

@FMCorz

FMCorz/kodi.sql

Last active March 15, 2026 13:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save FMCorz/a298298c1be9742a219a462779d2b058 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save FMCorz/a298298c1be9742a219a462779d2b058 to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicate movies in Kodi
Raw
kodi.sql
-- Find the file ~/.kodi/userdata/MyVideosXX.db
-- Open with sqlite3
-- Run the following statement:
SELECT
m.c00, -- Movie name
p.strPath, -- Path
f.strFilename -- File name
FROM movie m
JOIN movie m2 -- Join on self to find duplicates
ON m.c09 = m2.c09 -- Map on IMDB ID
AND m.idMovie != m2.idMovie -- Only if not same entry
JOIN files f -- Join file information
ON f.idFile = m.idFile
JOIN path p -- Join path information
ON p.idPath = f.idPath;
@fonic
Copy link

fonic commented Mar 14, 2026 •
edited
Loading

As of 03/2026, database contents seem to have changed slightly: field m.c09 now stores some sort of unique ID which does not seem to be of much use when trying to identify duplicates (see https://kodi.wiki/view/Databases/MyVideos#movie).

However, relying on movie name/title + release date instead worked for me:

SELECT
    m.c00,                       -- Movie name/title
    p.strPath,                   -- Source path
    f.strFilename                -- File name
FROM movie m

JOIN movie m2                    -- Join on self to find duplicates
  ON m.c00 = m2.c00              -- Map on movie name/title ...
 AND m.premiered = m2.premiered  -- ... and movie release date
 AND m.idMovie != m2.idMovie     -- Only if not same entry

JOIN files f                     -- Join file information
  ON f.idFile = m.idFile

JOIN path p                      -- Join path information
  ON p.idPath = f.idPath

ORDER BY m.c00;                  -- Order results by movie name/title

Save the SQL statement above to file find-duplicates.sql and then run:
sqlite3 --readonly ~/.kodi/userdata/MyVideosXXX.db < find-duplicates.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment