by@hakatashi
AC
WITH RECURSIVE lines(x, line, remain) AS ( SELECT 1, CASE WHEN substr(v,1,8)='00000000' or substr(v,1,8)='00000001' or substr(v,1,8)='00000011' or substr(v,1,8)='00000110' or substr(v,1,8)='00001010' or substr(v,1,8)='00001111' or substr(v,1,8)='00010101' or substr(v,1,8)='00011100' or substr(v,1,8)='00100100' or substr(v,1,8)='00101101' or substr(v,1,8)='00110111' or substr(v,1,8)='01000010' or substr(v,1,8)='01001110' or substr(v,1,8)='01011011' or substr(v,1,8)='01101001' or substr(v,1,8)='01111000' or substr(v,1,8)='10001000' or substr(v,1,8)='10011001' or substr(v,1,8)='10101011' or substr(v,1,8)='10111110' or substr(v,1,8)='11010010' or substr(v,1,8)='11100111' or substr(v,1,8)='11111101' 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' or substr(remain,1,8)='00000011' or substr(remain,1,8)='00000110' or substr(remain,1,8)='00001010' or substr(remain,1,8)='00001111' or substr(remain,1,8)='00010101' or substr(remain,1,8)='00011100' or substr(remain,1,8)='00100100' or substr(remain,1,8)='00101101' or substr(remain,1,8)='00110111' or substr(remain,1,8)='01000010' or substr(remain,1,8)='01001110' or substr(remain,1,8)='01011011' or substr(remain,1,8)='01101001' or substr(remain,1,8)='01111000' or substr(remain,1,8)='10001000' or substr(remain,1,8)='10011001' or substr(remain,1,8)='10101011' or substr(remain,1,8)='10111110' or substr(remain,1,8)='11010010' or substr(remain,1,8)='11100111' or substr(remain,1,8)='11111101' THEN 1 ELSE 0 END AS line, substr(remain, 10) AS remain FROM lines WHERE remain != '' ) SELECT line FROM lines
10101000 00010010 11101001 00001011 00101101 00111100 00111101 10001000 00001111 00110111 00000100 11000101 11000000 01011011 01001011 01100011 00000110 00011100 00101011 11111100 01111111 00001010 11100111 10011001 01111101 01111010 01101001 11010010 10101011 01000010 10110011 00010101 01011001 01101111 01001110 01011011 00000001 01100001 01011100 01111000 01110110 11001011 11111101 00000011 00100100 00000001 11010101 10111110 00000000 11010011
0 0 0 0 1 0 0 1 1 1 0 0 0 1 0 0 1 1 0 0 0 1 1 1 0 0 1 1 1 1 0 1 0 0 1 1 1 0 0 1 0 0 1 1 1 1 0 1 1 0