SELECT c.cpe23

  FROM cpe_matches a
  JOIN cpe_match_cpes b
    ON (b.cpe_match_id = a.cpe_match_id)
  JOIN cpes c
    ON (c.cpe_id = b.cpe_id)

 WHERE a.cpe23 = ?

 ORDER BY c.cpe23