by IanRTaylorUK » Sat May 30, 2026 10:50 am
You may want to try the following in SQl Editor:
SQL 046 Video Quality & Bitrate Audit
Purpose:
Analyzes your Video and TV Show library to find low-resolution files or files with missing dimensions, helping you target items for High Definition (HD) upgrades.
Clean SQL:
Code: Select all
SELECT
TrackType, SongTitle,
VideoWidth || 'x' || VideoHeight AS Resolution,
CASE
WHEN VideoWidth >= 1920 THEN '🟢 1080p+'
WHEN VideoWidth >= 1280 THEN '🟡 720p'
ELSE '🔴 SD/Low Res'
END AS QualityStatus,
ROUND(FileLength / (1024.0 * 1024.0), 2) || ' MB' AS Size
FROM Songs
WHERE TrackType IN (4, 5, 6, 7)
ORDER BY VideoWidth DESC;
MMW5 / MMW2024. Uses arithmetic operations and ROUND function within SQLite.
Note
The SQL Editor add-on for MMW2024 typically limits the display to 1000 "records". Also you may wish to edit the video width to reflect your own definition of what is 1080p / 720p etc.
Hope this helps.
You may want to try the following in SQl Editor:
[b]SQL 046 Video Quality & Bitrate Audit[/b]
[i]Purpose:[/i]
Analyzes your Video and TV Show library to find low-resolution files or files with missing dimensions, helping you target items for High Definition (HD) upgrades.
[i]Clean SQL:[/i]
[code]SELECT
TrackType, SongTitle,
VideoWidth || 'x' || VideoHeight AS Resolution,
CASE
WHEN VideoWidth >= 1920 THEN '🟢 1080p+'
WHEN VideoWidth >= 1280 THEN '🟡 720p'
ELSE '🔴 SD/Low Res'
END AS QualityStatus,
ROUND(FileLength / (1024.0 * 1024.0), 2) || ' MB' AS Size
FROM Songs
WHERE TrackType IN (4, 5, 6, 7)
ORDER BY VideoWidth DESC;
[/code]
[i]Provenance & Compatibility:[/i]
MMW5 / MMW2024. Uses arithmetic operations and ROUND function within SQLite.
[i]Note[/i]
The SQL Editor add-on for MMW2024 typically limits the display to 1000 "records". Also you may wish to edit the video width to reflect your own definition of what is 1080p / 720p etc.
Hope this helps.