[mythtv-users] sql query to identify duplicates

[Karl Dietz]

Hi Leo,

On 30.04.2014 17:48, Leo Butler wrote:
>>    From: Raymond Wagner<raymond at wagnerrp.com>
>>    On 4/30/2014 9:47 AM, Leo Butler wrote:
>>    >
>>    >  I would like to write an sql query to identify duplicate recordings,
>>    >  in order to delete the older recording. I am no sql guru, and my first
>>    >  thought was to query the recorded.duplicate field--but this is set to
>>    >  1 for all recordings, so the name belies its purpose.
>>
>>    That field (along with the one in oldrecorded) indicates that the record
>>    is participating in duplicate matching.  If you set it to zero, the
>>    scheduler will allow that show to be re-recorded, independent of any
>>    duplicate filters you may have on the recording rule.  This is how the
>>    "forget recording" mechanism operates.
>
> Raymond, thanks, that clarifies that matter. The wiki page does not
> have this information. Should this be added?
>
> http://www.mythtv.org/wiki/Recorded_table

it is a wiki, so please feel free to update / extend as you encounter 
outdated / incomplete information.

Regards,
Karl