seedlots

SELECT stock.stock_id AS seedlot_id,

    stock.uniquename AS seedlot_name

   FROM stock

  WHERE ((stock.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'seedlot'::text))) AND (stock.is_obsolete = false))

  GROUP BY stock.stock_id, stock.uniquename;