-- add cve
INSERT INTO cves(item_id, cve_year, cve_num, assigner_id) VALUES (
  ?, ?, ?,
  (SELECT assigner_id FROM assigners WHERE assigner = ?)
);