SQL:"SELECT MAKER, NAME, GRADE , SYARYO, KAKAKU, SYONENDO , COLOR, HAIKI, NENRYO , SHIFTKUBUN, KUDO , KEIJO, KYORI, EIGYOSYO , SYAKEN , SOUBI1, SOUBI2, SOUBI3, SOUBI4, SOUBI5 , SOUBI6, SOUBI7, SOUBI8, SOUBI9, SOUBI10 , SOUBI11, SOUBI12, SOUBI13, SOUBI14, SOUBI15 , KIGYO , YOBI1 , YOBI2 , KYORIKUBUN , MAKERCODE , SNAMECODE  FROM carchs1_t_carinfo WHERE KIGYO='01'AND (KANRIKUBUN = '01' OR KANRIKUBUN = '03' OR KANRIKUBUN = '14' OR KANRIKUBUN = '16' OR KANRIKUBUN = '51' OR KANRIKUBUN = '52' OR KANRIKUBUN = '53' OR KANRIKUBUN = '54' OR KANRIKUBUN = '55' OR KANRIKUBUN = '99' ) AND (EIGYOSYO = '1001' OR EIGYOSYO = '1002' OR EIGYOSYO = '1003' OR EIGYOSYO = '1004' OR EIGYOSYO = '1005' OR EIGYOSYO = '1006' OR EIGYOSYO = '1007' OR EIGYOSYO = '1008' OR EIGYOSYO = '1009' OR EIGYOSYO = '1010' OR EIGYOSYO = '1012' OR EIGYOSYO = '1013' OR EIGYOSYO = '1017' OR EIGYOSYO = '1018' OR EIGYOSYO = '1019' OR EIGYOSYO = '1020' OR EIGYOSYO = '1021' OR EIGYOSYO = '1030' OR EIGYOSYO = '1031' OR EIGYOSYO = '1033' OR EIGYOSYO = '1034' OR EIGYOSYO = '1035' OR EIGYOSYO = '1036' OR EIGYOSYO = '1037' OR EIGYOSYO = '1042' OR EIGYOSYO = '1046' OR EIGYOSYO = '1047' OR EIGYOSYO = '1051' OR EIGYOSYO = '1054' OR EIGYOSYO = '1055' OR EIGYOSYO = '1056' OR EIGYOSYO = '1058' OR EIGYOSYO = '1059' OR EIGYOSYO = '1060' OR EIGYOSYO = '1061' OR EIGYOSYO = '1062' OR EIGYOSYO = '1063' OR EIGYOSYO = '1064' OR EIGYOSYO = '1066' OR EIGYOSYO = '1067' OR EIGYOSYO = '1068' OR EIGYOSYO = '1069' OR EIGYOSYO = '1070' OR EIGYOSYO = '1071' OR EIGYOSYO = '1072' OR EIGYOSYO = '1073' OR EIGYOSYO = '1074' OR EIGYOSYO = '1075' OR EIGYOSYO = '1076' OR EIGYOSYO = '1077' OR EIGYOSYO = '1078' OR EIGYOSYO = '1079' OR EIGYOSYO = '1080' OR EIGYOSYO = '1081' OR EIGYOSYO = '1082' OR EIGYOSYO = '1083' OR EIGYOSYO = '1084' OR EIGYOSYO = '1085' OR EIGYOSYO = '1086' OR EIGYOSYO = '1087' OR EIGYOSYO = '1402' OR EIGYOSYO = '1405' OR EIGYOSYO = '1406' OR EIGYOSYO = '1407' OR EIGYOSYO = '1408' OR EIGYOSYO = '1409' OR EIGYOSYO = '1410' OR EIGYOSYO = '1411' OR EIGYOSYO = '1505' OR EIGYOSYO = '1506' OR EIGYOSYO = '1601' OR EIGYOSYO = '1604' OR EIGYOSYO = '1605' OR EIGYOSYO = '1606' OR EIGYOSYO = '1612' OR EIGYOSYO = '1617' OR EIGYOSYO = '1621' OR EIGYOSYO = '1622' OR EIGYOSYO = '1623' OR EIGYOSYO = '1625' OR EIGYOSYO = '1626' OR EIGYOSYO = '1627' OR EIGYOSYO = '1628' OR EIGYOSYO = '1629' OR EIGYOSYO = '1630' OR EIGYOSYO = '1632' OR EIGYOSYO = '1634' OR EIGYOSYO = '1635' OR EIGYOSYO = '1637' OR EIGYOSYO = '1638' OR EIGYOSYO = '1639' OR EIGYOSYO = '1640' )  AND KAKAKU >= 1  AND SNAMECODE= ORDER BY SYARYO DESC " no JIKKO ERROR