dbstore/sql/cpe-match/search.sql


1
2
3
4
5
6
7
8
9
10
11

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