select distinct crt, crn, cbp, cdp, data from catalogcrg, catalogrepeat where   
	tag like 'crc' and data like 'Roman Provincial%'
	and catalogrepeat.catalogid=catalogcrg.catalogid
	go



insert into catalogstatus (ident, status, catalogid, comment) 
select 'jtrant', 2, catalogCRG.catalogid, "updated CRC, CBP from info found in CRC:  "+data
	from catalogCRG, catalogRepeat where 
		tag ='CRC' 
		and data like 'b.Italy, d.Mexico'
		and catalogCRG.catalogid=catalogrepeat.catalogid 
	
	
update catalogCRG
	set CBP = "Italy"
	from catalogcrg, catalogrepeat
		where tag like 'crc' 
			and data like 'b.Italy, d.Mexico'
			and catalogrepeat.catalogid=catalogCRG.catalogid
			
			
update catalogCRG
	set CDP = "Mexico"
	from catalogcrg, catalogrepeat
		where tag like 'crc' 
			and data like 'b.Italy, d.Mexico'
			and catalogrepeat.catalogid=catalogCRG.catalogid			
			
insert into catalogrepeat (instance, inorder, catalogid, fid, tag, data, ftbl) 
	select 1,0, catalog.id, fid,'CRC',"European; Southern European; Italian",'crg' 
	from catalog, catalogrepeat where catalogrepeat.catalogid=catalog.id and tag='crc'  
	and data like 'italian (born greece)'

update catalogrepeat	
	set data = "European; Southern European; Italian"
	where tag = 'CRC'
	and data like 'b.Italy, d.Mexico'
	
	
	
	
	
select distinct crt, crn, cbp, data from catalogcrg, catalogrepeat where   
	crn like 'gaulli, giovanni%' and tag like 'crc'
	and catalogcrg.catalogid=catalogrepeat.catalogid
	go
	 




insert into catalogstatus (ident, status, catalogid, comment) 
select 'jtrant', 2, catalogCRG.catalogid, "deleted CRC:  "+data
	from catalogCRG, catalogRepeat where 
		tag ='CRC' 
		and data like 'NA'
		and catalogCRG.catalogid=catalogrepeat.catalogid 
		

delete from catalogrepeat where tag like 'crc' and data ='NA'
		
		
update catalogCRG 
	set CRT= "Artist not recorded (Roman Provincial)"
	where CRT= "Artist not recorded" and catalogcrg.catalogid in
	(select catalogrepeat.catalogid from catalogrepeat where   
	tag like 'crc' and data like 'Roman Provincial%')
	
	
	
select distinct crt, crn, cbp, cdp, data from catalogcrg, catalogrepeat where   
	tag like 'crc' and data like 'Asian; Far East Asian; Chinese'
	and catalogrepeat.catalogid=catalogcrg.catalogid
	and crn like '%chinese%'
	go
	



select distinct crt, crn, cbp, cdp, data, catalogCRG.catalogid from catalogcrg, catalogrepeat where   
	crn like 'japanese'
	and catalogcrg.catalogid=catalogrepeat.catalogid
	and tag like 'crc'
	go
	
	
insert into catalogstatus (ident, status, catalogid, comment) 
select 'jtrant', 2, catalogCRG.catalogid, "removed culture data from CRN:  "+CRN
	from catalogCRG where crn ="Japanese" 


update catalogcrg set CRN = NULL where crn ='Japanese'