breeding_programsxtrial_designs

SELECT materialized_phenoview.breeding_program_id,

    trialdesign.value AS trial_design_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))))))

  GROUP BY materialized_phenoview.breeding_program_id, trialdesign.value;