Evergreen: quick dupe isbn lookup

isbn_dupes.sql

-- SHOW EVERGREEN DATABASE IDS
-- WHERE 020 'a' value appears more than once

select distinct value as isbn, record
from metabib.real_full_rec
where value in 
(
	-- get duplicate isbns
	select value as isbn
	from metabib.real_full_rec
	where tag = '020' and subfield = 'a'
	group by isbn
	having count(id) > 1
)
order by isbn, record;