UPDATE smf_metal_log_boards
SET ID_MSG = IF(logTime BETWEEN 1 AND 1101770053, 2, IF(logTime <= 1101774042, 3, IF(logTime <= 1101774676, 4, IF(logTime <= 1101776355, 5, IF(logTime <= 1101778315, 6, IF(logTime <= 1101779317, 7, IF(logTime <= 1101815426, 8, IF(logTime <= 1101815535, 9, IF(logTime <= 1101816737, 10, IF(logTime <= 1101816946, 11, IF(logTime <= 1101822282, 13, IF(logTime <= 1101822460, 14, IF(logTime <= 1101822541, 15, IF(logTime <= 1101822748, 16, IF(logTime <= 1101822903, 17, IF(logTime <= 1101828640, 18, IF(logTime <= 1101829955, 19, IF(logTime <= 1101832822, 20, IF(logTime <= 1101834288, 22, IF(logTime <= 1101834528, 23, IF(logTime <= 1101837510, 24, IF(logTime <= 1101843756, 25, IF(logTime <= 1101854419, 26, IF(logTime <= 1101854453, 27, IF(logTime <= 1101858301, 28, IF(logTime <= 1101858530, 29, IF(logTime <= 1101860948, 30, IF(logTime <= 1101862444, 31, IF(logTime <= 1101863179, 32, IF(logTime <= 1101863249, 33, IF(logTime <= 1101863306, 34, IF(logTime <= 1101863801, 35, IF(logTime <= 1101882063, 36, IF(logTime <= 1101882432, 37, IF(logTime <= 1101882665, 38, IF(logTime <= 1101882732, 39, IF(logTime <= 1101883444, 40, IF(logTime <= 1101893153, 41, IF(logTime <= 1101893384, 42, IF(logTime <= 1101893626, 43, IF(logTime <= 1101893913, 44, IF(logTime <= 1101894294, 45, IF(logTime <= 1101904826, 46, IF(logTime <= 1101905260, 47, IF(logTime <= 1101907228, 48, IF(logTime <= 1101907375, 49, IF(logTime <= 1101907478, 50, IF(logTime <= 1101907583, 51, IF(logTime <= 1101910045, 52, IF(logTime <= 1101911521, 53, IF(logTime <= 1101914658, 54, IF(logTime <= 1101915734, 55, IF(logTime <= 1101915797, 56, IF(logTime <= 1101916930, 57, IF(logTime <= 1101917103, 58, IF(logTime <= 1101917596, 59, IF(logTime <= 1101917629, 60, IF(logTime <= 1101918130, 63, IF(logTime <= 1101918238, 64, IF(logTime <= 1101918348, 66, IF(logTime <= 1101918591, 68, IF(logTime <= 1101918865, 70, IF(logTime <= 1101918915, 72, IF(logTime <= 1101919170, 73, IF(logTime <= 1101919390, 74, IF(logTime <= 1101919545, 75, IF(logTime <= 1101919589, 76, IF(logTime <= 1101919724, 77, IF(logTime <= 1101919810, 79, IF(logTime <= 1101919951, 80, IF(logTime <= 1101920290, 81, IF(logTime <= 1101920623, 82, IF(logTime <= 1101920628, 83, IF(logTime <= 1101921085, 87, IF(logTime <= 1101921171, 89, IF(logTime <= 1101921303, 90, IF(logTime <= 1101922188, 91, IF(logTime <= 1101923119, 92, IF(logTime <= 1101937936, 93, IF(logTime <= 1101939665, 94, IF(logTime <= 1101944712, 95, IF(logTime <= 1101947014, 96, IF(logTime <= 1101971441, 97, IF(logTime <= 1101972329, 98, IF(logTime <= 1101976267, 99, IF(logTime <= 1101977666, 100, IF(logTime <= 1101978310, 101, IF(logTime <= 1101980019, 102, IF(logTime <= 1101980281, 103, IF(logTime <= 1101980943, 104, IF(logTime <= 1101981298, 105, IF(logTime <= 1101981371, 106, IF(logTime <= 1101981461, 107, IF(logTime <= 1101981659, 108, IF(logTime <= 1101981764, 109, IF(logTime <= 1101981881, 110, IF(logTime <= 1101982612, 111, IF(logTime <= 1101986523, 112, IF(logTime <= 1101986807, 113, IF(logTime <= 1101987134, 114, IF(logTime <= 1101990617, 115, IF(logTime <= 1101990859, 116, IF(logTime <= 1101991914, 117, IF(logTime <= 1101993907, 118, IF(logTime <= 1101994055, 119, IF(logTime <= 1101994102, 120, IF(logTime <= 1101994176, 121, IF(logTime <= 1101994553, 122, IF(logTime <= 1101994770, 123, IF(logTime <= 1101998245, 124, IF(logTime <= 1101998508, 125, IF(logTime <= 1101998719, 126, IF(logTime <= 1101999129, 127, IF(logTime <= 1102002027, 128, IF(logTime <= 1102011220, 129, IF(logTime <= 1102018230, 130, IF(logTime <= 1102018891, 131, IF(logTime <= 1102019050, 132, IF(logTime <= 1102019268, 133, IF(logTime <= 1102019419, 134, IF(logTime <= 1102020039, 135, IF(logTime <= 1102021416, 136, IF(logTime <= 1102022645, 137, IF(logTime <= 1102023076, 138, IF(logTime <= 1102023599, 139, IF(logTime <= 1102078273, 140, IF(logTime <= 1102078361, 141, IF(logTime <= 1102079298, 142, IF(logTime <= 1102099124, 143, IF(logTime <= 1102110330, 144, IF(logTime <= 1102115678, 145, IF(logTime <= 1102117018, 146, IF(logTime <= 1102117223, 147, IF(logTime <= 1102117367, 148, IF(logTime <= 1102117455, 149, IF(logTime <= 1102137904, 150, IF(logTime <= 1102148179, 151, IF(logTime <= 1102149579, 152, IF(logTime <= 1102151271, 153, IF(logTime <= 1102157925, 154, IF(logTime <= 1102158164, 155, IF(logTime <= 1102224545, 156, IF(logTime <= 1102224656, 157, IF(logTime <= 1102224736, 158, IF(logTime <= 1102224840, 159, IF(logTime <= 1102238124, 160, IF(logTime <= 1102238202, 161, IF(logTime <= 1102238295, 162, IF(logTime <= 1102241359, 163, IF(logTime <= 1102241426, 164, IF(logTime <= 1102978816, 165, IF(logTime <= 1102978998, 166, IF(logTime <= 1102979122, 167, IF(logTime <= 1102979143, 168, IF(logTime <= 1102979699, 169, IF(logTime <= 1102979711, 170, IF(logTime <= 1102979843, 171, IF(logTime <= 1102979873, 172, IF(logTime <= 1102979962, 173, IF(logTime <= 1102980018, 174, IF(logTime <= 1102980116, 175, IF(logTime <= 1102980182, 176, IF(logTime <= 1102980323, 177, IF(logTime <= 1102980587, 178, IF(logTime <= 1102980711, 179, IF(logTime <= 1102980921, 180, IF(logTime <= 1102980999, 181, IF(logTime <= 1102981277, 182, IF(logTime <= 1102981595, 184, IF(logTime <= 1102985048, 185, IF(logTime <= 1102985154, 186, IF(logTime <= 1103015532, 187, IF(logTime <= 1103016378, 188, IF(logTime <= 1103016469, 189, IF(logTime <= 1103016654, 190, IF(logTime <= 1103017122, 191, IF(logTime <= 1103017500, 192, IF(logTime <= 1103018948, 193, IF(logTime <= 1103019618, 194, IF(logTime <= 1103020227, 195, IF(logTime <= 1103033306, 196, IF(logTime <= 1103033848, 197, IF(logTime <= 1103044775, 198, IF(logTime <= 1103047677, 199, IF(logTime <= 1103051384, 200, IF(logTime <= 1103051841, 201, IF(logTime <= 1103062171, 202, IF(logTime <= 1103101504, 203, IF(logTime <= 1103101564, 204, IF(logTime <= 1103101847, 205, IF(logTime <= 1103103406, 206, IF(logTime <= 1103111047, 207, IF(logTime <= 1103120367, 208, IF(logTime <= 1103120622, 209, IF(logTime <= 1103123086, 210, IF(logTime <= 1103124137, 211, IF(logTime <= 1103131674, 212, IF(logTime <= 1103136428, 213, IF(logTime <= 1103142826, 214, IF(logTime <= 1103142955, 215, IF(logTime <= 1103146395, 216, IF(logTime <= 1103148072, 217, IF(logTime <= 1103148801, 218, IF(logTime <= 1103149811, 219, IF(logTime <= 1103150183, 220, IF(logTime <= 1103155626, 221, IF(logTime <= 1103186540, 222, IF(logTime <= 1103187004, 223, IF(logTime <= 1103188175, 224, IF(logTime <= 1103188492, 225, IF(logTime <= 1103188597, 226, IF(logTime <= 1103189329, 227, IF(logTime <= 1103198134, 228, IF(logTime <= 1103201350, 229, IF(logTime <= 1103201419, 230, IF(logTime <= 1103203347, 231, IF(logTime <= 1103205303, 232, IF(logTime <= 1103213933, 233, IF(logTime <= 1103213979, 234, IF(logTime <= 1103214049, 235, IF(logTime <= 1103214102, 236, IF(logTime <= 1103220328, 237, IF(logTime <= 1103223856, 238, IF(logTime <= 1103225616, 239, IF(logTime <= 1103225700, 240, IF(logTime <= 1103231568, 241, IF(logTime <= 1103238144, 242, IF(logTime <= 1103268864, 243, IF(logTime <= 1103274975, 244, IF(logTime <= 1103275929, 246, IF(logTime <= 1103276009, 247, IF(logTime <= 1103276263, 248, IF(logTime <= 1103276583, 249, IF(logTime <= 1103276653, 250, IF(logTime <= 1103276751, 252, IF(logTime <= 1103276781, 253, IF(logTime <= 1103277076, 254, IF(logTime <= 1103277252, 255, IF(logTime <= 1103277294, 256, IF(logTime <= 1103277362, 257, IF(logTime <= 1103277529, 258, IF(logTime <= 1103280794, 259, IF(logTime <= 1103281163, 260, IF(logTime <= 1103281241, 261, IF(logTime <= 1103281367, 262, IF(logTime <= 1103283815, 263, IF(logTime <= 1103283988, 265, IF(logTime <= 1103284328, 266, IF(logTime <= 1103284383, 267, IF(logTime <= 1103284495, 268, IF(logTime <= 1103284544, 269, IF(logTime <= 1103284712, 271, IF(logTime <= 1103284770, 272, IF(logTime <= 1103284813, 273, IF(logTime <= 1103284864, 274, IF(logTime <= 1103284887, 275, IF(logTime <= 1103284970, 276, IF(logTime <= 1103285059, 277, IF(logTime <= 1103285637, 278, IF(logTime <= 1103293085, 280, IF(logTime <= 1103293235, 281, IF(logTime <= 1103294086, 282, IF(logTime <= 1103297649, 283, IF(logTime <= 1103297780, 284, IF(logTime <= 1103298177, 285, IF(logTime <= 1103308756, 286, IF(logTime <= 1103309984, 287, IF(logTime <= 1103310203, 288, IF(logTime <= 1103310291, 289, IF(logTime <= 1103316138, 290, IF(logTime <= 1103331648, 291, IF(logTime <= 1103360732, 292, IF(logTime <= 1103369642, 293, IF(logTime <= 1103369728, 294, IF(logTime <= 1103371457, 295, IF(logTime <= 1103378038, 296, IF(logTime <= 1103378285, 297, IF(logTime <= 1103378467, 298, IF(logTime <= 1103380819, 300, IF(logTime <= 1103380975, 301, IF(logTime <= 1103381335, 303, IF(logTime <= 1103381871, 305, IF(logTime <= 1103381967, 306, IF(logTime <= 1103403348, 307, IF(logTime <= 1103406749, 308, IF(logTime <= 1103407831, 309, IF(logTime <= 1103408507, 310, IF(logTime <= 1103422628, 311, IF(logTime <= 1103422790, 312, IF(logTime <= 1103445722, 313, IF(logTime <= 1103457798, 314, IF(logTime <= 1103458239, 315, IF(logTime <= 1103459847, 316, IF(logTime <= 1103463882, 317, IF(logTime <= 1103468803, 318, IF(logTime <= 1103468891, 319, IF(logTime <= 1103468920, 320, IF(logTime <= 1103469226, 321, IF(logTime <= 1103478847, 322, IF(logTime <= 1103492785, 323, IF(logTime <= 1103493867, 324, IF(logTime <= 1103494246, 325, IF(logTime <= 1103494620, 326, IF(logTime <= 1103495143, 327, IF(logTime <= 1103495852, 328, IF(logTime <= 1103496649, 329, IF(logTime <= 1103505367, 330, IF(logTime <= 1103505935, 331, IF(logTime <= 1103543919, 332, IF(logTime <= 1103546770, 333, IF(logTime <= 1103550929, 334, IF(logTime <= 1103551149, 335, IF(logTime <= 1103551244, 336, IF(logTime <= 1103551806, 337, IF(logTime <= 1103552055, 338, IF(logTime <= 1103552552, 339, IF(logTime <= 1103555094, 340, IF(logTime <= 1103555621, 341, IF(logTime <= 1103555968, 342, IF(logTime <= 1103562709, 343, IF(logTime <= 1103564966, 344, IF(logTime <= 1103576095, 345, IF(logTime <= 1103616962, 346, IF(logTime <= 1103617325, 347, IF(logTime <= 1103617696, 348, IF(logTime <= 1103629516, 349, IF(logTime <= 1103629859, 350, IF(logTime <= 1103629929, 351, IF(logTime <= 1103630323, 352, IF(logTime <= 1103630640, 353, IF(logTime <= 1103631653, 354, IF(logTime <= 1103634760, 355, IF(logTime <= 1103637155, 356, IF(logTime <= 1103640503, 357, IF(logTime <= 1103641521, 358, IF(logTime <= 1103646506, 359, IF(logTime <= 1103657611, 360, IF(logTime <= 1103661178, 361, IF(logTime <= 1103661829, 362, IF(logTime <= 1103664278, 363, IF(logTime <= 1103705175, 364, IF(logTime <= 1103705699, 365, IF(logTime <= 1103727023, 366, IF(logTime <= 1103732985, 367, IF(logTime <= 1103737367, 368, IF(logTime <= 1103738936, 369, IF(logTime <= 1103741777, 370, IF(logTime <= 1103742668, 371, IF(logTime <= 1103743278, 372, IF(logTime <= 1103743324, 373, IF(logTime <= 1103743441, 374, IF(logTime <= 1103746789, 375, IF(logTime <= 1103748295, 376, IF(logTime <= 1103749345, 377, IF(logTime <= 1103749493, 379, IF(logTime <= 1103751134, 380, IF(logTime <= 1103756317, 381, IF(logTime <= 1103756833, 382, IF(logTime <= 1103756964, 383, IF(logTime <= 1103757169, 384, IF(logTime <= 1103757503, 385, IF(logTime <= 1103757616, 386, IF(logTime <= 1103757873, 387, IF(logTime <= 1103758697, 388, IF(logTime <= 1103759607, 389, IF(logTime <= 1103759886, 390, IF(logTime <= 1103768150, 391, IF(logTime <= 1103768404, 392, IF(logTime <= 1103786114, 393, IF(logTime <= 1103786453, 394, IF(logTime <= 1103786815, 395, IF(logTime <= 1103787196, 396, IF(logTime <= 1103787554, 397, IF(logTime <= 1103787806, 398, IF(logTime <= 1103790960, 399, IF(logTime <= 1103791094, 400, IF(logTime <= 1103791548, 401, IF(logTime <= 1103791858, 402, IF(logTime <= 1103795133, 403, IF(logTime <= 1103795301, 404, IF(logTime <= 1103796193, 405, IF(logTime <= 1103796386, 406, IF(logTime <= 1103796523, 407, IF(logTime <= 1103798696, 408, IF(logTime <= 1103798766, 409, IF(logTime <= 1103798977, 410, IF(logTime <= 1103805672, 411, IF(logTime <= 1103820252, 412, IF(logTime <= 1103820376, 413, IF(logTime <= 1103820445, 414, IF(logTime <= 1103820764, 415, IF(logTime <= 1103820798, 416, IF(logTime <= 1103836352, 417, IF(logTime <= 1103837645, 418, IF(logTime <= 1103840017, 419, IF(logTime <= 1103840555, 420, IF(logTime <= 1103840611, 421, IF(logTime <= 1103840926, 422, IF(logTime <= 1103876415, 423, IF(logTime <= 1103876604, 424, IF(logTime <= 1103879890, 425, IF(logTime <= 1103879969, 426, IF(logTime <= 1103881780, 427, IF(logTime <= 1103888526, 428, IF(logTime <= 1103889393, 429, IF(logTime <= 1103889546, 430, IF(logTime <= 1103890201, 431, IF(logTime <= 1103895807, 432, IF(logTime <= 1103896018, 433, IF(logTime <= 1103903545, 434, IF(logTime <= 1103903960, 435, IF(logTime <= 1103904993, 436, IF(logTime <= 1103905312, 437, IF(logTime <= 1103905463, 438, IF(logTime <= 1103909166, 439, IF(logTime <= 1103909417, 440, IF(logTime <= 1103909578, 441, IF(logTime <= 1103919089, 442, IF(logTime <= 1103934256, 443, IF(logTime <= 1103934813, 444, IF(logTime <= 1103964544, 445, IF(logTime <= 1103968446, 446, IF(logTime <= 1103968566, 447, IF(logTime <= 1103969166, 448, IF(logTime <= 1103969448, 449, IF(logTime <= 1103969568, 450, IF(logTime <= 1103969683, 451, IF(logTime <= 1103970905, 452, IF(logTime <= 1103971809, 453, IF(logTime <= 1103979232, 454, IF(logTime <= 1103979434, 455, IF(logTime <= 1103979560, 456, IF(logTime <= 1103980829, 457, IF(logTime <= 1103981520, 458, IF(logTime <= 1103984104, 459, IF(logTime <= 1103984730, 460, IF(logTime <= 1103988653, 461, IF(logTime <= 1103988778, 462, IF(logTime <= 1103995330, 463, IF(logTime <= 1104001509, 464, IF(logTime <= 1104001948, 465, IF(logTime <= 1104003471, 466, IF(logTime <= 1104013435, 467, IF(logTime <= 1104013634, 468, IF(logTime <= 1104013852, 469, IF(logTime <= 1104026012, 470, IF(logTime <= 1104026123, 471, IF(logTime <= 1104046902, 472, IF(logTime <= 1104047109, 473, IF(logTime <= 1104047351, 474, IF(logTime <= 1104051381, 475, IF(logTime <= 1104051512, 476, IF(logTime <= 1104053821, 477, IF(logTime <= 1104054302, 478, IF(logTime <= 1104054372, 479, IF(logTime <= 1104055186, 480, IF(logTime <= 1104056794, 481, IF(logTime <= 1104059939, 482, IF(logTime <= 1104063262, 483, IF(logTime <= 1104064211, 484, IF(logTime <= 1104064280, 485, IF(logTime <= 1104069703, 486, IF(logTime <= 1104069903, 487, IF(logTime <= 1104072005, 488, IF(logTime <= 1104072244, 489, IF(logTime <= 1104076291, 490, IF(logTime <= 1104079372, 491, IF(logTime <= 1104081710, 492, IF(logTime <= 1104082302, 493, IF(logTime <= 1104086538, 494, IF(logTime <= 1104087265, 495, IF(logTime <= 1104089922, 496, IF(logTime <= 1104090873, 497, IF(logTime <= 1104091096, 498, IF(logTime <= 1104091418, 499, IF(logTime <= 1104091538, 500, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
WHERE logTime BETWEEN 1 AND 1104091539
AND ID_MSG = 0;