J-e-f-f-A dup recordings example

mysql> select programid,starttime,title,left(subtitle,80) from oldrecorded where title = "Cops" and subtitle = "Liar Liar" order by programid,starttime; +----------------+---------------------+-------+-------------------+
| programid      | starttime           | title | left(subtitle,80) |
+----------------+---------------------+-------+-------------------+
| EP000170700759 | 2010-03-23 18:00:00 | Cops  | Liar Liar         |
| EP000170700759 | 2010-09-15 00:30:00 | Cops  | Liar Liar         |
| EP000170700759 | 2010-12-30 17:30:00 | Cops  | Liar Liar         |
| EP000170700759 | 2011-03-03 21:00:00 | Cops  | Liar Liar         |
| EP000170700759 | 2011-04-23 16:00:00 | Cops  | Liar Liar         |
| EP000170700759 | 2011-08-11 22:00:00 | Cops  | Liar Liar         |
| EP000170700759 | 2011-11-13 17:00:00 | Cops  | Liar Liar         |
| EP000170700759 | 2012-01-09 17:30:00 | Cops  | Liar Liar         |
+----------------+---------------------+-------+-------------------+
8 rows in set (0.01 sec)

mysql>