[mythtv-users] SQL for Myth

Edward M. Brown edwardb at gmail.com
Thu Apr 13 17:32:22 UTC 2006


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



More information about the mythtv-users mailing list