 		);
 DROP INDEX trgm_idx;
 
---6. update domain_id for Read from SNOMED
+--6. update domain_id for Read from target concepts (currently, limited to following vocabs: SNOMED, OMOP Extension, Race)
 --create temporary table read_domain
 --if domain_id is empty we use previous and next domain_id or its combination
---TODO: sync domains for concepts mapped to the Race Domain (e.g., 9SA3.11,9SA3.12,9SA3.13,9SA4.00 are Observations).
 DROP TABLE IF EXISTS read_domain;
 CREATE UNLOGGED TABLE read_domain AS
 SELECT concept_code,

					AND r.vocabulary_id_1 = 'Read'
					AND r.vocabulary_id_2 IN (
						'SNOMED',
						'OMOP Extension'
						)
					AND r.invalid_reason IS NULL
				)

				AND r.vocabulary_id_2 = c2.vocabulary_id
				AND c2.vocabulary_id IN (
					'SNOMED',
					'OMOP Extension',
					'Race'
					)
			) r1 ON r1.concept_code_1 = c1.concept_code
			AND r1.vocabulary_id_1 = c1.vocabulary_id
