breeding_programsxseedlots

SELECT materialized_phenoview.breeding_program_id,

    nd_experiment_stock.stock_id AS seedlot_id

   FROM (((materialized_phenoview

     LEFT JOIN nd_experiment_project ON ((materialized_phenoview.breeding_program_id = nd_experiment_project.project_id)))

     LEFT JOIN nd_experiment ON (((nd_experiment_project.nd_experiment_id = nd_experiment.nd_experiment_id) AND (nd_experiment.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

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

     LEFT JOIN nd_experiment_stock ON ((nd_experiment.nd_experiment_id = nd_experiment_stock.nd_experiment_id)))

  GROUP BY materialized_phenoview.breeding_program_id, nd_experiment_stock.stock_id;