[mythtv-users] Channel subscription?
Michael T. Dean
mtdean at thirdcontact.com
Sun Nov 20 15:06:09 EST 2005
chris at cpr.homelinux.net 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
More information about the mythtv-users
mailing list