[mythtv-users] SQL for Myth

[Kevin Kuphal]

Edward M. Brown wrote:
> I have a SQL command to find all shows that match credits of people I have entered into the people search list. It works fine if you run it in MySQL.
>
> select people.name, program.title, program.subtitle, program.starttime from ((keyword inner join people on people.name = keyword.phrase) inner join credits on credits.person = people.person) inner join program on program.chanid = credits.chanid and program.starttime = credits.starttime;
>
> What I would like to be able to do is adapt this somehow to create a pick list of programs based on people in my list. 
>
> I played around with trying to get this to work with Custom Record, but didn't have any success. Also the Custom Record capability automatically records programs, I'm trying to create a pick list.
>
> Any suggestions, ideas would be appreciated
>
>   
You should be able to go into the Search Lists and create a keyword 
search for the person you want.  I've done this for "Robin Williams". 

You can then view this query in the frontend whenever you want.  You can 
also create a recording rule from this.  I would suggest doing this, but 
setting the rule to be inactive.  This will cause all showings to show 
up in the Upcoming Recordings screen in white where you can then add 
individual overrides for any showing you want to record.

Kevin