Kodi Community Forum

I'm looking to purge some videos and was wondering if someone could help me with a MySQL query for videos with quality less than 720p. Ideally it would list:

Title, File Name, Path, Quality/Resolution (not sure how it's stored)

From there I could convert to simple batch process to delete and cleanup. If you recommenced another approach let me know.

Thanks in advance

This should get you most of the way there:

SELECT CONCAT(strPath, strFilename) AS fullpath, iVideoWidth, iVideoHeight FROM files JOIN streamdetails ON files.idFile = streamdetails.idFile JOIN path ON files.idPath = path.idPath WHERE streamdetails.iStreamType = 0 AND iVideoWidth < 1280;

Thanks I will give it a shot.