[EMAIL PROTECTED] wrote:
On Sun, Nov 20, 2005 at 01:56:04AM -0800, Bruce Markey wrote:
I do use Inactive for stuff that I do want to see in the the
schedule. First Episodes for one.
I never thought of grabbing firsts, but it sounds like an interesting
way to find new things to watch. What search syntax do you use? The
best I can come up with on short notice would be:
program.category_type='series'
AND program.previouslyshown=0
AND program.syndicatedepisodenumber REGEXP '^0*1$'
AND program.category NOT IN ('Children','Animated')
The only thing that would miss is pilots. Do they show up as a
distinct category_type when they're in the schedule?
Custom Record (as per http://mythtv.org/docs/mythtv-HOWTO-12.html#ss12.5
). One of the example SQL queries (use right and left arrows to select
example clauses) is for first episodes.
Mike
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
