On Sun, Nov 20, 2005 at 03:06:09PM -0500, Michael T. Dean wrote:
> >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.
Must be an SVN thing. I'm running 0.18.1-5 and it has no such example
on my system. It does have a "new episodes" rule but that simply looks
for anything that's not a repeat, whereas I'm looking for series/season
premiers.
--
Joke template: Three guys walk into a bar. One of them is a wee bit
stupid, and the whole scene unfolds with a tedious inevitability.
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
