[mythtv-users] Where did this recording come from?
Brad DerManouelian
myth at dermanouelian.com
Thu Oct 23 20:14:21 UTC 2008
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 |
+-----------------------------+-----------------------------
+--------------------------+
More information about the mythtv-users
mailing list