LEFT JOIN metadata_items ON media_tadata_item_id = metadata_items.If it wasn’t discovered automatically, don’t worry! You can set up aįrom the configuration menu, select Devices & Services.įrom the list, search and select Plex Media Server.įollow the instructions on screen to complete the setup.ĭuring setup, you will need to log in as a server administrator. Get all movies with their container and video codec WHERE taggings.tag_id IN (SELECT id FROM tags where tag_type=2)) as mtags ON taId = tadata_item_id LEFT JOIN tags ON taggings.tag_id = tags.id (SELECT metadata_items.id as metaId, metadata_items.title FROM metadata_items where metadata_type=2) as metas Get all TV Shows with their Tags-> Collections SELECT replace(replace(guid,'://',''),'?lang=en',''), title FROM metadata_items WHERE metadata_type = 1 Get a list of All movies with the closest column I could find to a direct IMBD ID (tt.)

I personally use SSMS but thats a fair amount more setup. Please go to the relevant subreddits and support forums, for example: Build help and build shares posts go in their respective megathreads No referral / affiliate links, personal voting / campaigning / funding, or selling posts Welcome to /r/Plex, a subreddit dedicated to Plex, the media server/client solution for enjoying your media! Plex Community Discord Rules Latest Regular Threads: No Stupid Q&A: Tool Tuesday: Build Help: Share Your Build: Submit Troubleshooting Post Files not showing up correctly?

Plex movies list