<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 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 href="http://www.mythtv.org/wiki/Find_orphans.py">http://www.mythtv.org/wiki/Find_orphans.py</a> <br>
</div></div></div></div>