cgreich
commented
2 years ago select a.min_levels_of_separation as a_min, an.concept_id as an_id, an.concept_name as an_name, an.vocabulary_id as an_vocab, an.domain_id as an_domain, an.concept_class_id as an_class, de.concept_id as de_id, de.concept_name as de_name, de.vocabulary_id as de_vocab, de.domain_id as de_domain, de.concept_class_id as de_class from concept an join concept_ancestor a on a.ancestor_concept_id=an.concept_id join concept de on de.concept_id=a.descendant_concept_id where an.concept_id=21603213 and de.concept_class_id='Clinical Drug Form' and de.concept_name not ilike '%pseudoephedrine%' order by min_levels_of_separation
Descendants should always contain pseudoephedrine (except ingredients and clinical drug components), but contain other combinations or other single ingredients
As mentioned in this GitHub issue, we apparently have wrong assignments. Also check if this is incidental or systemic.