genotyping_projectsxplants

SELECT materialized_genoview.genotyping_project_id,

    stock.stock_id AS plant_id

   FROM ((materialized_genoview

     JOIN materialized_phenoview USING (accession_id))

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

           FROM cvterm

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

  GROUP BY materialized_genoview.genotyping_project_id, stock.stock_id;