[gotham2014]

Hi,

Can anybody tell me the correct MySql query to retrieve the following out of the KODI v17.3 DB:

* Retrieve all movies with 720p quality.
* Retrieve all episodes with 720p quality.
* And the same for both above but than <720p or no known quality associated. (is this possible?)

Thanks for the assistance.

ps. did not find the correct threat to place this question into, hope its ok in here.

[Klojum]

Thread moved to the Independent section.

Searching for 720p videos can be done via the height or the width of a video. I find using the width more reliable, as plenty of 21:9 movies are also available.
Cloudflare is acting up when trying to send SQL queries, and it doesn't allow them in my post...

[gotham2014]

Thanks for the quick response and tip Klojum.

Just wondering if this would also output 1080p movies together with 720p movies? I only like 720p movies to be shown, as I like to have this list to to show me which movies and tv show episodes I still need to upgrade to 1080p. :-)
 

Thread moved to the Independent section.

Searching for 720p videos can be done via the height or the width of a video. I find using the width more reliable, as plenty of 21:9 movies are also available.
Cloudflare is acting up when trying to send SQL queries, and it doesn't allow them in my post...

[Klojum]

Just wondering if this would also output 1080p movies together with 720p movies?

If you want 720p and everything above, then use s.iVideoWith >= 1280.
if you want 720p and above but up to 1080p videos, then use s.iVideoWith >= 1280 AND s.iVideoWith <= 1920.

I'm sure you can think of more scenarios.

[gotham2014]

Ah, so anything that has a s.iVideoWith of 1920 is considered 1080p, while the height could be 1080px or around this number.

Thanks again!

Just wondering if this would also output 1080p movies together with 720p movies?

If you want 720p and everything above, then use s.iVideoWith >= 1280.
if you want 720p and above but up to 1080p videos, then use s.iVideoWith >= 1280 AND s.iVideoWith <= 1920.

I'm sure you can think of more scenarios.