<div dir="ltr"><br><br><div class="gmail_quote">On Wed, Sep 3, 2008 at 11:33 AM, David Linville <span dir="ltr"><<a href="mailto:dlinvill@networksdown.com">dlinvill@networksdown.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div dir="ltr"><div class="Ih2E3d">On Tue, Sep 2, 2008 at 8:07 PM, <span dir="ltr"><<a href="mailto:mons37318@mypacks.net" target="_blank">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></div>I just tried<div class="Ih2E3d">
<br><br>program.first > 0<br>
AND program.programid LIKE 'EP%0001'<br>
AND DAYOFYEAR(program.originalairdate) < DAYOFYEAR(program.starttime)<br><br></div>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.</div>
</blockquote><div><br></div><div>The guide information may not contain the program.programid in the format you specified. Try removing that line</div><div><br></div><div>Kevin</div></div></div>