trait_componentsxtrial_types

SELECT trait_component.cvterm_id AS trait_component_id,

    trialterm.cvterm_id AS trial_type_id

   FROM (((((materialized_phenoview

     JOIN cvterm trait ON ((materialized_phenoview.trait_id = trait.cvterm_id)))

     JOIN cvterm_relationship ON (((trait.cvterm_id = cvterm_relationship.object_id) AND (cvterm_relationship.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'contains'::text))))))

     JOIN cvterm trait_component ON ((cvterm_relationship.subject_id = trait_component.cvterm_id)))

     JOIN projectprop trialprop ON (((materialized_phenoview.trial_id = trialprop.project_id) AND (trialprop.type_id IN ( SELECT cvterm.cvterm_id

           FROM (cvterm

             JOIN cv USING (cv_id))

          WHERE ((cv.name)::text = 'project_type'::text))))))

     JOIN cvterm trialterm ON ((trialprop.type_id = trialterm.cvterm_id)))

  GROUP BY trait_component.cvterm_id, trialterm.cvterm_id;