I'm trying to get movie and cast from library.db

[robcampbell 1]

How are the tables linked to view the cast?  

Version 4.6.7.0

Is this not possible?

[Luke 42078]

Hi, yes now take that and join on mediaitems with itemid

[robcampbell 1]

What am I joining?  I am able to id the role, I am trying to the cast member's name.  How am I joining UserDataKey2 to ItemPeople?

[Luke 42078]

This will give you cast, actor name, and media name altogether:

select ItemPeople.*,MediaItemsPeople.Name as PersonName,MediaItemsMedia.Name as MediaName from ItemPeople
join MediaItems MediaItemsPeople on MediaItemsPeople.Id=ItemPeople.PersonId
join MediaItems MediaItemsMedia on MediaItemsMedia.Id=ItemPeople.ItemId
order by MediaName,ListOrder

I constructed this query using the 4.8 beta channel. It should work on 4.6 and 4.7 though I'm pretty sure.

[robcampbell 1]

Thank you. 

I didn't think to search MediaItems for people's name.