   SELECT asn_id,
     (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.XD') AS sparkpoint_id
   FROM get_descendant_standards_nodes('S11437A4')
-);
-
-INSERT into sparkpoint_standard_alignments (asn_id, sparkpoint_id) (
+
+  UNION
+
   SELECT asn_id,
     (SELECT id FROM sparkpoints WHERE code = 'ELA.WRT.GRA') AS sparkpoint_id
   FROM get_descendant_standards_nodes('S1143936')

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.WRT.GRA') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11436AA')
);

INSERT into sparkpoint_standard_alignments (asn_id, sparkpoint_id) (
  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.VOC') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11437EB')

  UNION

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.VOC') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S1143730')
);

-- TODO: I'm fairly sure that this is implied by serial/primary key; we should double check

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.FDN') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11436A7')

  UNION

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.LIT') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11436A5')

  UNION

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.INF') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S11436A6')

  UNION

  SELECT asn_id,
    (SELECT id FROM sparkpoints WHERE code = 'ELA.RDG.XD') AS sparkpoint_id
  FROM get_descendant_standards_nodes('S114372D')
