2022-09-18, 16:07
Anyone have handy the SELECT statement for missing posters for movies? I'm looking for the MyVideos119.db SQL statement.
2022-09-18, 16:41
You mention MySQL in the thread title, but the fanart cache is also handled via the local SQLite Textures13.db file.
So what exactly are trying to find, as in "missing how?"
(Thread also moved away from the Video support forum section).
So what exactly are trying to find, as in "missing how?"
(Thread also moved away from the Video support forum section).
2022-09-18, 20:20
I'm looking for the equivalent of the below for movie posters (and fanart) ... i used the below example to backfill missing artist thumbs and fanart for my music collection. Once I get a list of posters missing for my movie collection I will upload them to the appropriate scraping site (i have an extensive collection of posters I collected when Kodi used to be Meedio and there was no scraping). I figured textures13 was somehow involved so I couldn't clone my music sql.
SELECT artist.idArtist, strArtist
FROM artist
WHERE EXISTS (SELECT 1 FROM album_artist
WHERE album_artist.idArtist = artist.idArtist)
AND
NOT EXISTS (SELECT 1 FROM art
WHERE art.media_id = artist.idArtist
AND art.media_type = "artist"
AND art.type = "fanart")
SELECT artist.idArtist, strArtist
FROM artist
WHERE EXISTS (SELECT 1 FROM album_artist
WHERE album_artist.idArtist = artist.idArtist)
AND
NOT EXISTS (SELECT 1 FROM art
WHERE art.media_id = artist.idArtist
AND art.media_type = "artist"
AND art.type = "fanart")
