breeding_programsxtrial_types

SELECT materialized_phenoview.breeding_program_id,

    trialterm.cvterm_id AS trial_type_id

   FROM ((materialized_phenoview

     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 materialized_phenoview.breeding_program_id, trialterm.cvterm_id;