                             AND   concept_name LIKE '%Povidone-Iodine%');
 
 
+
 COMMIT;
 
--- XXX ??????! Check ingredients first
---Christian, it has already been decided
 -- Delete 3 legged dogs
 DELETE ds_stage
 WHERE drug_concept_code IN (WITH a AS

                            FROM ds_Stage
                            WHERE numerator_unit IN ('[hp_X]','[hp_C]'));

-- Manually add absent units in drug_strength (due to source table issues)
UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467711'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467709'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 100,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420833'
AND   INGREDIENT_CONCEPT_CODE = '1202';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467706'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 25,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420835'
AND   INGREDIENT_CONCEPT_CODE = '2409';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467710'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467715'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467705'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467712'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]',
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP467708'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 100,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420834'
AND   INGREDIENT_CONCEPT_CODE = '1202';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467714'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 25,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420834'
AND   INGREDIENT_CONCEPT_CODE = '2409';

UPDATE DS_STAGE
   SET AMOUNT_UNIT = '[U]'
WHERE DRUG_CONCEPT_CODE = 'OMOP467713'
AND   INGREDIENT_CONCEPT_CODE = '560';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 25,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420731'
AND   INGREDIENT_CONCEPT_CODE = '2409';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 100,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420832'
AND   INGREDIENT_CONCEPT_CODE = '1202';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 25,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420833'
AND   INGREDIENT_CONCEPT_CODE = '2409';

UPDATE DS_STAGE
   SET AMOUNT_VALUE = 100,
       AMOUNT_UNIT = 'mg',
       NUMERATOR_VALUE = NULL,
       NUMERATOR_UNIT = ''
WHERE DRUG_CONCEPT_CODE = 'OMOP420835'
AND   INGREDIENT_CONCEPT_CODE = '1202';

-- Fix micrograms and iU

    ON concept_id_2 = c2.concept_id
   AND c2.concept_class_id = 'Supplier'
   AND c2.VOCABULARY_ID LIKE 'Rx%'
UNION
--insert relationships to those packs that do not have Pack's BN
SELECT a.concept_code,
