USE test; SELECT VERSION(); DROP TABLE if EXISTS test.`test_cs`; CREATE TABLE test.`test_cs` ( `ABG_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `AI_ID` INT(11) NULL DEFAULT NULL, `APO_ID` INT(11) NULL DEFAULT NULL, `ATC1_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `ATC2_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `ATC3_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `ATC4_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `BL_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `BRAND_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `DAFO_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `EAN_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `EINF_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `FBETRAG_ID` INT(11) NULL DEFAULT NULL, `GEN_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `HAFO_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `HST_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `HSTO_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `IMP_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `KANAL_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `KONZ_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `MEDPRD_ID` INT(11) NULL DEFAULT NULL, `NFC1_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `NFC2_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `NFC3_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `NNN_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `NNN10_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `PCK_ID` INT(11) NULL DEFAULT NULL, `PRD_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `PRDO_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `PZN_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `RXOTC_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `STR_ID` INT(11) NULL DEFAULT NULL, `SUBBRAND_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `SUB_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `SUBN_ID` INT(10) UNSIGNED NULL DEFAULT NULL, `UGK_ID` INT(11) NULL DEFAULT NULL, `VAL_10_101` INT(11) NULL DEFAULT NULL, `VAL_10_102` INT(11) NULL DEFAULT NULL, `VAL_10_103` INT(11) NULL DEFAULT NULL, `VAL_10_104` INT(11) NULL DEFAULT NULL, `VAL_10_105` INT(11) NULL DEFAULT NULL, `VAL_10_106` INT(11) NULL DEFAULT NULL, `VAL_10_118` INT(11) NULL DEFAULT NULL, `VAL_10_119` INT(11) NULL DEFAULT NULL, `VAL_10_122` INT(11) NULL DEFAULT NULL, `VAL_10_123` INT(11) NULL DEFAULT NULL, `VAL_10_8000` INT(11) NULL DEFAULT NULL, `VAL_10_8001` INT(11) NULL DEFAULT NULL, `VAL_10_8002` INT(11) NULL DEFAULT NULL, `VAL_10_8003` INT(11) NULL DEFAULT NULL, `VAL_10_8004` INT(11) NULL DEFAULT NULL, `VAL_10_8005` INT(11) NULL DEFAULT NULL, `VAL_10_8086` INT(11) NULL DEFAULT NULL, `VAL_10_8087` INT(11) NULL DEFAULT NULL, `VAL_10_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_1_101` INT(11) NULL DEFAULT NULL, `VAL_1_102` INT(11) NULL DEFAULT NULL, `VAL_1_103` INT(11) NULL DEFAULT NULL, `VAL_1_104` INT(11) NULL DEFAULT NULL, `VAL_1_105` INT(11) NULL DEFAULT NULL, `VAL_1_106` INT(11) NULL DEFAULT NULL, `VAL_11_101` INT(11) NULL DEFAULT NULL, `VAL_11_102` INT(11) NULL DEFAULT NULL, `VAL_11_103` INT(11) NULL DEFAULT NULL, `VAL_11_104` INT(11) NULL DEFAULT NULL, `VAL_11_105` INT(11) NULL DEFAULT NULL, `VAL_11_106` INT(11) NULL DEFAULT NULL, `VAL_11_118` INT(11) NULL DEFAULT NULL, `VAL_11_119` INT(11) NULL DEFAULT NULL, `VAL_11_122` INT(11) NULL DEFAULT NULL, `VAL_11_123` INT(11) NULL DEFAULT NULL, `VAL_1_118` INT(11) NULL DEFAULT NULL, `VAL_1_119` INT(11) NULL DEFAULT NULL, `VAL_1_122` INT(11) NULL DEFAULT NULL, `VAL_1_123` INT(11) NULL DEFAULT NULL, `VAL_11_8000` INT(11) NULL DEFAULT NULL, `VAL_11_8001` INT(11) NULL DEFAULT NULL, `VAL_11_8002` INT(11) NULL DEFAULT NULL, `VAL_11_8003` INT(11) NULL DEFAULT NULL, `VAL_11_8004` INT(11) NULL DEFAULT NULL, `VAL_11_8005` INT(11) NULL DEFAULT NULL, `VAL_11_8086` INT(11) NULL DEFAULT NULL, `VAL_11_8087` INT(11) NULL DEFAULT NULL, `VAL_11_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_12_101` INT(11) NULL DEFAULT NULL, `VAL_12_102` INT(11) NULL DEFAULT NULL, `VAL_12_103` INT(11) NULL DEFAULT NULL, `VAL_12_104` INT(11) NULL DEFAULT NULL, `VAL_12_105` INT(11) NULL DEFAULT NULL, `VAL_12_106` INT(11) NULL DEFAULT NULL, `VAL_12_118` INT(11) NULL DEFAULT NULL, `VAL_12_119` INT(11) NULL DEFAULT NULL, `VAL_12_122` INT(11) NULL DEFAULT NULL, `VAL_12_123` INT(11) NULL DEFAULT NULL, `VAL_12_8000` INT(11) NULL DEFAULT NULL, `VAL_12_8001` INT(11) NULL DEFAULT NULL, `VAL_12_8002` INT(11) NULL DEFAULT NULL, `VAL_12_8003` INT(11) NULL DEFAULT NULL, `VAL_12_8004` INT(11) NULL DEFAULT NULL, `VAL_12_8005` INT(11) NULL DEFAULT NULL, `VAL_12_8086` INT(11) NULL DEFAULT NULL, `VAL_12_8087` INT(11) NULL DEFAULT NULL, `VAL_12_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_13_101` INT(11) NULL DEFAULT NULL, `VAL_13_102` INT(11) NULL DEFAULT NULL, `VAL_13_103` INT(11) NULL DEFAULT NULL, `VAL_13_104` INT(11) NULL DEFAULT NULL, `VAL_13_105` INT(11) NULL DEFAULT NULL, `VAL_13_106` INT(11) NULL DEFAULT NULL, `VAL_13_118` INT(11) NULL DEFAULT NULL, `VAL_13_119` INT(11) NULL DEFAULT NULL, `VAL_13_122` INT(11) NULL DEFAULT NULL, `VAL_13_123` INT(11) NULL DEFAULT NULL, `VAL_13_8000` INT(11) NULL DEFAULT NULL, `VAL_13_8001` INT(11) NULL DEFAULT NULL, `VAL_13_8002` INT(11) NULL DEFAULT NULL, `VAL_13_8003` INT(11) NULL DEFAULT NULL, `VAL_13_8004` INT(11) NULL DEFAULT NULL, `VAL_13_8005` INT(11) NULL DEFAULT NULL, `VAL_13_8086` INT(11) NULL DEFAULT NULL, `VAL_13_8087` INT(11) NULL DEFAULT NULL, `VAL_13_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_14_101` INT(11) NULL DEFAULT NULL, `VAL_14_102` INT(11) NULL DEFAULT NULL, `VAL_14_103` INT(11) NULL DEFAULT NULL, `VAL_14_104` INT(11) NULL DEFAULT NULL, `VAL_14_105` INT(11) NULL DEFAULT NULL, `VAL_14_106` INT(11) NULL DEFAULT NULL, `VAL_14_118` INT(11) NULL DEFAULT NULL, `VAL_14_119` INT(11) NULL DEFAULT NULL, `VAL_14_122` INT(11) NULL DEFAULT NULL, `VAL_14_123` INT(11) NULL DEFAULT NULL, `VAL_14_8000` INT(11) NULL DEFAULT NULL, `VAL_14_8001` INT(11) NULL DEFAULT NULL, `VAL_14_8002` INT(11) NULL DEFAULT NULL, `VAL_14_8003` INT(11) NULL DEFAULT NULL, `VAL_14_8004` INT(11) NULL DEFAULT NULL, `VAL_14_8005` INT(11) NULL DEFAULT NULL, `VAL_14_8086` INT(11) NULL DEFAULT NULL, `VAL_14_8087` INT(11) NULL DEFAULT NULL, `VAL_14_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_15_101` INT(11) NULL DEFAULT NULL, `VAL_15_102` INT(11) NULL DEFAULT NULL, `VAL_15_103` INT(11) NULL DEFAULT NULL, `VAL_15_104` INT(11) NULL DEFAULT NULL, `VAL_15_105` INT(11) NULL DEFAULT NULL, `VAL_15_106` INT(11) NULL DEFAULT NULL, `VAL_15_118` INT(11) NULL DEFAULT NULL, `VAL_15_119` INT(11) NULL DEFAULT NULL, `VAL_15_122` INT(11) NULL DEFAULT NULL, `VAL_15_123` INT(11) NULL DEFAULT NULL, `VAL_15_8000` INT(11) NULL DEFAULT NULL, `VAL_15_8001` INT(11) NULL DEFAULT NULL, `VAL_15_8002` INT(11) NULL DEFAULT NULL, `VAL_15_8003` INT(11) NULL DEFAULT NULL, `VAL_15_8004` INT(11) NULL DEFAULT NULL, `VAL_15_8005` INT(11) NULL DEFAULT NULL, `VAL_15_8086` INT(11) NULL DEFAULT NULL, `VAL_15_8087` INT(11) NULL DEFAULT NULL, `VAL_15_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_16_101` INT(11) NULL DEFAULT NULL, `VAL_16_102` INT(11) NULL DEFAULT NULL, `VAL_16_103` INT(11) NULL DEFAULT NULL, `VAL_16_104` INT(11) NULL DEFAULT NULL, `VAL_16_105` INT(11) NULL DEFAULT NULL, `VAL_16_106` INT(11) NULL DEFAULT NULL, `VAL_16_118` INT(11) NULL DEFAULT NULL, `VAL_16_119` INT(11) NULL DEFAULT NULL, `VAL_16_122` INT(11) NULL DEFAULT NULL, `VAL_16_123` INT(11) NULL DEFAULT NULL, `VAL_16_8000` INT(11) NULL DEFAULT NULL, `VAL_16_8001` INT(11) NULL DEFAULT NULL, `VAL_16_8002` INT(11) NULL DEFAULT NULL, `VAL_16_8003` INT(11) NULL DEFAULT NULL, `VAL_16_8004` INT(11) NULL DEFAULT NULL, `VAL_16_8005` INT(11) NULL DEFAULT NULL, `VAL_16_8086` INT(11) NULL DEFAULT NULL, `VAL_16_8087` INT(11) NULL DEFAULT NULL, `VAL_16_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_17_101` INT(11) NULL DEFAULT NULL, `VAL_17_102` INT(11) NULL DEFAULT NULL, `VAL_17_103` INT(11) NULL DEFAULT NULL, `VAL_17_104` INT(11) NULL DEFAULT NULL, `VAL_17_105` INT(11) NULL DEFAULT NULL, `VAL_17_106` INT(11) NULL DEFAULT NULL, `VAL_17_118` INT(11) NULL DEFAULT NULL, `VAL_17_119` INT(11) NULL DEFAULT NULL, `VAL_17_122` INT(11) NULL DEFAULT NULL, `VAL_17_123` INT(11) NULL DEFAULT NULL, `VAL_17_8000` INT(11) NULL DEFAULT NULL, `VAL_17_8001` INT(11) NULL DEFAULT NULL, `VAL_17_8002` INT(11) NULL DEFAULT NULL, `VAL_17_8003` INT(11) NULL DEFAULT NULL, `VAL_17_8004` INT(11) NULL DEFAULT NULL, `VAL_17_8005` INT(11) NULL DEFAULT NULL, `VAL_17_8086` INT(11) NULL DEFAULT NULL, `VAL_17_8087` INT(11) NULL DEFAULT NULL, `VAL_17_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_1_8000` INT(11) NULL DEFAULT NULL, `VAL_1_8001` INT(11) NULL DEFAULT NULL, `VAL_1_8002` INT(11) NULL DEFAULT NULL, `VAL_1_8003` INT(11) NULL DEFAULT NULL, `VAL_1_8004` INT(11) NULL DEFAULT NULL, `VAL_1_8005` INT(11) NULL DEFAULT NULL, `VAL_1_8086` INT(11) NULL DEFAULT NULL, `VAL_1_8087` INT(11) NULL DEFAULT NULL, `VAL_18_101` INT(11) NULL DEFAULT NULL, `VAL_18_102` INT(11) NULL DEFAULT NULL, `VAL_18_103` INT(11) NULL DEFAULT NULL, `VAL_18_104` INT(11) NULL DEFAULT NULL, `VAL_18_105` INT(11) NULL DEFAULT NULL, `VAL_18_106` INT(11) NULL DEFAULT NULL, `VAL_18_118` INT(11) NULL DEFAULT NULL, `VAL_18_119` INT(11) NULL DEFAULT NULL, `VAL_18_122` INT(11) NULL DEFAULT NULL, `VAL_18_123` INT(11) NULL DEFAULT NULL, `VAL_18_8000` INT(11) NULL DEFAULT NULL, `VAL_18_8001` INT(11) NULL DEFAULT NULL, `VAL_18_8002` INT(11) NULL DEFAULT NULL, `VAL_18_8003` INT(11) NULL DEFAULT NULL, `VAL_18_8004` INT(11) NULL DEFAULT NULL, `VAL_18_8005` INT(11) NULL DEFAULT NULL, `VAL_18_8086` INT(11) NULL DEFAULT NULL, `VAL_18_8087` INT(11) NULL DEFAULT NULL, `VAL_18_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_19_101` INT(11) NULL DEFAULT NULL, `VAL_19_102` INT(11) NULL DEFAULT NULL, `VAL_19_103` INT(11) NULL DEFAULT NULL, `VAL_19_104` INT(11) NULL DEFAULT NULL, `VAL_19_105` INT(11) NULL DEFAULT NULL, `VAL_19_106` INT(11) NULL DEFAULT NULL, `VAL_19_118` INT(11) NULL DEFAULT NULL, `VAL_19_119` INT(11) NULL DEFAULT NULL, `VAL_19_122` INT(11) NULL DEFAULT NULL, `VAL_19_123` INT(11) NULL DEFAULT NULL, `VAL_1_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_19_8000` INT(11) NULL DEFAULT NULL, `VAL_19_8001` INT(11) NULL DEFAULT NULL, `VAL_19_8002` INT(11) NULL DEFAULT NULL, `VAL_19_8003` INT(11) NULL DEFAULT NULL, `VAL_19_8004` INT(11) NULL DEFAULT NULL, `VAL_19_8005` INT(11) NULL DEFAULT NULL, `VAL_19_8086` INT(11) NULL DEFAULT NULL, `VAL_19_8087` INT(11) NULL DEFAULT NULL, `VAL_19_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_20_101` INT(11) NULL DEFAULT NULL, `VAL_20_102` INT(11) NULL DEFAULT NULL, `VAL_20_103` INT(11) NULL DEFAULT NULL, `VAL_20_104` INT(11) NULL DEFAULT NULL, `VAL_20_105` INT(11) NULL DEFAULT NULL, `VAL_20_106` INT(11) NULL DEFAULT NULL, `VAL_20_118` INT(11) NULL DEFAULT NULL, `VAL_20_119` INT(11) NULL DEFAULT NULL, `VAL_20_122` INT(11) NULL DEFAULT NULL, `VAL_20_123` INT(11) NULL DEFAULT NULL, `VAL_20_8000` INT(11) NULL DEFAULT NULL, `VAL_20_8001` INT(11) NULL DEFAULT NULL, `VAL_20_8002` INT(11) NULL DEFAULT NULL, `VAL_20_8003` INT(11) NULL DEFAULT NULL, `VAL_20_8004` INT(11) NULL DEFAULT NULL, `VAL_20_8005` INT(11) NULL DEFAULT NULL, `VAL_20_8086` INT(11) NULL DEFAULT NULL, `VAL_20_8087` INT(11) NULL DEFAULT NULL, `VAL_20_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_2_101` INT(11) NULL DEFAULT NULL, `VAL_2_102` INT(11) NULL DEFAULT NULL, `VAL_2_103` INT(11) NULL DEFAULT NULL, `VAL_2_104` INT(11) NULL DEFAULT NULL, `VAL_2_105` INT(11) NULL DEFAULT NULL, `VAL_2_106` INT(11) NULL DEFAULT NULL, `VAL_21_101` INT(11) NULL DEFAULT NULL, `VAL_21_102` INT(11) NULL DEFAULT NULL, `VAL_21_103` INT(11) NULL DEFAULT NULL, `VAL_21_104` INT(11) NULL DEFAULT NULL, `VAL_21_105` INT(11) NULL DEFAULT NULL, `VAL_21_106` INT(11) NULL DEFAULT NULL, `VAL_21_118` INT(11) NULL DEFAULT NULL, `VAL_21_119` INT(11) NULL DEFAULT NULL, `VAL_21_122` INT(11) NULL DEFAULT NULL, `VAL_21_123` INT(11) NULL DEFAULT NULL, `VAL_2_118` INT(11) NULL DEFAULT NULL, `VAL_2_119` INT(11) NULL DEFAULT NULL, `VAL_2_122` INT(11) NULL DEFAULT NULL, `VAL_2_123` INT(11) NULL DEFAULT NULL, `VAL_21_8000` INT(11) NULL DEFAULT NULL, `VAL_21_8001` INT(11) NULL DEFAULT NULL, `VAL_21_8002` INT(11) NULL DEFAULT NULL, `VAL_21_8003` INT(11) NULL DEFAULT NULL, `VAL_21_8004` INT(11) NULL DEFAULT NULL, `VAL_21_8005` INT(11) NULL DEFAULT NULL, `VAL_21_8086` INT(11) NULL DEFAULT NULL, `VAL_21_8087` INT(11) NULL DEFAULT NULL, `VAL_21_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_22_101` INT(11) NULL DEFAULT NULL, `VAL_22_102` INT(11) NULL DEFAULT NULL, `VAL_22_103` INT(11) NULL DEFAULT NULL, `VAL_22_104` INT(11) NULL DEFAULT NULL, `VAL_22_105` INT(11) NULL DEFAULT NULL, `VAL_22_106` INT(11) NULL DEFAULT NULL, `VAL_22_118` INT(11) NULL DEFAULT NULL, `VAL_22_119` INT(11) NULL DEFAULT NULL, `VAL_22_122` INT(11) NULL DEFAULT NULL, `VAL_22_123` INT(11) NULL DEFAULT NULL, `VAL_22_8000` INT(11) NULL DEFAULT NULL, `VAL_22_8001` INT(11) NULL DEFAULT NULL, `VAL_22_8002` INT(11) NULL DEFAULT NULL, `VAL_22_8003` INT(11) NULL DEFAULT NULL, `VAL_22_8004` INT(11) NULL DEFAULT NULL, `VAL_22_8005` INT(11) NULL DEFAULT NULL, `VAL_22_8086` INT(11) NULL DEFAULT NULL, `VAL_22_8087` INT(11) NULL DEFAULT NULL, `VAL_22_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_23_101` INT(11) NULL DEFAULT NULL, `VAL_23_102` INT(11) NULL DEFAULT NULL, `VAL_23_103` INT(11) NULL DEFAULT NULL, `VAL_23_104` INT(11) NULL DEFAULT NULL, `VAL_23_105` INT(11) NULL DEFAULT NULL, `VAL_23_106` INT(11) NULL DEFAULT NULL, `VAL_23_118` INT(11) NULL DEFAULT NULL, `VAL_23_119` INT(11) NULL DEFAULT NULL, `VAL_23_122` INT(11) NULL DEFAULT NULL, `VAL_23_123` INT(11) NULL DEFAULT NULL, `VAL_23_8000` INT(11) NULL DEFAULT NULL, `VAL_23_8001` INT(11) NULL DEFAULT NULL, `VAL_23_8002` INT(11) NULL DEFAULT NULL, `VAL_23_8003` INT(11) NULL DEFAULT NULL, `VAL_23_8004` INT(11) NULL DEFAULT NULL, `VAL_23_8005` INT(11) NULL DEFAULT NULL, `VAL_23_8086` INT(11) NULL DEFAULT NULL, `VAL_23_8087` INT(11) NULL DEFAULT NULL, `VAL_23_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_24_101` INT(11) NULL DEFAULT NULL, `VAL_24_102` INT(11) NULL DEFAULT NULL, `VAL_24_103` INT(11) NULL DEFAULT NULL, `VAL_24_104` INT(11) NULL DEFAULT NULL, `VAL_24_105` INT(11) NULL DEFAULT NULL, `VAL_24_106` INT(11) NULL DEFAULT NULL, `VAL_24_118` INT(11) NULL DEFAULT NULL, `VAL_24_119` INT(11) NULL DEFAULT NULL, `VAL_24_122` INT(11) NULL DEFAULT NULL, `VAL_24_123` INT(11) NULL DEFAULT NULL, `VAL_24_8000` INT(11) NULL DEFAULT NULL, `VAL_24_8001` INT(11) NULL DEFAULT NULL, `VAL_24_8002` INT(11) NULL DEFAULT NULL, `VAL_24_8003` INT(11) NULL DEFAULT NULL, `VAL_24_8004` INT(11) NULL DEFAULT NULL, `VAL_24_8005` INT(11) NULL DEFAULT NULL, `VAL_24_8086` INT(11) NULL DEFAULT NULL, `VAL_24_8087` INT(11) NULL DEFAULT NULL, `VAL_24_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_25_101` INT(11) NULL DEFAULT NULL, `VAL_25_102` INT(11) NULL DEFAULT NULL, `VAL_25_103` INT(11) NULL DEFAULT NULL, `VAL_25_104` INT(11) NULL DEFAULT NULL, `VAL_25_105` INT(11) NULL DEFAULT NULL, `VAL_25_106` INT(11) NULL DEFAULT NULL, `VAL_25_118` INT(11) NULL DEFAULT NULL, `VAL_25_119` INT(11) NULL DEFAULT NULL, `VAL_25_122` INT(11) NULL DEFAULT NULL, `VAL_25_123` INT(11) NULL DEFAULT NULL, `VAL_25_8000` INT(11) NULL DEFAULT NULL, `VAL_25_8001` INT(11) NULL DEFAULT NULL, `VAL_25_8002` INT(11) NULL DEFAULT NULL, `VAL_25_8003` INT(11) NULL DEFAULT NULL, `VAL_25_8004` INT(11) NULL DEFAULT NULL, `VAL_25_8005` INT(11) NULL DEFAULT NULL, `VAL_25_8086` INT(11) NULL DEFAULT NULL, `VAL_25_8087` INT(11) NULL DEFAULT NULL, `VAL_25_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_26_101` INT(11) NULL DEFAULT NULL, `VAL_26_102` INT(11) NULL DEFAULT NULL, `VAL_26_103` INT(11) NULL DEFAULT NULL, `VAL_26_104` INT(11) NULL DEFAULT NULL, `VAL_26_105` INT(11) NULL DEFAULT NULL, `VAL_26_106` INT(11) NULL DEFAULT NULL, `VAL_26_118` INT(11) NULL DEFAULT NULL, `VAL_26_119` INT(11) NULL DEFAULT NULL, `VAL_26_122` INT(11) NULL DEFAULT NULL, `VAL_26_123` INT(11) NULL DEFAULT NULL, `VAL_26_8000` INT(11) NULL DEFAULT NULL, `VAL_26_8001` INT(11) NULL DEFAULT NULL, `VAL_26_8002` INT(11) NULL DEFAULT NULL, `VAL_26_8003` INT(11) NULL DEFAULT NULL, `VAL_26_8004` INT(11) NULL DEFAULT NULL, `VAL_26_8005` INT(11) NULL DEFAULT NULL, `VAL_26_8086` INT(11) NULL DEFAULT NULL, `VAL_26_8087` INT(11) NULL DEFAULT NULL, `VAL_26_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_27_101` INT(11) NULL DEFAULT NULL, `VAL_27_102` INT(11) NULL DEFAULT NULL, `VAL_27_103` INT(11) NULL DEFAULT NULL, `VAL_27_104` INT(11) NULL DEFAULT NULL, `VAL_27_105` INT(11) NULL DEFAULT NULL, `VAL_27_106` INT(11) NULL DEFAULT NULL, `VAL_27_118` INT(11) NULL DEFAULT NULL, `VAL_27_119` INT(11) NULL DEFAULT NULL, `VAL_27_122` INT(11) NULL DEFAULT NULL, `VAL_27_123` INT(11) NULL DEFAULT NULL, `VAL_27_8000` INT(11) NULL DEFAULT NULL, `VAL_27_8001` INT(11) NULL DEFAULT NULL, `VAL_27_8002` INT(11) NULL DEFAULT NULL, `VAL_27_8003` INT(11) NULL DEFAULT NULL, `VAL_27_8004` INT(11) NULL DEFAULT NULL, `VAL_27_8005` INT(11) NULL DEFAULT NULL, `VAL_27_8086` INT(11) NULL DEFAULT NULL, `VAL_27_8087` INT(11) NULL DEFAULT NULL, `VAL_27_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_2_8000` INT(11) NULL DEFAULT NULL, `VAL_2_8001` INT(11) NULL DEFAULT NULL, `VAL_2_8002` INT(11) NULL DEFAULT NULL, `VAL_2_8003` INT(11) NULL DEFAULT NULL, `VAL_2_8004` INT(11) NULL DEFAULT NULL, `VAL_2_8005` INT(11) NULL DEFAULT NULL, `VAL_2_8086` INT(11) NULL DEFAULT NULL, `VAL_2_8087` INT(11) NULL DEFAULT NULL, `VAL_28_101` INT(11) NULL DEFAULT NULL, `VAL_28_102` INT(11) NULL DEFAULT NULL, `VAL_28_103` INT(11) NULL DEFAULT NULL, `VAL_28_104` INT(11) NULL DEFAULT NULL, `VAL_28_105` INT(11) NULL DEFAULT NULL, `VAL_28_106` INT(11) NULL DEFAULT NULL, `VAL_28_118` INT(11) NULL DEFAULT NULL, `VAL_28_119` INT(11) NULL DEFAULT NULL, `VAL_28_122` INT(11) NULL DEFAULT NULL, `VAL_28_123` INT(11) NULL DEFAULT NULL, `VAL_28_8000` INT(11) NULL DEFAULT NULL, `VAL_28_8001` INT(11) NULL DEFAULT NULL, `VAL_28_8002` INT(11) NULL DEFAULT NULL, `VAL_28_8003` INT(11) NULL DEFAULT NULL, `VAL_28_8004` INT(11) NULL DEFAULT NULL, `VAL_28_8005` INT(11) NULL DEFAULT NULL, `VAL_28_8086` INT(11) NULL DEFAULT NULL, `VAL_28_8087` INT(11) NULL DEFAULT NULL, `VAL_28_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_29_101` INT(11) NULL DEFAULT NULL, `VAL_29_102` INT(11) NULL DEFAULT NULL, `VAL_29_103` INT(11) NULL DEFAULT NULL, `VAL_29_104` INT(11) NULL DEFAULT NULL, `VAL_29_105` INT(11) NULL DEFAULT NULL, `VAL_29_106` INT(11) NULL DEFAULT NULL, `VAL_29_118` INT(11) NULL DEFAULT NULL, `VAL_29_119` INT(11) NULL DEFAULT NULL, `VAL_29_122` INT(11) NULL DEFAULT NULL, `VAL_29_123` INT(11) NULL DEFAULT NULL, `VAL_2_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_29_8000` INT(11) NULL DEFAULT NULL, `VAL_29_8001` INT(11) NULL DEFAULT NULL, `VAL_29_8002` INT(11) NULL DEFAULT NULL, `VAL_29_8003` INT(11) NULL DEFAULT NULL, `VAL_29_8004` INT(11) NULL DEFAULT NULL, `VAL_29_8005` INT(11) NULL DEFAULT NULL, `VAL_29_8086` INT(11) NULL DEFAULT NULL, `VAL_29_8087` INT(11) NULL DEFAULT NULL, `VAL_29_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_30_101` INT(11) NULL DEFAULT NULL, `VAL_30_102` INT(11) NULL DEFAULT NULL, `VAL_30_103` INT(11) NULL DEFAULT NULL, `VAL_30_104` INT(11) NULL DEFAULT NULL, `VAL_30_105` INT(11) NULL DEFAULT NULL, `VAL_30_106` INT(11) NULL DEFAULT NULL, `VAL_30_118` INT(11) NULL DEFAULT NULL, `VAL_30_119` INT(11) NULL DEFAULT NULL, `VAL_30_122` INT(11) NULL DEFAULT NULL, `VAL_30_123` INT(11) NULL DEFAULT NULL, `VAL_30_8000` INT(11) NULL DEFAULT NULL, `VAL_30_8001` INT(11) NULL DEFAULT NULL, `VAL_30_8002` INT(11) NULL DEFAULT NULL, `VAL_30_8003` INT(11) NULL DEFAULT NULL, `VAL_30_8004` INT(11) NULL DEFAULT NULL, `VAL_30_8005` INT(11) NULL DEFAULT NULL, `VAL_30_8086` INT(11) NULL DEFAULT NULL, `VAL_30_8087` INT(11) NULL DEFAULT NULL, `VAL_30_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_3_101` INT(11) NULL DEFAULT NULL, `VAL_3_102` INT(11) NULL DEFAULT NULL, `VAL_3_103` INT(11) NULL DEFAULT NULL, `VAL_3_104` INT(11) NULL DEFAULT NULL, `VAL_3_105` INT(11) NULL DEFAULT NULL, `VAL_3_106` INT(11) NULL DEFAULT NULL, `VAL_31_101` INT(11) NULL DEFAULT NULL, `VAL_31_102` INT(11) NULL DEFAULT NULL, `VAL_31_103` INT(11) NULL DEFAULT NULL, `VAL_31_104` INT(11) NULL DEFAULT NULL, `VAL_31_105` INT(11) NULL DEFAULT NULL, `VAL_31_106` INT(11) NULL DEFAULT NULL, `VAL_31_118` INT(11) NULL DEFAULT NULL, `VAL_31_119` INT(11) NULL DEFAULT NULL, `VAL_31_122` INT(11) NULL DEFAULT NULL, `VAL_31_123` INT(11) NULL DEFAULT NULL, `VAL_3_118` INT(11) NULL DEFAULT NULL, `VAL_3_119` INT(11) NULL DEFAULT NULL, `VAL_3_122` INT(11) NULL DEFAULT NULL, `VAL_3_123` INT(11) NULL DEFAULT NULL, `VAL_31_8000` INT(11) NULL DEFAULT NULL, `VAL_31_8001` INT(11) NULL DEFAULT NULL, `VAL_31_8002` INT(11) NULL DEFAULT NULL, `VAL_31_8003` INT(11) NULL DEFAULT NULL, `VAL_31_8004` INT(11) NULL DEFAULT NULL, `VAL_31_8005` INT(11) NULL DEFAULT NULL, `VAL_31_8086` INT(11) NULL DEFAULT NULL, `VAL_31_8087` INT(11) NULL DEFAULT NULL, `VAL_31_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_32_101` INT(11) NULL DEFAULT NULL, `VAL_32_102` INT(11) NULL DEFAULT NULL, `VAL_32_103` INT(11) NULL DEFAULT NULL, `VAL_32_104` INT(11) NULL DEFAULT NULL, `VAL_32_105` INT(11) NULL DEFAULT NULL, `VAL_32_106` INT(11) NULL DEFAULT NULL, `VAL_32_118` INT(11) NULL DEFAULT NULL, `VAL_32_119` INT(11) NULL DEFAULT NULL, `VAL_32_122` INT(11) NULL DEFAULT NULL, `VAL_32_123` INT(11) NULL DEFAULT NULL, `VAL_32_8000` INT(11) NULL DEFAULT NULL, `VAL_32_8001` INT(11) NULL DEFAULT NULL, `VAL_32_8002` INT(11) NULL DEFAULT NULL, `VAL_32_8003` INT(11) NULL DEFAULT NULL, `VAL_32_8004` INT(11) NULL DEFAULT NULL, `VAL_32_8005` INT(11) NULL DEFAULT NULL, `VAL_32_8086` INT(11) NULL DEFAULT NULL, `VAL_32_8087` INT(11) NULL DEFAULT NULL, `VAL_32_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_33_101` INT(11) NULL DEFAULT NULL, `VAL_33_102` INT(11) NULL DEFAULT NULL, `VAL_33_103` INT(11) NULL DEFAULT NULL, `VAL_33_104` INT(11) NULL DEFAULT NULL, `VAL_33_105` INT(11) NULL DEFAULT NULL, `VAL_33_106` INT(11) NULL DEFAULT NULL, `VAL_33_118` INT(11) NULL DEFAULT NULL, `VAL_33_119` INT(11) NULL DEFAULT NULL, `VAL_33_122` INT(11) NULL DEFAULT NULL, `VAL_33_123` INT(11) NULL DEFAULT NULL, `VAL_33_8000` INT(11) NULL DEFAULT NULL, `VAL_33_8001` INT(11) NULL DEFAULT NULL, `VAL_33_8002` INT(11) NULL DEFAULT NULL, `VAL_33_8003` INT(11) NULL DEFAULT NULL, `VAL_33_8004` INT(11) NULL DEFAULT NULL, `VAL_33_8005` INT(11) NULL DEFAULT NULL, `VAL_33_8086` INT(11) NULL DEFAULT NULL, `VAL_33_8087` INT(11) NULL DEFAULT NULL, `VAL_33_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_34_101` INT(11) NULL DEFAULT NULL, `VAL_34_102` INT(11) NULL DEFAULT NULL, `VAL_34_103` INT(11) NULL DEFAULT NULL, `VAL_34_104` INT(11) NULL DEFAULT NULL, `VAL_34_105` INT(11) NULL DEFAULT NULL, `VAL_34_106` INT(11) NULL DEFAULT NULL, `VAL_34_118` INT(11) NULL DEFAULT NULL, `VAL_34_119` INT(11) NULL DEFAULT NULL, `VAL_34_122` INT(11) NULL DEFAULT NULL, `VAL_34_123` INT(11) NULL DEFAULT NULL, `VAL_34_8000` INT(11) NULL DEFAULT NULL, `VAL_34_8001` INT(11) NULL DEFAULT NULL, `VAL_34_8002` INT(11) NULL DEFAULT NULL, `VAL_34_8003` INT(11) NULL DEFAULT NULL, `VAL_34_8004` INT(11) NULL DEFAULT NULL, `VAL_34_8005` INT(11) NULL DEFAULT NULL, `VAL_34_8086` INT(11) NULL DEFAULT NULL, `VAL_34_8087` INT(11) NULL DEFAULT NULL, `VAL_34_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_35_101` INT(11) NULL DEFAULT NULL, `VAL_35_102` INT(11) NULL DEFAULT NULL, `VAL_35_103` INT(11) NULL DEFAULT NULL, `VAL_35_104` INT(11) NULL DEFAULT NULL, `VAL_35_105` INT(11) NULL DEFAULT NULL, `VAL_35_106` INT(11) NULL DEFAULT NULL, `VAL_35_118` INT(11) NULL DEFAULT NULL, `VAL_35_119` INT(11) NULL DEFAULT NULL, `VAL_35_122` INT(11) NULL DEFAULT NULL, `VAL_35_123` INT(11) NULL DEFAULT NULL, `VAL_35_8000` INT(11) NULL DEFAULT NULL, `VAL_35_8001` INT(11) NULL DEFAULT NULL, `VAL_35_8002` INT(11) NULL DEFAULT NULL, `VAL_35_8003` INT(11) NULL DEFAULT NULL, `VAL_35_8004` INT(11) NULL DEFAULT NULL, `VAL_35_8005` INT(11) NULL DEFAULT NULL, `VAL_35_8086` INT(11) NULL DEFAULT NULL, `VAL_35_8087` INT(11) NULL DEFAULT NULL, `VAL_35_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_36_101` INT(11) NULL DEFAULT NULL, `VAL_36_102` INT(11) NULL DEFAULT NULL, `VAL_36_103` INT(11) NULL DEFAULT NULL, `VAL_36_104` INT(11) NULL DEFAULT NULL, `VAL_36_105` INT(11) NULL DEFAULT NULL, `VAL_36_106` INT(11) NULL DEFAULT NULL, `VAL_36_118` INT(11) NULL DEFAULT NULL, `VAL_36_119` INT(11) NULL DEFAULT NULL, `VAL_36_122` INT(11) NULL DEFAULT NULL, `VAL_36_123` INT(11) NULL DEFAULT NULL, `VAL_36_8000` INT(11) NULL DEFAULT NULL, `VAL_36_8001` INT(11) NULL DEFAULT NULL, `VAL_36_8002` INT(11) NULL DEFAULT NULL, `VAL_36_8003` INT(11) NULL DEFAULT NULL, `VAL_36_8004` INT(11) NULL DEFAULT NULL, `VAL_36_8005` INT(11) NULL DEFAULT NULL, `VAL_36_8086` INT(11) NULL DEFAULT NULL, `VAL_36_8087` INT(11) NULL DEFAULT NULL, `VAL_36_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_37_101` INT(11) NULL DEFAULT NULL, `VAL_37_102` INT(11) NULL DEFAULT NULL, `VAL_37_103` INT(11) NULL DEFAULT NULL, `VAL_37_104` INT(11) NULL DEFAULT NULL, `VAL_37_105` INT(11) NULL DEFAULT NULL, `VAL_37_106` INT(11) NULL DEFAULT NULL, `VAL_37_118` INT(11) NULL DEFAULT NULL, `VAL_37_119` INT(11) NULL DEFAULT NULL, `VAL_37_122` INT(11) NULL DEFAULT NULL, `VAL_37_123` INT(11) NULL DEFAULT NULL, `VAL_37_8000` INT(11) NULL DEFAULT NULL, `VAL_37_8001` INT(11) NULL DEFAULT NULL, `VAL_37_8002` INT(11) NULL DEFAULT NULL, `VAL_37_8003` INT(11) NULL DEFAULT NULL, `VAL_37_8004` INT(11) NULL DEFAULT NULL, `VAL_37_8005` INT(11) NULL DEFAULT NULL, `VAL_37_8086` INT(11) NULL DEFAULT NULL, `VAL_37_8087` INT(11) NULL DEFAULT NULL, `VAL_37_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_3_8000` INT(11) NULL DEFAULT NULL, `VAL_3_8001` INT(11) NULL DEFAULT NULL, `VAL_3_8002` INT(11) NULL DEFAULT NULL, `VAL_3_8003` INT(11) NULL DEFAULT NULL, `VAL_3_8004` INT(11) NULL DEFAULT NULL, `VAL_3_8005` INT(11) NULL DEFAULT NULL, `VAL_3_8086` INT(11) NULL DEFAULT NULL, `VAL_3_8087` INT(11) NULL DEFAULT NULL, `VAL_38_101` INT(11) NULL DEFAULT NULL, `VAL_38_102` INT(11) NULL DEFAULT NULL, `VAL_38_103` INT(11) NULL DEFAULT NULL, `VAL_38_104` INT(11) NULL DEFAULT NULL, `VAL_38_105` INT(11) NULL DEFAULT NULL, `VAL_38_106` INT(11) NULL DEFAULT NULL, `VAL_38_118` INT(11) NULL DEFAULT NULL, `VAL_38_119` INT(11) NULL DEFAULT NULL, `VAL_38_122` INT(11) NULL DEFAULT NULL, `VAL_38_123` INT(11) NULL DEFAULT NULL, `VAL_38_8000` INT(11) NULL DEFAULT NULL, `VAL_38_8001` INT(11) NULL DEFAULT NULL, `VAL_38_8002` INT(11) NULL DEFAULT NULL, `VAL_38_8003` INT(11) NULL DEFAULT NULL, `VAL_38_8004` INT(11) NULL DEFAULT NULL, `VAL_38_8005` INT(11) NULL DEFAULT NULL, `VAL_38_8086` INT(11) NULL DEFAULT NULL, `VAL_38_8087` INT(11) NULL DEFAULT NULL, `VAL_38_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_39_101` INT(11) NULL DEFAULT NULL, `VAL_39_102` INT(11) NULL DEFAULT NULL, `VAL_39_103` INT(11) NULL DEFAULT NULL, `VAL_39_104` INT(11) NULL DEFAULT NULL, `VAL_39_105` INT(11) NULL DEFAULT NULL, `VAL_39_106` INT(11) NULL DEFAULT NULL, `VAL_39_118` INT(11) NULL DEFAULT NULL, `VAL_39_119` INT(11) NULL DEFAULT NULL, `VAL_39_122` INT(11) NULL DEFAULT NULL, `VAL_39_123` INT(11) NULL DEFAULT NULL, `VAL_3_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_39_8000` INT(11) NULL DEFAULT NULL, `VAL_39_8001` INT(11) NULL DEFAULT NULL, `VAL_39_8002` INT(11) NULL DEFAULT NULL, `VAL_39_8003` INT(11) NULL DEFAULT NULL, `VAL_39_8004` INT(11) NULL DEFAULT NULL, `VAL_39_8005` INT(11) NULL DEFAULT NULL, `VAL_39_8086` INT(11) NULL DEFAULT NULL, `VAL_39_8087` INT(11) NULL DEFAULT NULL, `VAL_39_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_40_101` INT(11) NULL DEFAULT NULL, `VAL_40_102` INT(11) NULL DEFAULT NULL, `VAL_40_103` INT(11) NULL DEFAULT NULL, `VAL_40_104` INT(11) NULL DEFAULT NULL, `VAL_40_105` INT(11) NULL DEFAULT NULL, `VAL_40_106` INT(11) NULL DEFAULT NULL, `VAL_40_118` INT(11) NULL DEFAULT NULL, `VAL_40_119` INT(11) NULL DEFAULT NULL, `VAL_40_122` INT(11) NULL DEFAULT NULL, `VAL_40_123` INT(11) NULL DEFAULT NULL, `VAL_40_8000` INT(11) NULL DEFAULT NULL, `VAL_40_8001` INT(11) NULL DEFAULT NULL, `VAL_40_8002` INT(11) NULL DEFAULT NULL, `VAL_40_8003` INT(11) NULL DEFAULT NULL, `VAL_40_8004` INT(11) NULL DEFAULT NULL, `VAL_40_8005` INT(11) NULL DEFAULT NULL, `VAL_40_8086` INT(11) NULL DEFAULT NULL, `VAL_40_8087` INT(11) NULL DEFAULT NULL, `VAL_40_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_4_101` INT(11) NULL DEFAULT NULL, `VAL_4_102` INT(11) NULL DEFAULT NULL, `VAL_4_103` INT(11) NULL DEFAULT NULL, `VAL_4_104` INT(11) NULL DEFAULT NULL, `VAL_4_105` INT(11) NULL DEFAULT NULL, `VAL_4_106` INT(11) NULL DEFAULT NULL, `VAL_41_101` INT(11) NULL DEFAULT NULL, `VAL_41_102` INT(11) NULL DEFAULT NULL, `VAL_41_103` INT(11) NULL DEFAULT NULL, `VAL_41_104` INT(11) NULL DEFAULT NULL, `VAL_41_105` INT(11) NULL DEFAULT NULL, `VAL_41_106` INT(11) NULL DEFAULT NULL, `VAL_41_118` INT(11) NULL DEFAULT NULL, `VAL_41_119` INT(11) NULL DEFAULT NULL, `VAL_41_122` INT(11) NULL DEFAULT NULL, `VAL_41_123` INT(11) NULL DEFAULT NULL, `VAL_4_118` INT(11) NULL DEFAULT NULL, `VAL_4_119` INT(11) NULL DEFAULT NULL, `VAL_4_122` INT(11) NULL DEFAULT NULL, `VAL_4_123` INT(11) NULL DEFAULT NULL, `VAL_41_8000` INT(11) NULL DEFAULT NULL, `VAL_41_8001` INT(11) NULL DEFAULT NULL, `VAL_41_8002` INT(11) NULL DEFAULT NULL, `VAL_41_8003` INT(11) NULL DEFAULT NULL, `VAL_41_8004` INT(11) NULL DEFAULT NULL, `VAL_41_8005` INT(11) NULL DEFAULT NULL, `VAL_41_8086` INT(11) NULL DEFAULT NULL, `VAL_41_8087` INT(11) NULL DEFAULT NULL, `VAL_41_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_42_101` INT(11) NULL DEFAULT NULL, `VAL_42_102` INT(11) NULL DEFAULT NULL, `VAL_42_103` INT(11) NULL DEFAULT NULL, `VAL_42_104` INT(11) NULL DEFAULT NULL, `VAL_42_105` INT(11) NULL DEFAULT NULL, `VAL_42_106` INT(11) NULL DEFAULT NULL, `VAL_42_118` INT(11) NULL DEFAULT NULL, `VAL_42_119` INT(11) NULL DEFAULT NULL, `VAL_42_122` INT(11) NULL DEFAULT NULL, `VAL_42_123` INT(11) NULL DEFAULT NULL, `VAL_42_8000` INT(11) NULL DEFAULT NULL, `VAL_42_8001` INT(11) NULL DEFAULT NULL, `VAL_42_8002` INT(11) NULL DEFAULT NULL, `VAL_42_8003` INT(11) NULL DEFAULT NULL, `VAL_42_8004` INT(11) NULL DEFAULT NULL, `VAL_42_8005` INT(11) NULL DEFAULT NULL, `VAL_42_8086` INT(11) NULL DEFAULT NULL, `VAL_42_8087` INT(11) NULL DEFAULT NULL, `VAL_42_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_43_101` INT(11) NULL DEFAULT NULL, `VAL_43_102` INT(11) NULL DEFAULT NULL, `VAL_43_103` INT(11) NULL DEFAULT NULL, `VAL_43_104` INT(11) NULL DEFAULT NULL, `VAL_43_105` INT(11) NULL DEFAULT NULL, `VAL_43_106` INT(11) NULL DEFAULT NULL, `VAL_43_118` INT(11) NULL DEFAULT NULL, `VAL_43_119` INT(11) NULL DEFAULT NULL, `VAL_43_122` INT(11) NULL DEFAULT NULL, `VAL_43_123` INT(11) NULL DEFAULT NULL, `VAL_43_8000` INT(11) NULL DEFAULT NULL, `VAL_43_8001` INT(11) NULL DEFAULT NULL, `VAL_43_8002` INT(11) NULL DEFAULT NULL, `VAL_43_8003` INT(11) NULL DEFAULT NULL, `VAL_43_8004` INT(11) NULL DEFAULT NULL, `VAL_43_8005` INT(11) NULL DEFAULT NULL, `VAL_43_8086` INT(11) NULL DEFAULT NULL, `VAL_43_8087` INT(11) NULL DEFAULT NULL, `VAL_43_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_44_101` INT(11) NULL DEFAULT NULL, `VAL_44_102` INT(11) NULL DEFAULT NULL, `VAL_44_103` INT(11) NULL DEFAULT NULL, `VAL_44_104` INT(11) NULL DEFAULT NULL, `VAL_44_105` INT(11) NULL DEFAULT NULL, `VAL_44_106` INT(11) NULL DEFAULT NULL, `VAL_44_118` INT(11) NULL DEFAULT NULL, `VAL_44_119` INT(11) NULL DEFAULT NULL, `VAL_44_122` INT(11) NULL DEFAULT NULL, `VAL_44_123` INT(11) NULL DEFAULT NULL, `VAL_44_8000` INT(11) NULL DEFAULT NULL, `VAL_44_8001` INT(11) NULL DEFAULT NULL, `VAL_44_8002` INT(11) NULL DEFAULT NULL, `VAL_44_8003` INT(11) NULL DEFAULT NULL, `VAL_44_8004` INT(11) NULL DEFAULT NULL, `VAL_44_8005` INT(11) NULL DEFAULT NULL, `VAL_44_8086` INT(11) NULL DEFAULT NULL, `VAL_44_8087` INT(11) NULL DEFAULT NULL, `VAL_44_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_4_8000` INT(11) NULL DEFAULT NULL, `VAL_4_8001` INT(11) NULL DEFAULT NULL, `VAL_4_8002` INT(11) NULL DEFAULT NULL, `VAL_4_8003` INT(11) NULL DEFAULT NULL, `VAL_4_8004` INT(11) NULL DEFAULT NULL, `VAL_4_8005` INT(11) NULL DEFAULT NULL, `VAL_4_8086` INT(11) NULL DEFAULT NULL, `VAL_4_8087` INT(11) NULL DEFAULT NULL, `VAL_4_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_5_101` INT(11) NULL DEFAULT NULL, `VAL_5_102` INT(11) NULL DEFAULT NULL, `VAL_5_103` INT(11) NULL DEFAULT NULL, `VAL_5_104` INT(11) NULL DEFAULT NULL, `VAL_5_105` INT(11) NULL DEFAULT NULL, `VAL_5_106` INT(11) NULL DEFAULT NULL, `VAL_5_118` INT(11) NULL DEFAULT NULL, `VAL_5_119` INT(11) NULL DEFAULT NULL, `VAL_5_122` INT(11) NULL DEFAULT NULL, `VAL_5_123` INT(11) NULL DEFAULT NULL, `VAL_5_8000` INT(11) NULL DEFAULT NULL, `VAL_5_8001` INT(11) NULL DEFAULT NULL, `VAL_5_8002` INT(11) NULL DEFAULT NULL, `VAL_5_8003` INT(11) NULL DEFAULT NULL, `VAL_5_8004` INT(11) NULL DEFAULT NULL, `VAL_5_8005` INT(11) NULL DEFAULT NULL, `VAL_5_8086` INT(11) NULL DEFAULT NULL, `VAL_5_8087` INT(11) NULL DEFAULT NULL, `VAL_5_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_6_101` INT(11) NULL DEFAULT NULL, `VAL_6_102` INT(11) NULL DEFAULT NULL, `VAL_6_103` INT(11) NULL DEFAULT NULL, `VAL_6_104` INT(11) NULL DEFAULT NULL, `VAL_6_105` INT(11) NULL DEFAULT NULL, `VAL_6_106` INT(11) NULL DEFAULT NULL, `VAL_6_118` INT(11) NULL DEFAULT NULL, `VAL_6_119` INT(11) NULL DEFAULT NULL, `VAL_6_122` INT(11) NULL DEFAULT NULL, `VAL_6_123` INT(11) NULL DEFAULT NULL, `VAL_6_8000` INT(11) NULL DEFAULT NULL, `VAL_6_8001` INT(11) NULL DEFAULT NULL, `VAL_6_8002` INT(11) NULL DEFAULT NULL, `VAL_6_8003` INT(11) NULL DEFAULT NULL, `VAL_6_8004` INT(11) NULL DEFAULT NULL, `VAL_6_8005` INT(11) NULL DEFAULT NULL, `VAL_6_8086` INT(11) NULL DEFAULT NULL, `VAL_6_8087` INT(11) NULL DEFAULT NULL, `VAL_6_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_7_101` INT(11) NULL DEFAULT NULL, `VAL_7_102` INT(11) NULL DEFAULT NULL, `VAL_7_103` INT(11) NULL DEFAULT NULL, `VAL_7_104` INT(11) NULL DEFAULT NULL, `VAL_7_105` INT(11) NULL DEFAULT NULL, `VAL_7_106` INT(11) NULL DEFAULT NULL, `VAL_7_118` INT(11) NULL DEFAULT NULL, `VAL_7_119` INT(11) NULL DEFAULT NULL, `VAL_7_122` INT(11) NULL DEFAULT NULL, `VAL_7_123` INT(11) NULL DEFAULT NULL, `VAL_7_8000` INT(11) NULL DEFAULT NULL, `VAL_7_8001` INT(11) NULL DEFAULT NULL, `VAL_7_8002` INT(11) NULL DEFAULT NULL, `VAL_7_8003` INT(11) NULL DEFAULT NULL, `VAL_7_8004` INT(11) NULL DEFAULT NULL, `VAL_7_8005` INT(11) NULL DEFAULT NULL, `VAL_7_8086` INT(11) NULL DEFAULT NULL, `VAL_7_8087` INT(11) NULL DEFAULT NULL, `VAL_7_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_8_101` INT(11) NULL DEFAULT NULL, `VAL_8_102` INT(11) NULL DEFAULT NULL, `VAL_8_103` INT(11) NULL DEFAULT NULL, `VAL_8_104` INT(11) NULL DEFAULT NULL, `VAL_8_105` INT(11) NULL DEFAULT NULL, `VAL_8_106` INT(11) NULL DEFAULT NULL, `VAL_8_118` INT(11) NULL DEFAULT NULL, `VAL_8_119` INT(11) NULL DEFAULT NULL, `VAL_8_122` INT(11) NULL DEFAULT NULL, `VAL_8_123` INT(11) NULL DEFAULT NULL, `VAL_8_8000` INT(11) NULL DEFAULT NULL, `VAL_8_8001` INT(11) NULL DEFAULT NULL, `VAL_8_8002` INT(11) NULL DEFAULT NULL, `VAL_8_8003` INT(11) NULL DEFAULT NULL, `VAL_8_8004` INT(11) NULL DEFAULT NULL, `VAL_8_8005` INT(11) NULL DEFAULT NULL, `VAL_8_8086` INT(11) NULL DEFAULT NULL, `VAL_8_8087` INT(11) NULL DEFAULT NULL, `VAL_8_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VAL_9_101` INT(11) NULL DEFAULT NULL, `VAL_9_102` INT(11) NULL DEFAULT NULL, `VAL_9_103` INT(11) NULL DEFAULT NULL, `VAL_9_104` INT(11) NULL DEFAULT NULL, `VAL_9_105` INT(11) NULL DEFAULT NULL, `VAL_9_106` INT(11) NULL DEFAULT NULL, `VAL_9_118` INT(11) NULL DEFAULT NULL, `VAL_9_119` INT(11) NULL DEFAULT NULL, `VAL_9_122` INT(11) NULL DEFAULT NULL, `VAL_9_123` INT(11) NULL DEFAULT NULL, `VAL_9_8000` INT(11) NULL DEFAULT NULL, `VAL_9_8001` INT(11) NULL DEFAULT NULL, `VAL_9_8002` INT(11) NULL DEFAULT NULL, `VAL_9_8003` INT(11) NULL DEFAULT NULL, `VAL_9_8004` INT(11) NULL DEFAULT NULL, `VAL_9_8005` INT(11) NULL DEFAULT NULL, `VAL_9_8086` INT(11) NULL DEFAULT NULL, `VAL_9_8087` INT(11) NULL DEFAULT NULL, `VAL_9_9400` DECIMAL(12,2) NULL DEFAULT NULL, `VM` DECIMAL(10,3) NULL DEFAULT NULL, `ZE` DECIMAL(10,3) NULL DEFAULT NULL, `ZKLASS_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `ZZB_ID` SMALLINT(5) UNSIGNED NULL DEFAULT NULL ) ENGINE=Columnstore ; INSERT INTO `test_cs` VALUES (2, NULL, 79017972, 523, 2349, 2350, 2350, 5, 51671, 457, 1, 81, 1, 2, 1129470, 25137, 25137, 2, 1, 1000328, 2, 1, 21, 19, 3, 3, 99, 1118460, 1118460, 10328807, 3, 2241, 11299, 9085, NULL, 3, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4206, 0, 0, 9995, 9953, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4126, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4084, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 9995, 9995, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4251, 2642, 2493, 4251, 4251, 4251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4257, 2642, 2493, 4257, 4257, 4257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4257, 2642, 2493, 4257, 4257, 4257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2493, 4257, 2642, 2493, 4257, 4257, 4257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 9995, 9995, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 0, 1, 0, 2, 0, 0, 4003, 0, 0.00, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 0, 6, 1, 1, 5, 1, 3997, 0, 0.00, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 0, 2, 0, 3, 0, 4, 3996, 0, 0.00, 2279, 3886, 2421, 2279, 3886, 3886, 3886, 0, 0, 0, 0, 2, 1, 4, 0, 5, 3988, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 3, 1, 6, 0, 6, 3981, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 1, 0, 5, 0, 0, 3964, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0.00, 0, 3, 1, 3, 0, 0, 3960, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 1, 0, 2, 0, 0, 3945, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 9995, 9995, 0, 0, 0, 3, 2, 3, 4, 2, 3940, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 3, 1, 0, 2, 1, 3933, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 1, 0, 4, 0, 3, 3924, 0, 0.00, 2279, 3987, 2421, 2279, 3987, 3987, 3987, 0, 0, 0, 0, 2, 1, 4, 0, 3, 3922, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 9995, 9995, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7036, 9995, 7328, 7036, 9995, 0, 9995, 9995, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7163, 10155, 7459, 7163, 10155, 0, 10155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7163, 10155, 7459, 7163, 10155, 0, 10155, 10155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 7163, 10155, 7459, 7163, 10155, 0, 10155, 10155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 100.000, 100.000, 1, NULL), (5, NULL, 81167668, 646, 649, 654, 661, 3, 52048, 412, 22418, 143, 0, 1, 1071103, 20350, 20350, 2, 1, 20350, 2, 3, 57, 72, 4, 4, 982, 564164, 564164, 10111344, 1, 1, 11276, 1, NULL, 1, 633, 995, 745, 633, 995, 0, 972, 826, 0, 0, 1, 0, 0, 1, 2, 0, 1927, 0, 0.00, 633, 995, 745, 633, 995, 0, 633, 995, 745, 633, 995, 0, 979, 856, 0, 0, 968, 838, 0, 0, 2, 0, 0, 1, 2, 0, 1927, 0, 0.00, 633, 995, 745, 633, 995, 0, 983, 849, 0, 0, 3, 0, 0, 2, 3, 0, 1923, 0, 0.00, 633, 995, 745, 633, 995, 0, 978, 835, 0, 0, 3, 0, 0, 2, 5, 0, 1926, 0, 0.00, 633, 995, 745, 633, 995, 0, 963, 821, 0, 0, 0, 0, 0, 2, 0, 0, 1917, 0, 0.00, 633, 995, 745, 633, 995, 0, 973, 832, 0, 0, 0, 0, 0, 2, 0, 0, 1918, 0, 0.00, 633, 995, 745, 633, 995, 0, 955, 840, 0, 0, 0, 0, 0, 2, 0, 0, 1916, 0, 0.00, 633, 995, 745, 633, 995, 0, 977, 844, 0, 0, 0, 0, 0, 2, 0, 0, 1916, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 633, 995, 745, 633, 995, 0, 982, 838, 0, 0, 1, 0, 0, 1, 0, 0, 1917, 0, 0.00, 633, 995, 745, 633, 995, 0, 973, 857, 0, 0, 0.00, 1, 0, 0, 1, 8, 0, 1912, 0, 0.00, 633, 995, 745, 633, 995, 0, 981, 881, 0, 0, 0, 0, 0, 1, 0, 0, 1912, 0, 0.00, 633, 995, 745, 633, 995, 0, 761, 1295, 895, 761, 1295, 0, 1192, 1040, 0, 0, 960, 865, 0, 0, 2, 0, 0, 1, 2, 0, 1907, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1192, 1065, 0, 0, 1, 0, 0, 1, 1, 0, 1900, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1200, 1094, 0, 0, 1, 0, 0, 2, 2, 0, 1899, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1118, 911, 0, 0, 1, 0, 0, 2, 1, 0, 1896, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1215, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1895, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1199, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1892, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1210, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1889, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 761, 1295, 895, 761, 1295, 0, 1190, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1879, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1170, 0, 0, 0, 0.00, 1, 0, 0, 1, 1, 0, 1879, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1223, 0, 0, 0, 2, 0, 0, 0, 2, 0, 1867, 0, 0.00, 633, 995, 745, 633, 995, 0, 761, 1295, 895, 761, 1295, 0, 1217, 0, 0, 0, 972, 812, 0, 0, 0, 0, 0, 1, 0, 0, 1858, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1212, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1857, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1182, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1203, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1169, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1228, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1295, 895, 761, 1295, 0, 1229, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 761, 1655, 895, 761, 1655, 0, 1408, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1655, 895, 761, 1655, 0, 1432, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1655, 895, 761, 1655, 0, 1445, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 633, 995, 745, 633, 995, 0, 761, 1655, 895, 761, 1655, 0, 1450, 0, 0, 0, 979, 852, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1655, 895, 761, 1655, 0, 1444, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1655, 895, 761, 1655, 0, 1447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 761, 1655, 895, 761, 1655, 0, 1446, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 633, 995, 745, 633, 995, 0, 980, 844, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 633, 995, 745, 633, 995, 0, 979, 809, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 633, 995, 745, 633, 995, 0, 972, 844, 0, 0, 1, 0, 0, 0, 1, 0, 1935, 0, 0.00, 633, 995, 745, 633, 995, 0, 976, 854, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 633, 995, 745, 633, 995, 0, 965, 847, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 20.000, 20.000, 18, NULL), (3, NULL, 92215034, 567, 595, 596, 596, 10, 7330, 108, 1, 235, 3, 2, 392079, 25137, 25137, 2, 1, 1000328, 2, 1, 14, 13, 1, 1, 983, 283695, 283695, 2158142, 2, 552, 11299, 2848, NULL, 2, 359, 797, 427, 359, 797, 628, 614, 354, 0, 0, 0, 0, 0, 1, 0, 0, 298, 0, 0.00, 334, 759, 397, 334, 759, 628, 359, 797, 427, 359, 797, 628, 628, 356, 0, 0, 576, 317, 0, 0, 0, 0, 1, 1, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 635, 352, 0, 0, 0, 0, 0, 1, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 630, 344, 0, 0, 0, 0, 0, 1, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 603, 338, 0, 0, 0, 0, 0, 1, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 568, 342, 0, 0, 1, 0, 0, 8, 10, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 558, 335, 0, 0, 6, 0, 0, 2, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 564, 335, 0, 0, 3, 0, 0, 1, 0, 0, 298, 0, 0.00, 2, 0, 0, 57, 0, 60, 306, 0, 359, 797, 427, 359, 797, 628, 584, 346, 0, 0, 23, 0, 1, 1, 0, 0, 298, 1, 0.00, 359, 797, 427, 359, 797, 628, 602, 373, 0, 0, 0.00, 11, 0, 0, 1, 0, 0, 298, 0, 0.00, 359, 797, 427, 359, 797, 628, 599, 356, 0, 0, 0, 0, 0, 1, 0, 0, 298, 0, 0.00, 334, 759, 397, 334, 759, 628, 359, 797, 427, 359, 797, 628, 616, 356, 0, 0, 573, 316, 0, 0, 0, 0, 0, 1, 1, 0, 296, 0, 0.00, 359, 797, 427, 359, 797, 628, 641, 331, 0, 0, 0, 0, 0, 1, 0, 0, 295, 0, 0.00, 359, 797, 427, 359, 797, 628, 636, 350, 0, 0, 0, 0, 0, 1, 0, 0, 294, 0, 0.00, 359, 797, 427, 359, 797, 628, 654, 352, 0, 0, 0, 0, 0, 1, 0, 0, 294, 0, 0.00, 359, 797, 427, 359, 797, 628, 644, 0, 0, 0, 0, 0, 0, 1, 0, 2, 293, 0, 0.00, 359, 797, 427, 359, 797, 628, 648, 0, 0, 0, 0, 0, 0, 1, 0, 0, 291, 0, 0.00, 359, 797, 427, 359, 797, 628, 613, 0, 0, 0, 1, 0, 0, 1, 1, 0, 289, 0, 0.00, 0, 0, 0, 50, 0, 0, 306, 0, 377, 835, 447, 377, 835, 628, 623, 0, 0, 0, 1, 0, 0, 0, 0, 0, 286, 0, 0.00, 377, 835, 447, 377, 835, 628, 602, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 835, 447, 377, 835, 628, 602, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 334, 759, 397, 334, 759, 628, 377, 814, 447, 377, 814, 612, 615, 0, 0, 0, 523, 324, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 814, 447, 377, 814, 612, 619, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 814, 447, 377, 814, 612, 626, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 814, 447, 377, 814, 612, 637, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 814, 447, 377, 814, 612, 632, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 814, 447, 377, 814, 612, 642, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 835, 447, 377, 835, 628, 631, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 1, 0, 0, 42, 0, 0, 305, 0, 377, 835, 447, 377, 835, 628, 647, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 835, 447, 377, 835, 628, 586, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 377, 835, 447, 377, 835, 628, 601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 359, 797, 427, 359, 797, 628, 377, 835, 447, 377, 835, 628, 609, 0, 0, 0, 556, 322, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 388, 859, 460, 388, 859, 628, 608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 388, 859, 460, 388, 859, 628, 620, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 388, 859, 460, 388, 859, 628, 639, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 2, 0, 0, 35, 0, 0, 305, 0, 0.00, 359, 797, 427, 359, 797, 628, 559, 321, 0, 0, 8, 0, 0, 27, 0, 0, 304, 0, 0.00, 359, 797, 427, 359, 797, 628, 560, 316, 0, 0, 1, 0, 1, 20, 0, 0, 301, 0, 0.00, 359, 797, 427, 359, 797, 628, 570, 325, 0, 0, 1, 0, 0, 12, 0, 0, 301, 0, 0.00, 359, 797, 427, 359, 797, 628, 577, 339, 0, 0, 0, 0, 0, 4, 0, 0, 301, 0, 0.00, 359, 797, 427, 359, 797, 628, 598, 347, 0, 0, 1, 0, 0, 1, 0, 0, 301, 0, 0.00, 20.000, 20.000, 1, NULL), (5, NULL, 102, 234, 239, 266, 271, 2, 57626, 291, 196254, 78, 0, 1, 1137544, 8095, 8095, 2, 1, 8095, 2, 11, 62, 265, 4, 4, 98, 1124829, 1124829, 11108255, 1, 1, 17562, 18490, NULL, 0, 965, 1221, 975, 965, 1221, 0, 1205, 1152, 0, 0, 0, 0, 0, 0, 3, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 965, 1221, 975, 965, 1221, 0, 1314, 1140, 0, 0, 1269, 1140, 0, 0, 0, 0, 0, 0, 0, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1239, 1138, 0, 0, 2, 0, 0, 0, 1, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1210, 1138, 0, 0, 0, 0, 0, 0, 1, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1202, 1152, 0, 0, 0, 0, 0, 0, 1, 0, 398, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1242, 1142, 0, 0, 0, 0, 0, 0, 2, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1233, 1128, 0, 0, 0, 0, 0, 0, 2, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1223, 1135, 0, 0, 0, 0, 0, 0, 1, 0, 399, 0, 0.00, 0, 0, 0, 0, 6, 0, 407, 0, 965, 1221, 975, 965, 1221, 0, 1207, 1163, 0, 0, 0, 0, 0, 0, 0, 0, 402, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1225, 1139, 0, 0, 0.00, 0, 0, 0, 0, 2, 0, 402, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1236, 1149, 0, 0, 0, 0, 0, 0, 0, 0, 402, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 965, 1221, 975, 965, 1221, 0, 1171, 1130, 0, 0, 1267, 1132, 0, 0, 0, 0, 0, 0, 2, 0, 400, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1219, 1118, 0, 0, 0, 0, 0, 0, -1, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1224, 1176, 0, 0, 0, 0, 0, 0, 3, 0, 398, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1279, 1201, 0, 0, 0, 0, 0, 0, 2, 0, 398, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1218, 0, 0, 0, 8, 0, 0, 0, 2, 0, 398, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1225, 0, 0, 0, 0, 0, 0, 0, 3, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1213, 0, 0, 0, 2, 0, 0, 0, -1, 0, 399, 0, 0.00, 0, 0, 0, 0, 3, 0, 407, 0, 965, 1221, 975, 965, 1221, 0, 1251, 0, 0, 0, 5, 0, 0, 0, 0, 0, 399, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1188, 0, 0, 0, 0.00, 0, 0, 0, 0, 1, 0, 398, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1218, 0, 0, 0, 2, 0, 0, 0, 0, 0, 396, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 965, 1221, 975, 965, 1221, 0, 1213, 0, 0, 0, 1229, 1152, 0, 0, 3, 0, 0, 0, 1, 0, 394, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1191, 0, 0, 0, 0, 0, 0, 0, 0, 0, 394, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1291, 0, 0, 0, 0, 0, 0, 0, 0, 0, 394, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1191, 0, 0, 0, 0, 0, 0, 0, 1, 0, 393, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1229, 0, 0, 0, 1, 0, 0, 0, 0, 0, 393, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1207, 0, 0, 0, 0, 0, 0, 0, 1, 0, 392, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1215, 0, 0, 0, 5, 0, 0, 0, 1, 0, 391, 0, 0.00, 0, 0, 0, 0, 3, 0, 406, 0, 965, 1221, 975, 965, 1221, 0, 1203, 0, 0, 0, 0, 0, 0, 0, 1, 0, 390, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1255, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 389, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1237, 0, 0, 0, 0, 0, 0, 0, 1, 0, 388, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 965, 1221, 975, 965, 1221, 0, 1200, 0, 0, 0, 1273, 1130, 0, 0, 1, 0, 0, 0, 3, 0, 388, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1287, 0, 0, 0, 1, 0, 0, 0, 1, 0, 388, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1207, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1206, 0, 0, 0, 1, 0, 0, 0, 4, 0, 386, 0, 0.00, 0, 0, 0, 0, 3, 0, 404, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1305, 1166, 0, 0, 0, 0, 0, 0, 17, 0, 404, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1297, 1155, 0, 0, 4, 0, 0, 0, 7, 0, 401, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1293, 1136, 0, 0, 0, 0, 0, 0, 6, 0, 400, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1303, 1152, 0, 0, 0, 0, 0, 0, 8, 0, 400, 0, 0.00, 965, 1221, 975, 965, 1221, 0, 1208, 1172, 0, 0, 0, 0, 0, 0, 7, 0, 400, 0, 0.00, 100.000, 100.000, 8, NULL), (2, NULL, 11357896, 195, 2000, 2001, 2001, 9, 42083, 108, 1, 256, 2, 2, 336809, 11965, 11965, 2, 1, 1000223, 2, 1, 14, 13, 3, 3, 99, 235783, 235783, 713013, 3, 2368, 11299, 2110, NULL, 3, 220, 1377, 297, 220, 1377, 1377, 1377, 1360, 0, 0, 0, 4, 0, 1, 4, 0, 3165, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 220, 1377, 297, 220, 1377, 1377, 1377, 1357, 0, 0, 1377, 1370, 0, 0, 0, 1, 0, 2, 2, 0, 3165, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1368, 0, 0, 0, 1, 0, 1, 0, 0, 3158, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1321, 0, 0, 0, 3, 1, 2, 4, 0, 3164, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1263, 0, 0, 0, 1, 0, 1, 0, 0, 3146, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1310, 0, 0, 0, 3, 0, 1, 3, 0, 3144, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1333, 0, 0, 0, 3, 0, 3, 5, 0, 3143, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1279, 0, 0, 0, 2, 0, 1, 0, 0, 3143, 0, 0.00, 0, 2, 0, 3, 4, 0, 3195, 0, 220, 1377, 297, 220, 1377, 1377, 1377, 1325, 0, 0, 0, 2, 0, 1, 2, 0, 3147, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1312, 0, 0, 0.00, 0, 3, 0, 1, 3, 0, 3149, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1317, 0, 0, 0, 4, 0, 2, 5, 0, 3149, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 220, 1377, 297, 220, 1377, 1377, 1377, 1309, 0, 0, 1377, 1355, 0, 0, 0, 3, 0, 2, 3, 0, 3139, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1342, 0, 0, 0, 7, 1, 6, 12, 0, 3137, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1308, 0, 0, 0, 5, 1, 4, 5, 0, 3126, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1319, 0, 0, 0, 6, 1, 3, 6, 0, 3124, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 6, 0, 6, 10, 0, 3118, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 7, 1, 2, 5, 0, 3116, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 9, 0, 6, 11, 0, 3109, 0, 0.00, 0, 3, 1, 1, 2, 0, 3195, 0, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 8, 1, 3, 5, 0, 3093, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0.00, 0, 3, 0, 5, 6, 0, 3095, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 5, 0, 2, 2, 0, 3069, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 1377, 1371, 0, 0, 0, 8, 1, 3, 10, 0, 3066, 0, 0.00, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 0, 1, 0, 2, 0, 0, 3062, 0, 0.00, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 0, 4, 1, 3, 6, 0, 3060, 0, 0.00, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 0, 5, 1, 3, 6, 0, 3054, 0, 0.00, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 0, 5, 0, 2, 4, 0, 3051, 0, 0.00, 220, 1348, 297, 220, 1348, 1348, 1348, 0, 0, 0, 0, 4, 0, 3, 5, 0, 3050, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 6, 1, 5, 9, 0, 3036, 0, 0.00, 0, 4, 1, 2, 6, 0, 3193, 0, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 4, 0, 5, 4, 0, 3027, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0.00, 0, 2, 0, 3, 0, 0, 3025, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 5, 0, 0, 6, 0, 3023, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 1377, 1357, 0, 0, 0, 5, 1, 5, 6, 0, 3018, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 3, 0, 3, 3, 0, 3007, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 6, 0, 1, 3, 0, 2999, 0, 0.00, 220, 1383, 297, 220, 1383, 1383, 1383, 0, 0, 0, 0, 4, 1, 2, 6, 0, 2992, 0, 0.00, 0, 1, 0, 1, 0, 0, 3189, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1352, 0, 0, 0, 4, 0, 3, 6, 0, 3190, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1352, 0, 0, 0, 3, 1, 2, 3, 0, 3166, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1359, 0, 0, 0, 2, 0, 3, 3, 0, 3162, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1363, 0, 0, 0, 4, 0, 2, 3, 0, 3164, 0, 0.00, 220, 1377, 297, 220, 1377, 1377, 1377, 1364, 0, 0, 0, 1, 0, 1, 0, 0, 3163, 0, 0.00, 100.000, 100.000, 1, NULL); DROP TABLE if EXISTS apo_innodb; CREATE TABLE `apo_innodb` ( `apo_id` INT(11) NULL DEFAULT NULL, `$10003_1` BIGINT(11) NULL DEFAULT NULL, `$10010_1` BIGINT(11) NULL DEFAULT NULL, `$10016_1` BIGINT(11) NULL DEFAULT NULL, `$10079_1` BIGINT(11) NULL DEFAULT NULL, `$10088_1` BIGINT(11) NULL DEFAULT NULL, `$10101_1` BIGINT(11) NULL DEFAULT NULL, `$10121_1` BIGINT(11) NULL DEFAULT NULL, `$10122_1` BIGINT(11) NULL DEFAULT NULL, `$10127_1` BIGINT(11) NULL DEFAULT NULL, `$10129_1` BIGINT(11) NULL DEFAULT NULL, `$10130_1` BIGINT(11) NULL DEFAULT NULL, `$10131_1` BIGINT(11) NULL DEFAULT NULL, `$10132_1` BIGINT(11) NULL DEFAULT NULL, `$10133_1` BIGINT(11) NULL DEFAULT NULL, `$10138_1` BIGINT(11) NULL DEFAULT NULL, `$10139_1` BIGINT(11) NULL DEFAULT NULL, `$1856_1` BIGINT(11) NULL DEFAULT NULL, `$2117_1` BIGINT(11) NULL DEFAULT NULL, `$2273_1` BIGINT(11) NULL DEFAULT NULL, `$2321_1` BIGINT(11) NULL DEFAULT NULL, `$2375_1` BIGINT(11) NULL DEFAULT NULL, `$2382_1` BIGINT(11) NULL DEFAULT NULL, `$2_1` BIGINT(11) NULL DEFAULT NULL, `$40_1` BIGINT(11) NULL DEFAULT NULL, `$9999_1` BIGINT(11) NULL DEFAULT NULL, `bl_id` INT(10) UNSIGNED NULL DEFAULT NULL, `EH1` DECIMAL(37,0) NULL DEFAULT NULL, `EH2` DECIMAL(37,0) NULL DEFAULT NULL, `EH3` DECIMAL(37,0) NULL DEFAULT NULL, `EH4` DECIMAL(37,0) NULL DEFAULT NULL, `EH5` DECIMAL(37,0) NULL DEFAULT NULL, `EH6` DECIMAL(37,0) NULL DEFAULT NULL, `EH7` DECIMAL(37,0) NULL DEFAULT NULL, `EH8` DECIMAL(37,0) NULL DEFAULT NULL, `EH9` DECIMAL(37,0) NULL DEFAULT NULL, `EH10` DECIMAL(37,0) NULL DEFAULT NULL, `EH11` DECIMAL(37,0) NULL DEFAULT NULL, `EH12` DECIMAL(37,0) NULL DEFAULT NULL, `EH13` DECIMAL(37,0) NULL DEFAULT NULL, `EH14` DECIMAL(37,0) NULL DEFAULT NULL, `EH15` DECIMAL(37,0) NULL DEFAULT NULL, `EH16` DECIMAL(37,0) NULL DEFAULT NULL, `EH17` DECIMAL(37,0) NULL DEFAULT NULL, `EH18` DECIMAL(37,0) NULL DEFAULT NULL, `EH19` DECIMAL(37,0) NULL DEFAULT NULL, `EH20` DECIMAL(37,0) NULL DEFAULT NULL, `EH21` DECIMAL(37,0) NULL DEFAULT NULL, `EH22` DECIMAL(37,0) NULL DEFAULT NULL, `EH23` DECIMAL(37,0) NULL DEFAULT NULL, `EH24` DECIMAL(37,0) NULL DEFAULT NULL, `EH25` DECIMAL(37,0) NULL DEFAULT NULL, `EH26` DECIMAL(37,0) NULL DEFAULT NULL, `EH27` DECIMAL(37,0) NULL DEFAULT NULL, `EH28` DECIMAL(37,0) NULL DEFAULT NULL, `EH29` DECIMAL(37,0) NULL DEFAULT NULL, `EH30` DECIMAL(37,0) NULL DEFAULT NULL, `EH31` DECIMAL(37,0) NULL DEFAULT NULL, `EH32` DECIMAL(37,0) NULL DEFAULT NULL, `EH33` DECIMAL(37,0) NULL DEFAULT NULL, `EH34` DECIMAL(37,0) NULL DEFAULT NULL, `EH35` DECIMAL(37,0) NULL DEFAULT NULL, `EH36` DECIMAL(37,0) NULL DEFAULT NULL, `EH37` DECIMAL(37,0) NULL DEFAULT NULL, `EH38` DECIMAL(37,0) NULL DEFAULT NULL, `EH39` DECIMAL(37,0) NULL DEFAULT NULL, `EH40` DECIMAL(37,0) NULL DEFAULT NULL, `EH41` DECIMAL(37,0) NULL DEFAULT NULL, `EH42` DECIMAL(37,0) NULL DEFAULT NULL, `EH43` DECIMAL(37,0) NULL DEFAULT NULL, `EH44` DECIMAL(37,0) NULL DEFAULT NULL ) ENGINE=InnoDB ; INSERT INTO `apo_innodb` (`apo_id`, `$10003_1`, `$10010_1`, `$10016_1`, `$10079_1`, `$10088_1`, `$10101_1`, `$10121_1`, `$10122_1`, `$10127_1`, `$10129_1`, `$10130_1`, `$10131_1`, `$10132_1`, `$10133_1`, `$10138_1`, `$10139_1`, `$1856_1`, `$2117_1`, `$2273_1`, `$2321_1`, `$2375_1`, `$2382_1`, `$2_1`, `$40_1`, `$9999_1`, `bl_id`, `EH1`, `EH2`, `EH3`, `EH4`, `EH5`, `EH6`, `EH7`, `EH8`, `EH9`, `EH10`, `EH11`, `EH12`, `EH13`, `EH14`, `EH15`, `EH16`, `EH17`, `EH18`, `EH19`, `EH20`, `EH21`, `EH22`, `EH23`, `EH24`, `EH25`, `EH26`, `EH27`, `EH28`, `EH29`, `EH30`, `EH31`, `EH32`, `EH33`, `EH34`, `EH35`, `EH36`, `EH37`, `EH38`, `EH39`, `EH40`, `EH41`, `EH42`, `EH43`, `EH44`) VALUES (29651975, 514, NULL, 103, 3030, 2364, 24, 7999, NULL, 6, 11, 2, 2809, 901, 532, 101602, 200302, 14, 10301, 94, 133, 83, 43, 15, 102, NULL, 15, 8840, 8412, 9685, 8185, 7817, 7858, 7194, 7189, 7856, 8602, 9480, 9035, 9361, 9084, 8701, 7398, 8358, 7230, 7768, 6024, 6566, 6521, 6013, 6543, 6718, 6572, 7369, 5677, 4565, 4963, 4428, 2056, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (60689149, 873, NULL, 106, 1070, 2771, 54, 3005, 512, 5, 5, 11, 3825, 953, 332, 101303, 999999, 36, 10901, 57, 113, 18, 13, 6, 121, NULL, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 51994, 52635, 55811, 49356, 48191, 47792, 48544, 45660, 50999, 52226, 49091, 45794, 45714, 44775, 48604, 43404, 43610, 45657, 47024, 44013), (64876764, NULL, NULL, 112, 2070, 2264, 84, 4006, 512, 12, 3, 14, 4836, 957, 312, 101703, 201402, 61, 10703, 78, 124, 30, 26, 9, 110, NULL, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17040, 17797, 18888, 17564), (51947063, 868, NULL, 106, 2010, 2661, 54, 3005, 512, 5, 5, 11, 3825, 953, 332, 100202, 200602, 36, 10901, 54, 113, 18, 8, 6, 121, NULL, 6, 12645, 12278, 13565, 12269, 11992, 12814, 11958, 12235, 11416, 12380, 12662, 11576, 11869, 12741, 11733, 12593, 11338, 11346, 11514, 11629, 11894, 11778, 12841, 11010, 11664, 12156, 12911, 11700, 10789, 11060, 10378, 2406, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (57086670, 505, NULL, 106, 3040, 2168, 26, 1003, 512, 5, 11, 11, 3818, 904, 151, 100203, 200601, 43, 10303, 48, 106, 9, 40, 3, 125, NULL, 3, 25681, 29474, 29381, 26784, 25676, 26872, 25524, 24546, 26504, 27488, 26339, 28499, 26092, 28610, 26388, 27371, 27139, 25932, 26774, 27015, 27533, 27702, 28269, 27332, 29022, 26264, 32744, 23479, 24057, 23571, 24594, 23380, 25804, 27257, 27072, 28324, 23806, 23636, 27696, 24078, 24501, 25808, 25832, 23074), (56807247, 512, NULL, 105, 3050, 2362, 93, 2003, 510, 2, 10, 19, 2822, 959, 523, 999999, 200502, 75, 11801, 34, 127, 76, 34, 14, 106, NULL, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15423, 18337, 16535, 14578, 15638, 15979, 14638, 16237, 16160, 15931, 16083, 14662, 13866, 15647, 14895, 13713, 14210, 15400, 14405), (65300350, 990, 11704, 111, 2010, 2769, 63, 3001, 512, 21, 6, 6, 3828, 954, 413, 999999, 201203, 36, 10602, 70, 117, 24, 46, 8, 115, NULL, 8, 21702, 20900, 22065, 20721, 20010, 18790, 21992, 18356, 18349, 22503, 19263, 22642, 21972, 21047, 20230, 22060, 22961, 20354, 23079, 21605, 23631, 25141, 23820, 25090, 23257, 26892, 30626, 25367, 25727, 23681, 24691, 23478, 24128, 24408, 23166, 23867, 21191, 21064, 21018, 22871, 20202, 20414, 21052, 19493), (89951128, 868, NULL, 106, 1020, NULL, 26, 1003, 512, 16, 14, 11, 1807, 904, 152, 100201, 200602, 50, 11102, 49, 106, 9, 5, 5, 124, NULL, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27014, 30496, 34885, 27448, 32831, 29478, 28335, 28626, 30822, 31149, 34310, 31006, 31025, 31900, 32371, 32699, 29931, 30963, 30225, 28528), (98496288, 861, NULL, 109, 3070, 2261, 61, 3006, 512, 5, 5, 11, 3830, 953, 333, 100202, 200603, 43, 11602, 43, 113, 18, 8, 6, 116, NULL, 6, 17581, 20249, 21406, 19165, 20324, 22094, 19393, 19903, 21054, 21306, 20419, 18630, 18148, 17425, 17072, 17706, 18340, 17605, 16148, 16117, 16164, 16918, 16270, 17178, 19296, 19418, 21208, 17568, 17220, 18189, 18507, 18248, 19710, 22138, 18551, 19387, 18222, 13992, 0, 0, 0, 0, 0, 0), (83376091, 990, NULL, 111, 2030, NULL, 65, 3001, 507, 18, 15, 9, 4832, 954, 412, 101201, 201303, 69, 10603, 77, 119, 28, 18, 8, 115, NULL, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16697, 20652, 19834, 21514, 18318, 18406, 20059, 20196, 18514, 19563, 23221, 18212), (87728444, 507, NULL, 110, 1040, NULL, 32, 1004, NULL, 3, 12, 13, 1813, 906, 211, 100604, 200804, 56, 10201, 25, 107, 80, NULL, 5, 123, NULL, 5, 0, 0, 0, 0, 0, 26168, 23675, 24966, 26267, 25048, 24163, 23278, 23651, 25902, 24103, 24477, 28839, 25250, 27024, 24999, 26410, 25642, 23909, 22360, 27846, 24868, 29975, 24934, 21057, 23258, 21894, 22756, 22149, 22284, 22663, 21795, 22217, 20756, 22753, 24217, 22397, 22971, 22603, 22481), (37456127, 988, NULL, 111, 2030, 2469, 64, 4002, 507, 18, 4, 9, 4831, 955, 421, 100703, 201201, 24, 11502, 74, 118, 5, 24, 8, 114, NULL, 8, 0, 0, 0, 0, 0, 23350, 23401, 20868, 25756, 24630, 23195, 20978, 23850, 22462, 24344, 24596, 22548, 21648, 25306, 19849, 22113, 22605, 20861, 19695, 26972, 23376, 30443, 22804, 23484, 23980, 27262, 23188, 25106, 24708, 23250, 23782, 23090, 22456, 26737, 24140, 25040, 24267, 26781, 22063), (91446112, 981, NULL, 111, 2020, 2762, 48, 3004, 512, 21, 4, 7, 3828, 952, 243, 100701, 201202, 24, 11901, 65, 117, 24, 24, 7, 118, NULL, 7, 80787, 83671, 89940, 75910, 72660, 80475, 69128, 71968, 72016, 81420, 78235, 77975, 84537, 84305, 78096, 79463, 77389, 73265, 76254, 73310, 75379, 85042, 79153, 80398, 85306, 83838, 92659, 70612, 68763, 68224, 76933, 68156, 70574, 77857, 67621, 75916, 64941, 66507, 73334, 76651, 69917, 73566, 83273, 69893), (23159302, 513, NULL, 103, 3030, 2364, 24, 2004, NULL, 2, 11, 2, 2809, 901, 532, 101602, 200302, 68, 10302, 94, 129, 73, 43, 15, 105, NULL, 15, 47319, 44094, 47139, 40527, 42148, 47768, 45247, 45837, 43326, 48235, 47539, 40880, 42617, 48930, 43089, 44398, 46936, 42327, 41425, 42355, 42695, 47098, 45272, 42596, 47152, 41476, 54321, 44386, 42741, 45418, 44329, 40985, 45818, 47169, 43452, 41992, 39403, 38882, 40127, 37461, 33786, 39193, 40583, 34903), (93131225, 871, 10204, 106, 1020, 2171, 25, 1004, 512, 16, 14, 15, 1807, 904, 152, 100502, 200303, 50, 11102, 20, 106, 9, 5, 5, 124, NULL, 5, 19983, 22291, 20395, 17999, 17942, 24219, 19367, 19146, 20429, 19199, 18370, 17115, 18457, 19912, 21729, 20826, 24320, 22105, 23200, 19898, 22161, 20301, 18375, 23718, 23467, 25487, 25998, 21947, 18154, 19358, 19128, 22343, 22174, 23601, 21539, 23454, 20852, 20127, 24950, 23375, 26493, 22538, 23082, 23295), (55519157, 504, NULL, 102, 1020, 2574, 21, 7999, NULL, 6, 9, 15, 1803, 902, 133, 101603, 200103, 76, 11701, 15, 134, 9, 6, 3, 127, NULL, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32260, 34062, 36749, 29023, 29666, 28236, 28985, 27186, 28817, 31556, 30406, 29719, 25840, 26122, 39739, 37706, 33575, 36130, 35809, 34338), (65557354, 866, 11405, 106, 2010, 2771, 54, 3005, 512, 5, 5, 17, 3825, 951, 342, 101303, 999999, 36, 10901, 57, 113, 18, 27, 6, 121, NULL, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15308, 16488, 19094, 15296, 14907, 14855, 15694, 15225, 15820, 18166, 15728, 16503, 14770, 14881, 16387, 15706, 14791, 15828, 15636, 14838), (76780336, 993, NULL, 105, 3060, 2269, 95, 2003, 512, 2, 8, 12, 2821, 959, 521, 100401, 200501, 75, 11603, 38, 126, 76, 32, 14, 107, NULL, 14, 42776, 42391, 43033, 41462, 35180, 42821, 37507, 35905, 42494, 40341, 43226, 38609, 39616, 43963, 43619, 46962, 47344, 46114, 45252, 39426, 49729, 48242, 43530, 43268, 51361, 55342, 59904, 51747, 44268, 46131, 50375, 39426, 60653, 50733, 50822, 44623, 48730, 46573, 47923, 0, 41436, 42108, 43919, 38537), (12028683, 988, NULL, 113, 2030, 2462, 73, 4002, 503, 18, 15, 9, 4832, 954, 412, 101201, 201303, 69, 10603, 77, 120, 5, 41, 8, 113, NULL, 8, 18423, 17609, 18305, 17913, 16269, 18898, 17656, 15118, 15951, 21189, 19030, 18748, 19042, 17209, 18090, 19471, 18969, 16103, 17881, 16202, 19474, 21001, 19003, 19427, 18767, 18132, 19634, 16155, 15134, 15958, 16221, 13581, 13227, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (88575350, 873, 11504, 108, 1070, 2772, 53, 3005, NULL, 10, 5, 7, 3824, 952, 241, 101102, 999999, 72, 12001, 55, 115, 15, 13, 7, 118, NULL, 7, 0, 16139, 17084, 16282, 0, 17564, 17719, 22167, 19814, 19358, 17635, 17068, 17354, 16211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (75791777, 865, 11609, 108, 2020, 2765, 46, 3004, 512, 21, 5, 7, 3826, 952, 242, 101102, 999999, 24, 11902, 58, 116, 24, 25, 10, 118, NULL, 10, 10551, 10305, 10194, 9649, 9071, 10869, 10189, 9955, 9411, 0, 10236, 9388, 9974, 9339, 9057, 9067, 10363, 9171, 9516, 8678, 9963, 9978, 8840, 9627, 9950, 8162, 10997, 8043, 8543, 8187, 9077, 8898, 9550, 9500, 9443, 10467, 8286, 7946, 8709, 8145, 9375, 9322, 9941, 8905); SELECT * FROM (SELECT 1 AS test, v.`BL_ID` AS `15100_BL`, COUNT(DISTINCT(IF((v.`VAL_39_8002`<>0),v.APO_ID,null))) AS `VALUE_2021_1_Q_9583_1_1` FROM test.`test_cs` AS v GROUP BY `15100_BL` ) AS numerator JOIN ( SELECT v.`BL_ID` as `15100_BL`, COUNT(DISTINCT(IF((EH39<>0),v.APO_ID,null))) AS `VALUE_2021_1_Q_9583_1_1` FROM test.apo_innodb as v GROUP BY `15100_BL` ) AS denominator USING (`15100_BL`);