[mythtv-users] sql query to identify duplicates

Matt Emmott memmott at gmail.com
Wed Apr 30 13:51:28 UTC 2014


On Wed, Apr 30, 2014 at 9:47 AM, Leo Butler <leo.butler at member.ams.org>wrote:

>
> Hi,
>
> Since changing over from an analogue (pvr-150) to digital (hdhr3-cc)
> tuner, I have written a custom recording rule to re-record episodes.
> I simply modified the custom rule to re-record sdtv recordings when
> available as hdtv.
>
> 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.
>
> Any suggestions?
>
> TIA,
> Leo
> _______________________________________________
>

I believe Find_orphans.py is included with most Myth installations, and
does what you need. I use it all the time because I have a flaky tuner.
This article doesn't mention 0.27 so I don't know if it is still supported
or not: http://www.mythtv.org/wiki/Find_orphans.py
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140430/03368ac3/attachment.html>


More information about the mythtv-users mailing list