plotsxtrial_types

SELECT stock.stock_id AS plot_id,

    trialterm.cvterm_id AS trial_type_id

   FROM (((materialized_phenoview

     JOIN stock ON (((materialized_phenoview.stock_id = stock.stock_id) AND (stock.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'plot'::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 stock.stock_id, trialterm.cvterm_id;