How is "no intro found" marked in the db

[Orko]

Greetings

How is “analyzed the media but intro could not be found” marked in the .db?
If an intro is found media_parts.extra_data has something like intros= in it but where is the marker for “nothing found”

[OttoKerner]

There is no such thing. It looks the same as if the show has never been scanned.

[Orko]

How does the plex server know not to search for intros again on the same files during the schedulded task window?

[OttoKerner]

AFAIK it stores something in the DB, but that doesn’t translate into the XML.

Here is a query which returns the IDs of the seasons which haven’t been scanned for some reason.

select distinct(metadata_items.parent_id) from metadata_items join media_items on metadata_items.id=media_items.metadata_item_id join media_parts on media_items.id=media_parts.media_item_id where metadata_items.metadata_type=4 and media_parts.extra_data not like '%pv^%3Aintros=%' escape '^' and metadata_items.id not in ( select distinct(metadata_items.id) from metadata_items join media_items on metadata_items.id=media_items.metadata_item_id join media_parts on media_items.id=media_parts.media_item_id where media_parts.extra_data like '%pv^%3Aintros=%' escape '^' ) order by metadata_items.added_at

[Orko]

Thanks, appreciated. I will try that

I am not looking at the XML but in the db, currently i am using this query to check for missing Intros:

SELECT file FROM media_parts INNER JOIN media_items ON media_parts.media_item_id = media_items.id INNER JOIN metadata_items ON media_items.metadata_item_id=metadata_items.id WHERE metadata_items.metadata_type IN (1,4) AND media_parts.file NOT LIKE '' AND media_parts.extra_data NOT LIKE '%intros%' AND file LIKE '%erie%';

(yes i know)

But this shows already scanned files with no intros found as well, so i am looking for the

@OttoKerner

AFAIK it stores something in the DB,

So I can script around that.

[OttoKerner]

That’s about all I can gather, sorry!

[Orko]

Tried it, works for me so far, thank you!