text: drop table if exists online_test_prob_union_1;
  create table online_test_prob_union_1 as
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1006
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1010
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1021
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1043
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1052
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1057
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1071
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1080
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1081
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1082
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1085
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1089
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1106
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1111
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1115
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1128
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1129
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1161
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1164
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1175
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1176
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1263
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1291
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1293
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1309
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1320
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1366
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1375
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1377
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1381
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1389
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1402
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1409
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1413
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1435
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1442
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1451
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1485
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1553
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1585
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1621
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1657
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1701
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1755
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1789
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1790
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1791
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1807
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1893
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1905
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1906
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1910
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1913
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1919
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1920
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1928
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1936
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1943
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1950
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1960
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1962
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1968
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1990
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1993
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_1997
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2005
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2009
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2011
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2021
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2030
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2058
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2060
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2087
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2092
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2093
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2097
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2108
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2123
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2156
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2177
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2182
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2218
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2224
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2230
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2257
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2267
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2270
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2299
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2307
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2324
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2333
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2334
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2361
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2369
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2395
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2404
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2413
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2414
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2415
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2419
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2431
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2450
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2467
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2476
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2514
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2539
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2571
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2578
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2715
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2864
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2878
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2892
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_2907;
  
  drop table if exists online_test_prob_union_2;
  create table online_test_prob_union_2 as
  select row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3001
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3005
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3010
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3019
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3027
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3031
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3034
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3054
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3092
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3112
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3117
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3120
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3143
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3197
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3219
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3231
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3232
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3268
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3281
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3313
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3319
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3329
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3414
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3425
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3434
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3442
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3445
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3449
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3467
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3501
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3511
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3517
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3520
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3528
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3532
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3534
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3540
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3591
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3596
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3601
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3605
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3610
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3620
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3627
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3679
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3690
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3695
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3702
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3709
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3730
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3732
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3739
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3753
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3795
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3804
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3822
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3832
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3839
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3847
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3869
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3871
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3882
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3897
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3899
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3916
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3936
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_3938
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4005
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4011
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4033
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4036
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4049
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4058
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4064
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4066
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4068
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4079
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4094
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4098
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4099
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4112
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4121
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4132
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4139
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4157
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4160
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4162
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4168
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4173
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4178
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4181
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4187
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4199
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4205
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4206
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4211
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4216
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4221
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4224
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4227
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4244
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4253
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4269
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4312
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4341
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4347
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4357
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4358
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4372
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4380
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4384
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4406
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4422
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4423
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4434
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4459
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4466
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4505
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4509
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4515
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4524
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4525
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4543
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4548
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4572
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4585
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4599
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4634
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4637
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4664
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4680
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4695
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4711
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4759
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4801
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4818
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4834
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4853
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4889
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4923
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4983
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_4998;
  
  drop table if exists online_test_prob_union_3;
  create table online_test_prob_union_3 as
  select row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5014
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5019
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5024
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5076
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5081
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5085
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5154
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5182
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5192
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5200
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5214
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5258
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5291
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5296
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5311
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5319
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5323
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5325
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5326
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5331
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5337
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5343
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5349
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5352
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5363
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5364
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5369
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5374
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5382
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5413
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5424
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5435
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5443
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5446
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5450
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5452
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5471
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5473
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5481
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5487
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5503
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5516
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5519
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5527
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5529
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5542
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5570
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5583
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5586
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5600
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5609
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5641
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5654
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5661
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5677
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5751
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5752
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5767
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5772
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5778
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5783
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5785
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5810
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5812
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5813
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5825
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5833
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5845
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5847
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5892
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5946
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_5958;
  
  drop table if exists online_test_prob_union_4;
  create table online_test_prob_union_4 as
  select row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6065
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_613
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_614
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6141
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_615
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_616
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6167
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_617
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_618
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_619
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_621
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_622
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_623
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_625
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_626
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_627
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_628
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_629
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6337
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6390
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_640
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6428
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6429
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_648
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6480
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_651
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6511
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6516
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6526
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6527
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6538
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6580
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6587
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6590
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6596
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6630
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6638
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6703
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6714
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_672
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6720
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6803
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_689
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_690
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_6923
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_699
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7039
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7168
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7199
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7225
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7255
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7256
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7283
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7304
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7323
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7329
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7346
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7374
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7375
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7383
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7410;
  
  drop table if exists online_test_prob_union_5;
  create table online_test_prob_union_5 as
  select row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7501
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7516
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7520
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7523
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7544
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_755
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_760
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7601
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7616
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7671
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_768
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7697
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7701
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7724
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7746
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7778
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7781
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7791
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7792
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7796
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7800
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7811
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7821
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7832
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7833
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_786
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7867
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7868
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7870
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7899
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7939
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7942
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7953
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7954
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_796
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7973
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7976
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7994
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7997
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_7998
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_800
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8015
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_802
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8041
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8052
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8063
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8093
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8157
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8188
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8200
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8215
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_822
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8222
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8251
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_826
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8275
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_828
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8282
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8285
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8327
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8344
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8414
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8429
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8430
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8452
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8494
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8550
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8563
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_867
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8671
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8688
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8835
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8853
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8893
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8907
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8908
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8910
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8960
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8974
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8980
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_8991
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_9007
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_9047
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_9051
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_9054
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_9068
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_909
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_911
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_912
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_919
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_927
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_954
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_957
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_966
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_968
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_976
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_979
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_988
  union all
  select  row_id,mall_id,prediction_result,prediction_detail from online_test_prob_m_989;
  
  drop table if exists online_test_prob_union_all;
  create table online_test_prob_union_all as 
  	select * from online_test_prob_union_1
  	union all
  	select * from online_test_prob_union_2
  	union all
  	select * from online_test_prob_union_3
  	union all
  	select * from online_test_prob_union_4
  	union all
  	select * from online_test_prob_union_5;