1
SELECT materialized_phenoview.breeding_program_id,
2
stock.stock_id AS plot_id
3
FROM (materialized_phenoview
4
JOIN stock ON (((materialized_phenoview.stock_id = stock.stock_id) AND (stock.type_id = ( SELECT cvterm.cvterm_id
5
FROM cvterm
6
WHERE ((cvterm.name)::text = 'plot'::text))))))
7
GROUP BY materialized_phenoview.breeding_program_id, stock.stock_id;