SQLite Metadata Query

Plex Media Server
, ,
1

Hello,

I was just wondering if anyone has a handy answer as to what query I would need to perform in order to list all the media items in each library which have NO Tags defined. I’m sure there’s a useful INNER JOIN multi-table query which would provide this information, I’m just not as familiar with the schema as I’d like to be.

Thanks in advance if anyone can help me out!

Regards,

weasel5i2

2

What kind of tags are you talking about?

3

Are you able to import the db into something like dbeaver? Then the primary keys should join across tables after import on the database view in dbeaver, then query. If I may ask, what are you trying to find? Whats the goal here?