How to join Plex DB table media_parts to retrieve metadata_item_id ?

General Discussions
1

I would like to retrieve metadata_item_id for each record in media_parts that does not match with query:sqlite> select count(*) from media_parts where extra_data not like '%deepAnalysisVersion=2%';

Since media_parts is collection of individual files iam not sure on what tables to join to get metadata_item_id

2

Did you still need an answer? I saw you got help to a similar issue in https://forums.plex.tv/discussion/254998/plex-db-where-is-the-flag-for-analyze-deeply#latest.

3

Not anymore, thanks for asking, marked this one as answered.