[mythtv-users] UK: Strictly Come Dancing E1S12, looks like a dupe
mythtv at phipps-hutton.freeserve.co.uk
mythtv at phipps-hutton.freeserve.co.uk
Fri Sep 19 05:38:26 UTC 2014
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)
More information about the mythtv-users
mailing list