plantsxplots

SELECT plant.stock_id AS plant_id,

    plot.stock_id AS plot_id

   FROM (((materialized_phenoview

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

           FROM cvterm

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

     JOIN stock_relationship plant_relationship ON ((plot.stock_id = plant_relationship.subject_id)))

     JOIN stock plant ON (((plant_relationship.object_id = plant.stock_id) AND (plant.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

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

  GROUP BY plant.stock_id, plot.stock_id;