accessionsxseedlots

SELECT materialized_phenoview.accession_id,

    stock.stock_id AS seedlot_id

   FROM ((materialized_phenoview

     LEFT JOIN stock_relationship seedlot_relationship ON (((materialized_phenoview.accession_id = seedlot_relationship.subject_id) AND (seedlot_relationship.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

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

     LEFT JOIN stock ON (((seedlot_relationship.object_id = stock.stock_id) AND (stock.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

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

  GROUP BY materialized_phenoview.accession_id, stock.stock_id;