sqlite - DB query - reporting

[medianut86 0]

I'm running Emby on a Synology NAS. 

 

I've found the library.db file

/volume1/@appstore/EmbyServer/var/data/library.db

 

and copied it over to my PC for analysis.

 

I've discovered that table TypedBaseItems seems to have the movie names in there.  Specifically I've been searching using the Path and isFolder entries to find my specific movies.

 

I've also discovered that table mediastreams seems to have all of the specific movie codec details here.  

 

I can't seem to tie the 2 together to do any meaningful searches.  I'm looking to run a report to see the aspect ratio of all my movies.  I can find the movie under TypedBaseItems, and the aspect ratio under mediastreams but can't find a correlation between the two.

 

Can a dev point me in the right direction?

[Luke 42080]

You can tie them together with guid/id