WITH RECURSIVE lines(x, line, remain) AS (
  SELECT 1, CASE WHEN substr(v,1,8)='00000000' or substr(v,1,8)='00000001' THEN 1 ELSE 0 END AS line, substr(v, 10) AS remain FROM i
  UNION ALL
    SELECT x + 1, CASE WHEN substr(remain,1,8)='00000000' or substr(remain,1,8)='00000001' THEN 1 ELSE 0 END AS line, substr(remain, 10) AS remain
    FROM lines
    WHERE remain != ''
)
SELECT line FROM lines