Michael Drons wrote: >> Empty set (0.00 sec) > > Try this query. > > 1) SELECT * FROM `recordedmarkup` where starttime='2009-12-01 12:00:00'
OK, but wouldn't this be a more specific query to try? SELECT * FROM recordedmarkup where chanid = 1023 AND starttime='2009-11-12T20:01:00' AND type IN (4, 5);+--------+---------------------+-------+--------+------+ | chanid | starttime | mark | offset | type | +--------+---------------------+-------+--------+------+ | 1023 | 2009-11-12 20:01:00 | 12380 | NULL | 4 | | 1023 | 2009-11-12 20:01:00 | 51447 | NULL | 4 | | 1023 | 2009-11-12 20:01:00 | 64755 | NULL | 4 | | 1023 | 2009-11-12 20:01:00 | 83205 | NULL | 4 | | 1023 | 2009-11-12 20:01:00 | 17540 | NULL | 5 | | 1023 | 2009-11-12 20:01:00 | 57748 | NULL | 5 | | 1023 | 2009-11-12 20:01:00 | 72905 | NULL | 5 | | 1023 | 2009-11-12 20:01:00 | 90088 | NULL | 5 | +--------+---------------------+-------+--------+------+ 8 rows in set (0.00 sec) > These are the markings of the commercials... 4 is the start and 5 is > the end. Looks like there are matches for that part of the original query. > Next we need the offsets. These are difficult to get. They reside in > the recordedseek table, but there are 1000s of records in the table. > The easy query would be: > SELECT * from recordedseek where chanid='XXX' and starttime='xxxxx' Lots of rows for that... mysql> SELECT * from recordedseek where chanid='1023' and starttime='2009-11-12T20:01:00'; +--------+---------------------+------+-----------+------+ | chanid | starttime | mark | offset | type | +--------+---------------------+------+-----------+------+ | 1023 | 2009-11-12 20:01:00 | 0 | 1064 | 7 | | 1023 | 2009-11-12 20:01:00 | 1 | 136260 | 7 | | 1023 | 2009-11-12 20:01:00 | 2 | 252444 | 7 | [...] | 1023 | 2009-11-12 20:01:00 | 3562 | 311293553 | 7 | | 1023 | 2009-11-12 20:01:00 | 3563 | 311377716 | 7 | | 1023 | 2009-11-12 20:01:00 | 3564 | 311449964 | 7 | +--------+---------------------+------+-----------+------+ 3511 rows in set (0.00 sec) They all have type=7, which explains why there were no matches in the original query, due to the "AND s.type = 9" clause. > The third column is the mark field. Subtract > 100 from your number, add 100 to the number and run this query: > > SELECT * from recorededseek where chanid='XXX' and starttime='xxxx' and > mark < (19608+100) and mark > (19608-100) You mean grab a mark value from the recordedmarkup table and query recordedseek for a +/-100 range around that value as a means of limiting the result set? Sure, but I think the prior result answered the question. -Tom ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Mvpmc-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/
