<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 4/30/2014 9:51 AM, Matt Emmott
wrote:<br>
</div>
<blockquote
cite="mid:CAGHPk0Z-CYou7y8tT+snJiugW2T5PJNRaeUDnjE52f65SXz0Vw@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Apr 30, 2014 at 9:47 AM, Leo
Butler <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:leo.butler@member.ams.org" target="_blank">leo.butler@member.ams.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex"><br>
Hi,<br>
<br>
Since changing over from an analogue (pvr-150) to digital
(hdhr3-cc)<br>
tuner, I have written a custom recording rule to re-record
episodes.<br>
I simply modified the custom rule to re-record sdtv
recordings when<br>
available as hdtv.<br>
<br>
I would like to write an sql query to identify duplicate
recordings,<br>
in order to delete the older recording. I am no sql guru,
and my first<br>
thought was to query the recorded.duplicate field--but
this is set to<br>
1 for all recordings, so the name belies its purpose.<br>
<br>
Any suggestions?<br>
<br>
TIA,<br>
Leo<br>
_______________________________________________<br>
</blockquote>
<div><br>
</div>
<div>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: <a moz-do-not-send="true"
href="http://www.mythtv.org/wiki/Find_orphans.py">http://www.mythtv.org/wiki/Find_orphans.py</a>
<br>
</div>
</div>
</div>
</div>
<br>
</blockquote>
<br>
It tracks recordings that do not have a matching file, and files
that do not have a matching recording. It has no mechanism to
detect intentional duplicate recordings.<br>
</body>
</html>