trial_designsxtrial_types

SELECT trialdesign.value AS trial_design_id,

    trialterm.cvterm_id AS trial_type_id

   FROM (((materialized_phenoview

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

           FROM cvterm

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

     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 trialdesign.value, trialterm.cvterm_id;