locationsxseedlots

SELECT nd_experiment.nd_geolocation_id AS location_id,

    nd_experiment_stock.stock_id AS seedlot_id

   FROM (nd_experiment

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

  WHERE (nd_experiment.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

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

  GROUP BY nd_experiment.nd_geolocation_id, nd_experiment_stock.stock_id;