 ;
 
 -- 4.11 fix packs
-INSERT INTO сlass_to_rx_descendant
+INSERT INTO class_to_rx_descendant
 SELECT DISTINCT substring(concept_code_1, '\w+'), class_name,c.concept_id, c.concept_name, c.concept_code, c.concept_class_id, 1
 FROM class_to_drug_1 f
        JOIN devv5.concept_ancestor ca ON ca.ancestor_concept_id = cast(f.concept_id AS int)


-- 4.10
DELETE
FROM сlass_to_rx_descendant
WHERE class_name like '%insulin%';
INSERT INTO сlass_to_rx_descendant
SELECT DISTINCT class_code,
                class_name,
                c.concept_id,

;

-- 4.8
INSERT INTO class_to_rx_descendant
SELECT DISTINCT substring(concept_code_1, '\w+'),
                class_name,
                c.concept_id,
