[mythtv-users] Channel subscription?

[chris at cpr.homelinux.net]

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?

-- 
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.