SELECT id, num
FROM   index i1
WHERE  id LIKE ?
  AND NOT EXISTS (
    SELECT 1 FROM index
    WHERE  id = 'G'||Substr(i1.id, 2)
  )