by@hakatashi
WA
WITH RECURSIVE lines(x, line, remain) AS (
SELECT 1, substr(v, 0, 9) AS line, substr(v, 10) AS remain FROM i
UNION ALL
SELECT x + 1, substr(remain, 0, 9) AS line, substr(remain, 10) AS remain
FROM lines
WHERE remain != ''
)
SELECT x, line FROM lines11100111 10001000 01000010 00110111 01100101 01010110 00100100 10111011 00110010 10101110 00011100 00101011 00000011 00001111 00010010 00000110 01110001 10000001 00001010 01001110 10101011 01000011 10001100 01001111 11010010 00000000 01111000 00000001 01101001 10011111 10000000 11111101 10011001 10111100 00111100 10111101 10001000 10010000 00000001 00000111 01011100 11001110 11000001 10111110 00010101 01011011 00101101 11100011 11100010 10011011
1|11100111 2|10001000 3|01000010 4|00110111 5|01100101 6|01010110 7|00100100 8|10111011 9|00110010 10|10101110 11|00011100 12|00101011 13|00000011 14|00001111 15|00010010 16|00000110 17|01110001 18|10000001 19|00001010 20|01001110 21|10101011 22|01000011 23|10001100 24|01001111 25|11010010 26|00000000 27|01111000 28|00000001 29|01101001 30|10011111 31|10000000 32|11111101 33|10011001 34|10111100 35|00111100 36|10111101 37|10001000 38|10010000 39|00000001 40|00000111 41|01011100 42|11001110 43|11000001 44|10111110 45|00010101 46|01011011 47|00101101 48|11100011 49|11100010 50|10011011