I faced that some providers don't fill the EIT information correctly: They change the subtitle or description of a series episode in a minor way, which makes me hard to identify the accident duplicates.
This consume disk space and make my recordings harder to maintained.
In version 0.25 there are duplicate recognition, but if you like me who use MythTV from version 0.22, what can we do with old recordings?
Open your database client and run this:
SELECT * FROM recorded
WHERE (title,subtitle) IN (SELECT title,subtitle
FROM recorded
GROUP BY title,subtitle
HAVING COUNT(*) > 1)
AND title <> ''
AND subtitle <> ''
ORDER BY title,subtitle;
From the result you should keep one recording per base, and you can delete the others.
