duplicate_control_tags.sql

SELECT
-- put your url prefix here
'http://flyers.udayton.edu/record=' || id2reckey(record_id) || 'a' AS link,
id2reckey(record_id) || 'a' as bib_record_num,
index_entry as control_number

FROM
sierra_view.phrase_entry

WHERE
index_tag = 'o' AND
index_entry IN (
	SELECT
	index_entry
	
	FROM
	sierra_view.phrase_entry
	
	WHERE
	index_tag = 'o'
	
	GROUP BY
	index_entry
	
	HAVING
	    count(id) > 1
)
ORDER BY
    control_number, bib_record_num

finds bib records in the system that have the same control number as other bib records in the system.