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

[jedi]

On Thu, Oct 23, 2008 at 01:14:21PM -0700, Brad DerManouelian wrote:
> 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:

     The relevant recording rule would be pretty key info.

     You're example doesn't show that very well because the
given recording rule is pretty narrow in scope to begin with.

This is a much better example:


| History Shows (Power Search)         | History Shows                   | Winston Churchill: The Lion's Roar                                      | 
| History Shows (Power Search)         | History Shows                   | Ecology: Pulse of the Planet                                            | 
| History Shows (Power Search)         | History Shows                   | Cities of the Underworld -- Mob Underground                             | 
| History Shows (Power Search)         | History Shows                   | Cities of the Underworld -- A-Bomb Underground                          | 
| History Shows (Power Search)         | History Shows                   | Art Rebellion: The Making of the Modern/Edgar Degas: Reluctant Rebel    | 
| History Shows (Power Search)         | History Shows                   | Crime Wave: 18 Months of Mayhem                                         | 
| History Shows (Power Search)         | History Shows                   | Jurassic Fight Club -- Armageddon                                       | 
| History Shows (Power Search)         | History Shows                   | Rome: Rise and Fall of an Empire -- Julius Caesar                       | 
| History Shows (Power Search)         | History Shows                   | Rome: Rise and Fall of an Empire -- The Forest of Death                 | 

    Although it's obcured by the fact that I monkey around with my description
data so that it gets presented in the frontend the way I want it. In my data,
recorded.subtitle contains the original title and subtitle information from
recorded.
 
    Another better example:

| heston (Keyword Search)              | heston                          | Hercules                                                                |
    This might provide a clue as to why suddenly you are recording
stuff like Regis and Opera or one of the late night talk shows.
Charleston is dead but Harrison is still alive, kicking and hitting
the talk show circuit just like everyone else in Hollywood when one
of their movies comes out.

> 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       |
> +-----------------------------+----------------------------- 
> +--------------------------+

    Bad example... unless you think this guy has elves creating new
recording rules for him.

> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users