Removing Duplicate Items

Anyone have any good ideas for removing duplicate entries?

For my purposes, a solution would need to simply detect items having identical titles and delete all but one of each instance.

I identify the duplicates through MySQL and then use the record_ids to generate a search and delete them from the Omeka admin interface. (I like to see both, in case one of the duplicates is in an exhibit, for example.)For title this should be

SELECT distinct oet1.record_id, oet1.text
FROM omeka_element_texts as oet1
INNER JOIN omeka_element_texts as oet2 ON oet1.text = oet2.text
WHERE oet1.element_id = 50 AND !=;