 thin_name = regexp_replace (thin_name, 'sus$','suspension' , 1,1,'i')
 ;
 update thin_need_to_map set 
-thin_name = regexp_replace (thin_name, 'eli$','oral tablet' , 1,1,'i')
+thin_name = regexp_replace (thin_name, 'eli$','elixir' , 1,1,'i')
 ;
 update thin_need_to_map set 
 thin_name = regexp_replace (thin_name, 'sup$','suppositories' , 1,1,'i')

thin_name = regexp_replace (thin_name, 'lot$','lotion' , 1,1,'i')
;
update thin_need_to_map set 
thin_name = regexp_replace (thin_name, 'syr$','syringe' , 1,1,'i')
;
update thin_need_to_map set 
thin_name = regexp_replace (thin_name, 'app$','applicator' , 1,1,'i')

create table basic_con_rel_stage as select * from concept_relationship_stage
;
--then use CNDV and then generic --well, it's bad aproach in general but still
