How can I query the Plex database to get a listing of my content?

I added a SQL example for displaying the path, or folder and file structure for movies and extras. Can also be used for other media types.

Sample Database queries for Movies and TV Shows