[mythtv-users] Premieres rule
Brian J. Murrell
brian at interlinx.bc.ca
Tue Jul 13 13:07:12 UTC 2010
I'm using a search of the form:
SELECT program.chanid, program.title, program.subtitle, program.starttime FROM program
LEFT JOIN record as r ON program.title = r.title AND program.subtitle = r.subtitle
WHERE r.title IS NULL AND program.starttime > NOW() AND program.first > 0
AND program.programid LIKE "EP%0001" AND program.originalairdate = DATE(program.starttime)
ORDER BY program.starttime, program.title
to find "premiere" episodes that I've not scheduled for recording. I've
found a problem with it though in that it didn't find a particular
premiere episode, so I queried the database to see why:
mysql> select title,programid,starttime,originalairdate from program where programid LIKE "EP%0001" and title = "Hot in Cleveland";
+------------------+----------------+---------------------+-----------------+
| title | programid | starttime | originalairdate |
+------------------+----------------+---------------------+-----------------+
| Hot in Cleveland | EP012599310001 | 2010-07-05 20:00:00 | 2010-06-16 |
| Hot in Cleveland | EP012599310001 | 2010-07-05 20:00:00 | 2010-06-16 |
| Hot in Cleveland | EP012599310001 | 2010-07-10 19:30:00 | 2010-06-16 |
| Hot in Cleveland | EP012599310001 | 2010-07-10 17:30:00 | 2010-06-16 |
+------------------+----------------+---------------------+-----------------+
4 rows in set (12.72 sec)
As can be seen, it aired after it's originalairdate. :-(
Since I do this search daily and I keep a history of the searches, I
searched through all of June to see if this was ever matching and it
never did, so I can only assume that for whatever reason, the actual air
date of the premiere episode(s) was delayed from it's original air date.
I tried removing the
program.originalairdate = DATE(program.starttime)
condition but way too many false positives came up.
Any ideas?
b.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100713/5bf05120/attachment.pgp>
More information about the mythtv-users
mailing list