<div dir="ltr">On Tue, Sep 2, 2008 at 8:07 PM, <span dir="ltr"><<a href="mailto:mons37318@mypacks.net">mons37318@mypacks.net</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
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?<br>
<br>
the *new* pilot search is as follows<br>
<br>
program.previouslyshown = 0<br>
AND program.first > 0<br>
AND program.programid LIKE 'EP%0001'<br>
AND DAYOFYEAR(program.originalairdate) =<br>
DAYOFYEAR(program.starttime)<br>
<br>
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<br></blockquote></div><br><br>I just tried<br><br>program.first > 0<br>
AND program.programid LIKE 'EP%0001'<br>
AND DAYOFYEAR(program.originalairdate) < DAYOFYEAR(program.starttime)<br><br>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.<br>
<br><br>
</div>