accessions

SELECT stock.stock_id AS accession_id,

    stock.uniquename AS accession_name

   FROM stock

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

           FROM cvterm

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

  GROUP BY stock.stock_id, stock.uniquename;