aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/cpe-match/search.sql
blob: 45dd1f6d084e5d1ac8a8873918d8d26b34981382 (plain)
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