genotyping_projectsxtrial_types

SELECT materialized_genoview.genotyping_project_id,

    trialterm.cvterm_id AS trial_type_id

   FROM (((materialized_genoview

     JOIN materialized_phenoview USING (accession_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 materialized_genoview.genotyping_project_id, trialterm.cvterm_id;