[wkearney99]

Is there a way to use Custom Media Lists to find movies that haven't have their actor metadata scanned?

I'm not sure which SQL joins would find this.

Show a list of just movies that have no actor metadata.

[wkearney99]

Some more searching here turned up this post that seems to cover it: https://forum.kodi.tv/showthread.php?tid...pid3116055

Go into Edit->Settings->Miscellaneous->Media List Editor

Next to 'CREATE VIEW' enter a name you want to use to select this from the Filters section List drop-down.  I called mine "missing_actors"

Put this in the text box below:

sql:


SELECT DISTINCT

 movielist.*

FROM

 movielist

LEFT OUTER JOIN actorlinkmovie ON (actorlinkmovie.idMovie = movielist.idMovie)

GROUP BY

 movielist.idMovie

HAVING COUNT(actorlinkmovie.idMovie) = 0

Press the [+ Add] button.  And then OK the settings and get back your list of movies.

The the Filters section (at the bottom left) select the List drop-down and you'll see the view you created above (again, I called mine 'missing_actors').

Basically we're combining two database tables into a view.  One table that has the movies, joined against another table of actors with that same id (but with zero records).  As in, are there any movies that don't have any actors linked?

[wkearney99]

The only downside is there doesn't seem to be a Rescrape for the actors and their thumbnails.  There is one for actor thumbnails, but that presumes the actor metadata is already present, and is using that to scrape new headshots. 

Near as I can tell to get both the actor metadata and their thumbnails you have to rescrape the whole movie.  Not awful but takes more time.

[wkearney99]

What would be the right way to find movies where the actors didn't have a thumbnail URL?

There's an actors table with idActor and a strThumb field for the URL. 

How do I get the list to contain just movies with actors missing a thumbnail image URL?  My SQL join skills are pretty rusty.