[mythtv-users] Fall cable reruns and mythTV

David Linville dlinvill at networksdown.com
Wed Sep 3 16:33:22 UTC 2008


On Tue, Sep 2, 2008 at 8:07 PM, <mons37318 at mypacks.net> wrote:

>
> Do we have a way to tell myth to list (but not record, as in the new pilot
> search) pilot episodes of old series that we a. didn't watch at the time
> they were new or b. never were aware of to begin with?
>
> the *new* pilot search is as follows
>
> program.previouslyshown = 0
> AND program.first > 0
> AND program.programid LIKE 'EP%0001'
> AND DAYOFYEAR(program.originalairdate) =
>    DAYOFYEAR(program.starttime)
>
> i'm guessing that the program.previously shown (at least, and possibly
> something else - my SQL isn't that great) will disinclude Old pilots. at
> least if it = 0
>


I just tried

program.first > 0
AND program.programid LIKE 'EP%0001'
AND DAYOFYEAR(program.originalairdate) <   DAYOFYEAR(program.starttime)

which seems to do exactly what you want but I get 5-6 'old pilots' per day
so for me  it really would only work as a search and not a record rule.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080903/9e666352/attachment.htm 


More information about the mythtv-users mailing list