쿼리문이 매우긴 mysql쿼리의 결과레코드가 중간에 잘립니다. 0 3 152

by 돌아온장고 [MySQL] mysql 쿼리문 최대길이 레코드 잘림 [2020.05.30 20:41:47]


mysql의 컬럼에 콤마로 분리된 텍스트의 데이터가 있습니다

id txtData
1 1111, 222.23, 333.2233,  423.324

콤마로 구분된 txtData컬럼의 데이터를 콤마별로 분리해서 컬럼화해서 출력하려고 합니다.

id c1 c2 c3 c4
1 1111 222.23 333.2233 423.324

이렇게 출력하려고,, 지원하는 방법이 없어서...txtData컬럼을 substring_index(column, 분리자, n번째)를 활용해서 추출했습니다.

substring_index(txtData, ",", 3) 은 txtData컬럼을 콤마로 분리해서 3번째의 값까지 반환합니다.

이렇게 반환된 쿼리를 -1로 하면 뒷에서 1개를 반환하는 것을 사용했습니다.

즉, 

SELECT substring_index( substring(txtData, ",", 1), ",", -1) as c1,

substring_index( substring(txtData, ",", 2), ",", -1) as c2,

substring_index( substring(txtData, ",", 3), ",", -1) as c3,

substring_index( substring(txtData, ",", 4), ",", -1) as c4  FROM table1; 

이런식으로 조회를 해서 가져옵니다.

txtData의 콤마구분갯수가 유동적이어서..php 의 루프로 sql쿼리문을 작성해서 쿼리를 날렸습니다.

그런데.. txtData의 콤마구분 갯수가 상당히 많아지는 경우 (100개를 넘어가는 경우)일경우

레코드 갯수가 100개라면.. php루프가 100번을 돌면서 쿼리문을 작성하기 때문에..쿼리문이 상당히 길어지겠죠..

SELECT  substring(....) as c1, ........substring(...) as c100 FROM table1 처럼 쿼리문이 엄청길어집니다.

혹시나 해서 될까 불안했는데..

역시나..제대로 안되네요..

120여개의 컬럼의 120여개의 레코드의 경우,

초반부 레코드는 제대로 나오는데..

후반부의 레코드는 잘려서 제대로 안나옵니다.

약 70개정도의 레코드가 출력되고 이후부터는 출력이 안됩니다.

 

이럴경우, 

mysql서버 환경변수같은 것들을 변경시켜줘야 할 것 같은데....?????

이 문제를 어떻게 해결해야 할까요??

 

 

by 마농 [2020.06.01 08:56:17]

질문이 중간에 좀 이상해 지는게...
초반에는 substring_index 를 여러번 사용하여 여러 컬럼을 만들어 내는 것처럼 설명하다가
막판에는 레코드가 안나온다고 하는데?
레코드 맞나요? 컬럼 아닌가요? 뭐가 맞나요?
쿼리가 에러나는게 아니라 중간까지만 나온다구요?
중간에 루프에서 튕겨 나온듯 한데요?


by 돌아온장고 [2020.06.02 17:41:48]

1개의 컬럼인 콤마로 구분된 텍스트데이터를 콤마별로 분리해서 각각의 컬럼으로 분리해내고 싶은 거에요..

이런 컬럼의 구조의 레코드가 상당히 많은데..

...위의 substring_index() 문을 사용해서 실행하면..

초반부 레코드는 원하는대로 1개의 컬럼에 있는 콤마로 분리된 값들이 각각의 컬럼으로 분리되어서 나옵니다만..

일정한 레코드의 갯수가 넘어가면..에러가 나는 거죠..!..

그리고..컴마로 분리되는 컬럼이 많지 않을경우에는 (20개 내외..) ..전체로 정상적으로 되는데..

콤마로 분리되는 컬럼이 많을 경우..(즉  1개의 컬럼내에.콤마로 분리된 갯수가 100개를 넘어갈 경우..)

초반부 레코드는 제대로 되나.

약 7~80개 레코드부터는 짤린다는 거죠...

 

 

 


by 마농 [2020.06.03 08:22:45]

아래 코드로 테스트 해보는데 에러 안나네요. (100 * 100)
질문에 표현하지 못한 다른 내용이 있는것은 아닌지?

