[mythtv-users] UK: Strictly Come Dancing E1S12, looks like a dupe

[mythtv at phipps-hutton.freeserve.co.uk]

Quoting Karl Dietz <dekarl at spaetfruehstuecken.org>:

>
> Tim, can we see the result of this modified query please? (replace
> recorded with recordedprogram)
>
> select title, subtitle, season, episode, starttime, programid from  
> recordedprogram where title like 'Strictly%Dancing';
>
> Looking at recorded will only show the season/episode from thetvdb,  
> but not from the guide feed!
>

Also I may very well have set those numbers to zero while I was trying  
to figure out why it was being considered a dupe (before I knew about  
programid) so don't rely ont hose. Here's the recordedprogram query:

mysql> select title, subtitle, seriesid, syndicatedepisodenumber,  
starttime, programid from recordedprogram where title like  
'Strictly%Dancing';
+-----------------------+----------------------------------------+-----------+-------------------------+---------------------+---------------+
| title                 | subtitle                               |  
seriesid  | syndicatedepisodenumber | starttime           | programid   
    |
+-----------------------+----------------------------------------+-----------+-------------------------+---------------------+---------------+
| Strictly Come Dancing | Strictly Come Dancing: The Launch Show |  
102474247 | E1S12                   | 2014-09-07 19:00:00 |  
EP1024742471c |
+-----------------------+----------------------------------------+-----------+-------------------------+---------------------+---------------+
1 row in set (0.00 sec)