[mythtv-users] Join DB table recordedprogram to recorded

[Nicolas Krzywinski]

Hello,

I just found out that the database table's fields recordedprogram.starttime and recorded.starttime does not qualify for joining, as it is documented in the wiki: http://www.mythtv.org/wiki/Recordedprogram_table.
Whereas recorded.starttime seems to represent the real start of recording, recordedprogram.starttime seems to tell the original start of the broadcast.

Instead, recordedprogram.title = recorded.title and recordedprogram.subtitle = recorded.subtitle seem to be suitable for joining the tables (additionally to chanid, of course).

Am I right with using these?

Thanks,
Nicolas

-- 
www.nskcomputing.de