select distinct crn, crt from catalogrepeat, catalogcrg where crn like 'United  States'
and catalogcrg.catalogid = catalogrepeat.catalogid
and tag='crc'



insert into catalogstatus (ident, status, catalogid, comment) 
select 'jtrant', 2, catalogCRG.catalogid, "updated CRN from "+CRN+" to Unknown, as duplicated CRC"
	from catalogCRG, catalogRepeat where catalogCRG.catalogid=catalogrepeat.catalogid 
	and tag = 'crc' and crn like data
	
	
update catalogcrg set crn = "Unknown" where id in 
	(select catalogcrg.id from catalogcrg, catalogrepeat
	 where catalogCRG.catalogid=catalogrepeat.catalogid and tag = 'crc' and data like CRN)




catalogcrg.id, crn, tag, data from catalogcrg, catalogrepeat
	 where catalogCRG.catalogid=catalogrepeat.catalogid and tag = 'crc' and crn like data


update catalogrepeat set data = "European; Southern European; Italian; Roman"
	where data = "European; Southern European; Roman Empire"
	and catalogrepeat.catalogid 
	in (select catalogCRG.catalogid from catalogcrg where crn like 'San Micheles Workshop%')
	
	
	
	
select AID, CRT, OCT, data from catalogOCG, catalogCRG, catalogrepeat, catalog
where tag like 'crc' and data like "European; Southern European; Roman Empire"
and catalogrepeat.catalogid=catalogOCG.catalogid
and catalogrepeat.catalogid=catalogCRG.catalogid
and catalogrepeat.catalogid=catalog.id
order by crt