[mythtv-users] Where did this recording come from?

[Brad DerManouelian]

On Oct 23, 2008, at 12:56 PM, jedi wrote:

> select b.title,a.title,b.subtitle
>     from recorded a,record b
>     where a.recordid=b.recordid
>     and a.title like '%something%';

That will give you something like this:
mysql> select b.title,a.title,b.subtitle      from recorded a,record  
b      where a.recordid=b.recordid     and a.title like '%Silverman%';
+-----------------------------+----------------------------- 
+-------------------------+
| title                       | title                       |  
subtitle                |
+-----------------------------+----------------------------- 
+-------------------------+
| The Sarah Silverman Program | The Sarah Silverman Program | Not  
Without My Daughter |
| The Sarah Silverman Program | The Sarah Silverman Program | Not  
Without My Daughter |
| The Sarah Silverman Program | The Sarah Silverman Program | Not  
Without My Daughter |
+-----------------------------+----------------------------- 
+-------------------------+

I think this lists all upcoming episodes of something that will record  
and that also has recorded in the past. I'm not sure how that helps  
determine why something was recorded.

-Brad