[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