[mythtv-users] SQL for Myth
Edward M. Brown
edwardb at gmail.com
Thu Apr 13 22:02:49 UTC 2006
Here is what I ended up with in Custom Search:
Aditional tables: , people, credits, keyword
people.name = keyword.phrase
AND credits.person = people.person
AND program.chanid = credits.chanid
AND program.starttime = credits.starttime
If you want to have it show commercial free channels and you have
commfree set in the database add:
AND channel.commfree = true
I set this search to inactive as Kevin suggested and now they appear
in the Upcoming Recordings screen
Ed
More information about the mythtv-users
mailing list