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

[Brad DerManouelian]

On Oct 23, 2008, at 1:10 PM, jedi wrote:

> On Thu, Oct 23, 2008 at 02:56:37PM -0500, jedi wrote:
>> On Thu, Oct 23, 2008 at 12:43:06PM -0700, Brad DerManouelian wrote:
>>> On Oct 23, 2008, at 12:34 PM, Jeff Simpson wrote:
>>>
>>>> Question for all you Myth-experts out there: How do you determine  
>>>> from
>>>> a recording how it was scheduled?
>>
>>     select b.title,a.title,a.subtitle  (correction)
>>     from recorded a,record b
>>     where a.recordid=b.recordid
>>     and a.title like '%something%';
>
> or if you deleted it already...
>
>
>>     select b.title,a.title,a.subtitle  (correction)
>>     from oldrecorded a,record b
>>     where a.recordid=b.recordid
>>     and a.title like '%something%';

With your correction, still no info about why something was recorded:
mysql> select b.title,a.title,a.subtitle
     ->     from oldrecorded a,record b
     ->     where a.recordid=b.recordid
     ->     and a.title like '%Silverman%';
+-----------------------------+----------------------------- 
+--------------------------+
| title                       | title                       |  
subtitle                 |
+-----------------------------+----------------------------- 
+--------------------------+
| The Sarah Silverman Program | The Sarah Silverman Program | Officer  
Jay              |
| The Sarah Silverman Program | The Sarah Silverman Program | Bored of  
the Rings       |
| The Sarah Silverman Program | The Sarah Silverman Program |  
Positively Negative      |
| The Sarah Silverman Program | The Sarah Silverman Program | Not  
Without My Daughter  |
| The Sarah Silverman Program | The Sarah Silverman Program  
|                          |
| The Sarah Silverman Program | The Sarah Silverman Program |  
Humanitarian of the Year |
| The Sarah Silverman Program | The Sarah Silverman Program  
|                          |
| The Sarah Silverman Program | The Sarah Silverman Program  
|                          |
| The Sarah Silverman Program | The Sarah Silverman Program  
|                          |
| The Sarah Silverman Program | The Sarah Silverman Program |  
Batteries                |
| The Sarah Silverman Program | The Sarah Silverman Program | Making  
New Friends       |
| The Sarah Silverman Program | The Sarah Silverman Program | High,  
It's Sarah         |
| The Sarah Silverman Program | The Sarah Silverman Program | The  
Mongolian Beef       |
| The Sarah Silverman Program | The Sarah Silverman Program | Making  
New Friends       |
| The Sarah Silverman Program | The Sarah Silverman Program | The  
Mongolian Beef       |
| The Sarah Silverman Program | The Sarah Silverman Program | Making  
New Friends       |
| The Sarah Silverman Program | The Sarah Silverman Program  
|                          |
| The Sarah Silverman Program | The Sarah Silverman Program | Not  
Without My Daughter  |
| The Sarah Silverman Program | The Sarah Silverman Program | Muffin'  
Man              |
| The Sarah Silverman Program | The Sarah Silverman Program | Making  
New Friends       |
| The Sarah Silverman Program | The Sarah Silverman Program | Making  
New Friends       |
+-----------------------------+----------------------------- 
+--------------------------+