[mythtv-users] how do I list previously recorded shows?

[Michael T. Dean]

On 09/03/2009 05:22 PM, Paul - subscriptions wrote:
> I've found a row in the "program" table but none in the recorded table..
>
> --- print list start ---
> Title - Subtitle                Ch Station Day Start  End   S C I  T N   Pri
> City Homicide - "The Confessio    6 PRIME C 07 20:30-21:35  1 0 0  d P   0/0
>
>
> mysql> SELECT starttime,title, subtitle,
> programid,syndicatedepisodenumber,programid  FROM program WHERE title LIKE
> "City Homicide%" and subtitle = "The Confession";


SELECT starttime, title, subtitle, programid FROM program WHERE title = 
'City Homicide';
SELECT starttime, title, subtitle, programid FROM oldrecorded WHERE 
title = 'City Homicide';

Again, subtitle and description are almost definitely irrelevant.

Mike