text: SELECT 
  	cname.name as ICU1stMAP, 
      v.visit_id
  FROM obs obs
  	INNER JOIN encounter enc on obs.encounter_id = enc.encounter_id
      INNER JOIN encounter_type enc_type ON enc.encounter_type = enc_type.encounter_type_id
      AND enc_type.uuid = '7dc1632c-f947-474f-b92c-7add68019aec'
  	INNER JOIN visit v on enc.visit_id = v.visit_id
      INNER JOIN concept_name cname ON obs.value_coded = cname.concept_id
      AND cname.locale = "en"
  	INNER JOIN concept c ON cname.concept_id = c.concept_id
      INNER JOIN concept ICU1stMAPQn ON obs.concept_id = ICU1stMAPQn.concept_id
      AND ICU1stMAPQn.uuid = '0b19946c-63a6-41e8-b3af-a87fc6addab4'
  WHERE  
  	  obs.voided = 0
  	  AND cname.concept_name_type = "FULLY_SPECIFIED"