-- populate fts table
INSERT INTO cpe_fts(rowid, title)
  SELECT a.cpe_id,
         COALESCE(b.val, '')

    FROM cpes a
    LEFT JOIN cpe_titles b
      ON (b.cpe_id = a.cpe_id)

   WHERE b.lang = 'en-US';