WITH t AS
(
SELECT 1 idx, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10' txtData
UNION ALL SELECT   2, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   3, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   4, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   5, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   6, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   7, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   8, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT   9, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  10, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  11, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  12, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  13, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  14, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  15, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  16, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  17, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  18, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  19, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  20, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  21, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  22, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  23, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  24, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  25, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  26, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  27, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  28, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  29, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  30, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  31, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  32, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  33, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  34, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  35, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  36, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  37, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  38, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  39, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  40, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  41, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  42, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  43, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  44, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  45, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  46, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  47, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  48, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  49, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  50, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  51, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  52, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  53, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  54, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  55, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  56, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  57, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  58, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  59, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  60, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  61, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  62, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  63, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  64, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  65, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  66, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  67, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  68, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  69, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  70, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  71, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  72, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  73, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  74, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  75, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  76, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  77, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  78, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  79, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  80, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  81, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  82, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  83, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  84, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  85, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  86, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  87, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  88, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  89, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  90, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  91, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  92, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  93, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  94, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  95, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  96, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  97, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  98, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT  99, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
UNION ALL SELECT 100, '1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10,1111,222.23,333.2233,423.324,5.555,6.666,7.777,8.888,9.999,10.10'
)
SELECT idx
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   1), ',', -1) c001
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   2), ',', -1) c002
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   3), ',', -1) c003
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   4), ',', -1) c004
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   5), ',', -1) c005
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   6), ',', -1) c006
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   7), ',', -1) c007
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   8), ',', -1) c008
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',   9), ',', -1) c009
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  10), ',', -1) c010
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  11), ',', -1) c011
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  12), ',', -1) c012
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  13), ',', -1) c013
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  14), ',', -1) c014
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  15), ',', -1) c015
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  16), ',', -1) c016
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  17), ',', -1) c017
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  18), ',', -1) c018
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  19), ',', -1) c019
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  20), ',', -1) c020
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  21), ',', -1) c021
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  22), ',', -1) c022
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  23), ',', -1) c023
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  24), ',', -1) c024
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  25), ',', -1) c025
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  26), ',', -1) c026
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  27), ',', -1) c027
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  28), ',', -1) c028
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  29), ',', -1) c029
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  30), ',', -1) c030
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  31), ',', -1) c031
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  32), ',', -1) c032
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  33), ',', -1) c033
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  34), ',', -1) c034
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  35), ',', -1) c035
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  36), ',', -1) c036
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  37), ',', -1) c037
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  38), ',', -1) c038
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  39), ',', -1) c039
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  40), ',', -1) c040
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  41), ',', -1) c041
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  42), ',', -1) c042
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  43), ',', -1) c043
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  44), ',', -1) c044
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  45), ',', -1) c045
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  46), ',', -1) c046
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  47), ',', -1) c047
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  48), ',', -1) c048
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  49), ',', -1) c049
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  50), ',', -1) c050
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  51), ',', -1) c051
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  52), ',', -1) c052
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  53), ',', -1) c053
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  54), ',', -1) c054
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  55), ',', -1) c055
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  56), ',', -1) c056
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  57), ',', -1) c057
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  58), ',', -1) c058
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  59), ',', -1) c059
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  60), ',', -1) c060
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  61), ',', -1) c061
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  62), ',', -1) c062
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  63), ',', -1) c063
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  64), ',', -1) c064
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  65), ',', -1) c065
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  66), ',', -1) c066
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  67), ',', -1) c067
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  68), ',', -1) c068
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  69), ',', -1) c069
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  70), ',', -1) c070
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  71), ',', -1) c071
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  72), ',', -1) c072
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  73), ',', -1) c073
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  74), ',', -1) c074
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  75), ',', -1) c075
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  76), ',', -1) c076
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  77), ',', -1) c077
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  78), ',', -1) c078
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  79), ',', -1) c079
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  80), ',', -1) c080
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  81), ',', -1) c081
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  82), ',', -1) c082
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  83), ',', -1) c083
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  84), ',', -1) c084
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  85), ',', -1) c085
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  86), ',', -1) c086
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  87), ',', -1) c087
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  88), ',', -1) c088
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  89), ',', -1) c089
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  90), ',', -1) c090
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  91), ',', -1) c091
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  92), ',', -1) c092
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  93), ',', -1) c093
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  94), ',', -1) c094
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  95), ',', -1) c095
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  96), ',', -1) c096
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  97), ',', -1) c097
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  98), ',', -1) c098
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',',  99), ',', -1) c099
     , SUBSTRING_INDEX(SUBSTRING_INDEX(txtData, ',', 100), ',', -1) c100
  FROM t
;

 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입