Untitled

mysql> select * from recordedprogram a where 1 < (select count(*) from recordedprogram b where a.chanid = b.chanid and a.starttime = b.starttime);  +--------+---------------------+---------------------+---------------------------+--------------------------+-------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+

| chanid | starttime           | endtime             | title                     | subtitle                 | description | category | category_type | airdate | stars | previouslyshown | title_pronounce | stereo | subtitled | hdtv | closecaptioned | partnumber | parttotal | seriesid | originalairdate | showtype | colorcode | syndicatedepisodenumber | programid | manualid | generic | listingsource | first | last | audioprop | subtitletypes | videoprop |

+--------+---------------------+---------------------+---------------------------+--------------------------+-------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+

|   7284 | 2010-01-18 12:00:00 | 2010-01-18 14:25:00 | P USA (Manual Record)     | Mon Jan 18 12:00:00 2010 |             |          |               |    0000 |     0 |               0 |                 |      0 |         0 |    0 |              0 |          0 |         0 |          | NULL            |          |           |                         |           |     1690 |       0 |             0 |     0 |    0 | HARDHEAR  |               |           |

|   7284 | 2010-01-18 12:00:00 | 2010-01-18 14:35:00 | party USA (Manual Record) | Mon Jan 18 12:00:00 2010 |             |          |               |    0000 |     0 |               0 |                 |      0 |         0 |    0 |              0 |          0 |         0 |          | NULL            |          |           |                         |           |     1691 |       0 |             0 |     0 |    0 | HARDHEAR  |               |           |

+--------+---------------------+---------------------+---------------------------+--------------------------+-------------+----------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+---------------+-------+------+-----------+---------------+-----------+

2 rows in set (0.00 sec)