Find Components for LOINC Panel

[don-torok]

Given the LOINC code 24338-6 (Gas panel - Blood) find the LOINC components that make up the panel

SELECT DISTINCT parent.concept_code, parent.concept_name,relationship_id,
              min_levels_of_separation, child.concept_code, child.concept_name
FROM concept parent
JOIN  concept_ancestor ON ancestor_concept_id = parent.concept_id
JOIN concept_relationship ON concept_id_1 = descendant_concept_id
JOIN concept child on child.concept_id = descendant_concept_id
WHERE parent.concept_code = '24338-6'
  AND relationship_id = 'Contained in panel'
ORDER by min_levels_of_separation, child.concept_code;