JEC & Birthright Israel NEXT NY

The following queries were executed

event module

Update #3

• RENAME TABLE {event} TO {event_backup}
• CREATE TABLE {event_timezones} ( timezone int NOT NULL default '0', name varchar(255) NOT NULL default '', offset TIME NOT NULL default '0', offset_dst TIME NOT NULL default '0', dst_region int NOT NULL default '0', PRIMARY KEY (timezone) ) /*!40100 DEFAULT CHARACTER SET utf8 */;
• CREATE TABLE {event} ( nid int(10) unsigned NOT NULL default '0', event_start datetime NOT NULL, event_end datetime NOT NULL, timezone int NOT NULL default '0', start_in_dst int NOT NULL default '0', end_in_dst int NOT NULL default '0' ) /*!40100 DEFAULT CHARACTER SET utf8 */;
• SET time_zone = '+00:00'
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND AS event_start, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND AS event_end, e.timezone, 0, 0 FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 0
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((9763200 <= e.event_start <= 22982400) OR (41817600 <= e.event_start <= 55036800) OR (73267200 <= e.event_start <= 86486400) OR (104716800 <= e.event_start <= 117936000) OR (136166400 <= e.event_start <= 149385600) OR (167616000 <= e.event_start <= 180835200) OR (199670400 <= e.event_start <= 212889600) OR (231120000 <= e.event_start <= 244339200) OR (262569600 <= e.event_start <= 275788800) OR (294019200 <= e.event_start <= 307238400) OR (325468800 <= e.event_start <= 338688000) OR (356918400 <= e.event_start <= 370137600) OR (388972800 <= e.event_start <= 402192000) OR (420422400 <= e.event_start <= 433641600) OR (451872000 <= e.event_start <= 465091200) OR (483321600 <= e.event_start <= 496540800) OR (514771200 <= e.event_start <= 527990400) OR (546220800 <= e.event_start <= 559440000) OR (578275200 <= e.event_start <= 591494400) OR (609724800 <= e.event_start <= 622944000) OR (641174400 <= e.event_start <= 654393600) OR (672624000 <= e.event_start <= 685843200) OR (704073600 <= e.event_start <= 717292800) OR (736128000 <= e.event_start <= 749347200) OR (767577600 <= e.event_start <= 780796800) OR (799027200 <= e.event_start <= 812246400) OR (830476800 <= e.event_start <= 843696000) OR (861926400 <= e.event_start <= 875145600) OR (893376000 <= e.event_start <= 906595200) OR (925430400 <= e.event_start <= 938649600) OR (956880000 <= e.event_start <= 970099200) OR (988329600 <= e.event_start <= 1001548800) OR (1019779200 <= e.event_start <= 1032998400) OR (1051228800 <= e.event_start <= 1064448000) OR (1083283200 <= e.event_start <= 1096502400) OR (1114732800 <= e.event_start <= 1127952000) OR (1146182400 <= e.event_start <= 1159401600) OR (1177632000 <= e.event_start <= 1190851200) OR (1209081600 <= e.event_start <= 1222300800) OR (1240531200 <= e.event_start <= 1253750400) OR (1272585600 <= e.event_start <= 1285804800), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((9763200 <= e.event_end <= 22982400) OR (41817600 <= e.event_end <= 55036800) OR (73267200 <= e.event_end <= 86486400) OR (104716800 <= e.event_end <= 117936000) OR (136166400 <= e.event_end <= 149385600) OR (167616000 <= e.event_end <= 180835200) OR (199670400 <= e.event_end <= 212889600) OR (231120000 <= e.event_end <= 244339200) OR (262569600 <= e.event_end <= 275788800) OR (294019200 <= e.event_end <= 307238400) OR (325468800 <= e.event_end <= 338688000) OR (356918400 <= e.event_end <= 370137600) OR (388972800 <= e.event_end <= 402192000) OR (420422400 <= e.event_end <= 433641600) OR (451872000 <= e.event_end <= 465091200) OR (483321600 <= e.event_end <= 496540800) OR (514771200 <= e.event_end <= 527990400) OR (546220800 <= e.event_end <= 559440000) OR (578275200 <= e.event_end <= 591494400) OR (609724800 <= e.event_end <= 622944000) OR (641174400 <= e.event_end <= 654393600) OR (672624000 <= e.event_end <= 685843200) OR (704073600 <= e.event_end <= 717292800) OR (736128000 <= e.event_end <= 749347200) OR (767577600 <= e.event_end <= 780796800) OR (799027200 <= e.event_end <= 812246400) OR (830476800 <= e.event_end <= 843696000) OR (861926400 <= e.event_end <= 875145600) OR (893376000 <= e.event_end <= 906595200) OR (925430400 <= e.event_end <= 938649600) OR (956880000 <= e.event_end <= 970099200) OR (988329600 <= e.event_end <= 1001548800) OR (1019779200 <= e.event_end <= 1032998400) OR (1051228800 <= e.event_end <= 1064448000) OR (1083283200 <= e.event_end <= 1096502400) OR (1114732800 <= e.event_end <= 1127952000) OR (1146182400 <= e.event_end <= 1159401600) OR (1177632000 <= e.event_end <= 1190851200) OR (1209081600 <= e.event_end <= 1222300800) OR (1240531200 <= e.event_end <= 1253750400) OR (1272585600 <= e.event_end <= 1285804800), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((9763200 <= e.event_start <= 22982400) OR (41817600 <= e.event_start <= 55036800) OR (73267200 <= e.event_start <= 86486400) OR (104716800 <= e.event_start <= 117936000) OR (136166400 <= e.event_start <= 149385600) OR (167616000 <= e.event_start <= 180835200) OR (199670400 <= e.event_start <= 212889600) OR (231120000 <= e.event_start <= 244339200) OR (262569600 <= e.event_start <= 275788800) OR (294019200 <= e.event_start <= 307238400) OR (325468800 <= e.event_start <= 338688000) OR (356918400 <= e.event_start <= 370137600) OR (388972800 <= e.event_start <= 402192000) OR (420422400 <= e.event_start <= 433641600) OR (451872000 <= e.event_start <= 465091200) OR (483321600 <= e.event_start <= 496540800) OR (514771200 <= e.event_start <= 527990400) OR (546220800 <= e.event_start <= 559440000) OR (578275200 <= e.event_start <= 591494400) OR (609724800 <= e.event_start <= 622944000) OR (641174400 <= e.event_start <= 654393600) OR (672624000 <= e.event_start <= 685843200) OR (704073600 <= e.event_start <= 717292800) OR (736128000 <= e.event_start <= 749347200) OR (767577600 <= e.event_start <= 780796800) OR (799027200 <= e.event_start <= 812246400) OR (830476800 <= e.event_start <= 843696000) OR (861926400 <= e.event_start <= 875145600) OR (893376000 <= e.event_start <= 906595200) OR (925430400 <= e.event_start <= 938649600) OR (956880000 <= e.event_start <= 970099200) OR (988329600 <= e.event_start <= 1001548800) OR (1019779200 <= e.event_start <= 1032998400) OR (1051228800 <= e.event_start <= 1064448000) OR (1083283200 <= e.event_start <= 1096502400) OR (1114732800 <= e.event_start <= 1127952000) OR (1146182400 <= e.event_start <= 1159401600) OR (1177632000 <= e.event_start <= 1190851200) OR (1209081600 <= e.event_start <= 1222300800) OR (1240531200 <= e.event_start <= 1253750400) OR (1272585600 <= e.event_start <= 1285804800), 1, 0), IF((9763200 <= e.event_end <= 22982400) OR (41817600 <= e.event_end <= 55036800) OR (73267200 <= e.event_end <= 86486400) OR (104716800 <= e.event_end <= 117936000) OR (136166400 <= e.event_end <= 149385600) OR (167616000 <= e.event_end <= 180835200) OR (199670400 <= e.event_end <= 212889600) OR (231120000 <= e.event_end <= 244339200) OR (262569600 <= e.event_end <= 275788800) OR (294019200 <= e.event_end <= 307238400) OR (325468800 <= e.event_end <= 338688000) OR (356918400 <= e.event_end <= 370137600) OR (388972800 <= e.event_end <= 402192000) OR (420422400 <= e.event_end <= 433641600) OR (451872000 <= e.event_end <= 465091200) OR (483321600 <= e.event_end <= 496540800) OR (514771200 <= e.event_end <= 527990400) OR (546220800 <= e.event_end <= 559440000) OR (578275200 <= e.event_end <= 591494400) OR (609724800 <= e.event_end <= 622944000) OR (641174400 <= e.event_end <= 654393600) OR (672624000 <= e.event_end <= 685843200) OR (704073600 <= e.event_end <= 717292800) OR (736128000 <= e.event_end <= 749347200) OR (767577600 <= e.event_end <= 780796800) OR (799027200 <= e.event_end <= 812246400) OR (830476800 <= e.event_end <= 843696000) OR (861926400 <= e.event_end <= 875145600) OR (893376000 <= e.event_end <= 906595200) OR (925430400 <= e.event_end <= 938649600) OR (956880000 <= e.event_end <= 970099200) OR (988329600 <= e.event_end <= 1001548800) OR (1019779200 <= e.event_end <= 1032998400) OR (1051228800 <= e.event_end <= 1064448000) OR (1083283200 <= e.event_end <= 1096502400) OR (1114732800 <= e.event_end <= 1127952000) OR (1146182400 <= e.event_end <= 1159401600) OR (1177632000 <= e.event_end <= 1190851200) OR (1209081600 <= e.event_end <= 1222300800) OR (1240531200 <= e.event_end <= 1253750400) OR (1272585600 <= e.event_end <= 1285804800), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 1
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 135129600) OR (179884800 <= e.event_start <= 166579200) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 324432000) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 482284800) OR (527040000 <= e.event_start <= 513734400) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 671587200) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 829440000) OR (874195200 <= e.event_start <= 860889600) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018742400) OR (1063497600 <= e.event_start <= 1050192000) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1208044800) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 135129600) OR (179884800 <= e.event_end <= 166579200) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 324432000) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 482284800) OR (527040000 <= e.event_end <= 513734400) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 671587200) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 829440000) OR (874195200 <= e.event_end <= 860889600) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018742400) OR (1063497600 <= e.event_end <= 1050192000) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1208044800) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 135129600) OR (179884800 <= e.event_start <= 166579200) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 324432000) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 482284800) OR (527040000 <= e.event_start <= 513734400) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 671587200) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 829440000) OR (874195200 <= e.event_start <= 860889600) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018742400) OR (1063497600 <= e.event_start <= 1050192000) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1208044800) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), 1, 0), IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 135129600) OR (179884800 <= e.event_end <= 166579200) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 324432000) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 482284800) OR (527040000 <= e.event_end <= 513734400) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 671587200) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 829440000) OR (874195200 <= e.event_end <= 860889600) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018742400) OR (1063497600 <= e.event_end <= 1050192000) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1208044800) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 2
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7516800 <= e.event_start <= 25660800) OR (38966400 <= e.event_start <= 57715200) OR (70416000 <= e.event_start <= 89164800) OR (101865600 <= e.event_start <= 120614400) OR (133920000 <= e.event_start <= 152064000) OR (165369600 <= e.event_start <= 183513600) OR (196819200 <= e.event_start <= 215568000) OR (228268800 <= e.event_start <= 247017600) OR (259718400 <= e.event_start <= 278467200) OR (291168000 <= e.event_start <= 309916800) OR (323222400 <= e.event_start <= 341366400) OR (354672000 <= e.event_start <= 372816000) OR (386121600 <= e.event_start <= 404870400) OR (417571200 <= e.event_start <= 436320000) OR (449020800 <= e.event_start <= 467769600) OR (481075200 <= e.event_start <= 499219200) OR (512524800 <= e.event_start <= 530668800) OR (543974400 <= e.event_start <= 562118400) OR (575424000 <= e.event_start <= 594172800) OR (606873600 <= e.event_start <= 625622400) OR (638323200 <= e.event_start <= 657072000) OR (670377600 <= e.event_start <= 688521600) OR (701827200 <= e.event_start <= 719971200) OR (733276800 <= e.event_start <= 752025600) OR (764726400 <= e.event_start <= 783475200) OR (796176000 <= e.event_start <= 814924800) OR (828230400 <= e.event_start <= 846374400) OR (859680000 <= e.event_start <= 877824000) OR (891129600 <= e.event_start <= 909273600) OR (922579200 <= e.event_start <= 941328000) OR (954028800 <= e.event_start <= 972777600) OR (985478400 <= e.event_start <= 1004227200) OR (1017532800 <= e.event_start <= 1035676800) OR (1048982400 <= e.event_start <= 1067126400) OR (1080432000 <= e.event_start <= 1099180800) OR (1111881600 <= e.event_start <= 1130630400) OR (1143331200 <= e.event_start <= 1162080000) OR (1174780800 <= e.event_start <= 1193529600) OR (1206835200 <= e.event_start <= 1224979200) OR (1238284800 <= e.event_start <= 1256428800) OR (1269734400 <= e.event_start <= 1288483200), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7516800 <= e.event_end <= 25660800) OR (38966400 <= e.event_end <= 57715200) OR (70416000 <= e.event_end <= 89164800) OR (101865600 <= e.event_end <= 120614400) OR (133920000 <= e.event_end <= 152064000) OR (165369600 <= e.event_end <= 183513600) OR (196819200 <= e.event_end <= 215568000) OR (228268800 <= e.event_end <= 247017600) OR (259718400 <= e.event_end <= 278467200) OR (291168000 <= e.event_end <= 309916800) OR (323222400 <= e.event_end <= 341366400) OR (354672000 <= e.event_end <= 372816000) OR (386121600 <= e.event_end <= 404870400) OR (417571200 <= e.event_end <= 436320000) OR (449020800 <= e.event_end <= 467769600) OR (481075200 <= e.event_end <= 499219200) OR (512524800 <= e.event_end <= 530668800) OR (543974400 <= e.event_end <= 562118400) OR (575424000 <= e.event_end <= 594172800) OR (606873600 <= e.event_end <= 625622400) OR (638323200 <= e.event_end <= 657072000) OR (670377600 <= e.event_end <= 688521600) OR (701827200 <= e.event_end <= 719971200) OR (733276800 <= e.event_end <= 752025600) OR (764726400 <= e.event_end <= 783475200) OR (796176000 <= e.event_end <= 814924800) OR (828230400 <= e.event_end <= 846374400) OR (859680000 <= e.event_end <= 877824000) OR (891129600 <= e.event_end <= 909273600) OR (922579200 <= e.event_end <= 941328000) OR (954028800 <= e.event_end <= 972777600) OR (985478400 <= e.event_end <= 1004227200) OR (1017532800 <= e.event_end <= 1035676800) OR (1048982400 <= e.event_end <= 1067126400) OR (1080432000 <= e.event_end <= 1099180800) OR (1111881600 <= e.event_end <= 1130630400) OR (1143331200 <= e.event_end <= 1162080000) OR (1174780800 <= e.event_end <= 1193529600) OR (1206835200 <= e.event_end <= 1224979200) OR (1238284800 <= e.event_end <= 1256428800) OR (1269734400 <= e.event_end <= 1288483200), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7516800 <= e.event_start <= 25660800) OR (38966400 <= e.event_start <= 57715200) OR (70416000 <= e.event_start <= 89164800) OR (101865600 <= e.event_start <= 120614400) OR (133920000 <= e.event_start <= 152064000) OR (165369600 <= e.event_start <= 183513600) OR (196819200 <= e.event_start <= 215568000) OR (228268800 <= e.event_start <= 247017600) OR (259718400 <= e.event_start <= 278467200) OR (291168000 <= e.event_start <= 309916800) OR (323222400 <= e.event_start <= 341366400) OR (354672000 <= e.event_start <= 372816000) OR (386121600 <= e.event_start <= 404870400) OR (417571200 <= e.event_start <= 436320000) OR (449020800 <= e.event_start <= 467769600) OR (481075200 <= e.event_start <= 499219200) OR (512524800 <= e.event_start <= 530668800) OR (543974400 <= e.event_start <= 562118400) OR (575424000 <= e.event_start <= 594172800) OR (606873600 <= e.event_start <= 625622400) OR (638323200 <= e.event_start <= 657072000) OR (670377600 <= e.event_start <= 688521600) OR (701827200 <= e.event_start <= 719971200) OR (733276800 <= e.event_start <= 752025600) OR (764726400 <= e.event_start <= 783475200) OR (796176000 <= e.event_start <= 814924800) OR (828230400 <= e.event_start <= 846374400) OR (859680000 <= e.event_start <= 877824000) OR (891129600 <= e.event_start <= 909273600) OR (922579200 <= e.event_start <= 941328000) OR (954028800 <= e.event_start <= 972777600) OR (985478400 <= e.event_start <= 1004227200) OR (1017532800 <= e.event_start <= 1035676800) OR (1048982400 <= e.event_start <= 1067126400) OR (1080432000 <= e.event_start <= 1099180800) OR (1111881600 <= e.event_start <= 1130630400) OR (1143331200 <= e.event_start <= 1162080000) OR (1174780800 <= e.event_start <= 1193529600) OR (1206835200 <= e.event_start <= 1224979200) OR (1238284800 <= e.event_start <= 1256428800) OR (1269734400 <= e.event_start <= 1288483200), 1, 0), IF((7516800 <= e.event_end <= 25660800) OR (38966400 <= e.event_end <= 57715200) OR (70416000 <= e.event_end <= 89164800) OR (101865600 <= e.event_end <= 120614400) OR (133920000 <= e.event_end <= 152064000) OR (165369600 <= e.event_end <= 183513600) OR (196819200 <= e.event_end <= 215568000) OR (228268800 <= e.event_end <= 247017600) OR (259718400 <= e.event_end <= 278467200) OR (291168000 <= e.event_end <= 309916800) OR (323222400 <= e.event_end <= 341366400) OR (354672000 <= e.event_end <= 372816000) OR (386121600 <= e.event_end <= 404870400) OR (417571200 <= e.event_end <= 436320000) OR (449020800 <= e.event_end <= 467769600) OR (481075200 <= e.event_end <= 499219200) OR (512524800 <= e.event_end <= 530668800) OR (543974400 <= e.event_end <= 562118400) OR (575424000 <= e.event_end <= 594172800) OR (606873600 <= e.event_end <= 625622400) OR (638323200 <= e.event_end <= 657072000) OR (670377600 <= e.event_end <= 688521600) OR (701827200 <= e.event_end <= 719971200) OR (733276800 <= e.event_end <= 752025600) OR (764726400 <= e.event_end <= 783475200) OR (796176000 <= e.event_end <= 814924800) OR (828230400 <= e.event_end <= 846374400) OR (859680000 <= e.event_end <= 877824000) OR (891129600 <= e.event_end <= 909273600) OR (922579200 <= e.event_end <= 941328000) OR (954028800 <= e.event_end <= 972777600) OR (985478400 <= e.event_end <= 1004227200) OR (1017532800 <= e.event_end <= 1035676800) OR (1048982400 <= e.event_end <= 1067126400) OR (1080432000 <= e.event_end <= 1099180800) OR (1111881600 <= e.event_end <= 1130630400) OR (1143331200 <= e.event_end <= 1162080000) OR (1174780800 <= e.event_end <= 1193529600) OR (1206835200 <= e.event_end <= 1224979200) OR (1238284800 <= e.event_end <= 1256428800) OR (1269734400 <= e.event_end <= 1288483200), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 3
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7776000 <= e.event_start <= 23587200) OR (39312000 <= e.event_start <= 55123200) OR (70934400 <= e.event_start <= 86745600) OR (102470400 <= e.event_start <= 118281600) OR (134006400 <= e.event_start <= 149817600) OR (165542400 <= e.event_start <= 181353600) OR (197164800 <= e.event_start <= 212976000) OR (228700800 <= e.event_start <= 244512000) OR (260236800 <= e.event_start <= 276048000) OR (291772800 <= e.event_start <= 307584000) OR (323395200 <= e.event_start <= 339206400) OR (354931200 <= e.event_start <= 370742400) OR (386467200 <= e.event_start <= 402278400) OR (418003200 <= e.event_start <= 433814400) OR (449625600 <= e.event_start <= 465436800) OR (481161600 <= e.event_start <= 496972800) OR (512697600 <= e.event_start <= 528508800) OR (544233600 <= e.event_start <= 560044800) OR (575856000 <= e.event_start <= 591667200) OR (607392000 <= e.event_start <= 623203200) OR (638928000 <= e.event_start <= 654739200) OR (670464000 <= e.event_start <= 686275200) OR (702086400 <= e.event_start <= 717897600) OR (733622400 <= e.event_start <= 749433600) OR (765158400 <= e.event_start <= 780969600) OR (796694400 <= e.event_start <= 812505600) OR (828316800 <= e.event_start <= 844128000) OR (859852800 <= e.event_start <= 875664000) OR (891388800 <= e.event_start <= 907200000) OR (922924800 <= e.event_start <= 938736000) OR (954547200 <= e.event_start <= 970358400) OR (986083200 <= e.event_start <= 1001894400) OR (1017619200 <= e.event_start <= 1033430400) OR (1049155200 <= e.event_start <= 1064966400) OR (1080777600 <= e.event_start <= 1096588800) OR (1112313600 <= e.event_start <= 1128124800) OR (1143849600 <= e.event_start <= 1159660800) OR (1175385600 <= e.event_start <= 1191196800) OR (1207008000 <= e.event_start <= 1222819200) OR (1238544000 <= e.event_start <= 1254355200) OR (1270080000 <= e.event_start <= 1285891200), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7776000 <= e.event_end <= 23587200) OR (39312000 <= e.event_end <= 55123200) OR (70934400 <= e.event_end <= 86745600) OR (102470400 <= e.event_end <= 118281600) OR (134006400 <= e.event_end <= 149817600) OR (165542400 <= e.event_end <= 181353600) OR (197164800 <= e.event_end <= 212976000) OR (228700800 <= e.event_end <= 244512000) OR (260236800 <= e.event_end <= 276048000) OR (291772800 <= e.event_end <= 307584000) OR (323395200 <= e.event_end <= 339206400) OR (354931200 <= e.event_end <= 370742400) OR (386467200 <= e.event_end <= 402278400) OR (418003200 <= e.event_end <= 433814400) OR (449625600 <= e.event_end <= 465436800) OR (481161600 <= e.event_end <= 496972800) OR (512697600 <= e.event_end <= 528508800) OR (544233600 <= e.event_end <= 560044800) OR (575856000 <= e.event_end <= 591667200) OR (607392000 <= e.event_end <= 623203200) OR (638928000 <= e.event_end <= 654739200) OR (670464000 <= e.event_end <= 686275200) OR (702086400 <= e.event_end <= 717897600) OR (733622400 <= e.event_end <= 749433600) OR (765158400 <= e.event_end <= 780969600) OR (796694400 <= e.event_end <= 812505600) OR (828316800 <= e.event_end <= 844128000) OR (859852800 <= e.event_end <= 875664000) OR (891388800 <= e.event_end <= 907200000) OR (922924800 <= e.event_end <= 938736000) OR (954547200 <= e.event_end <= 970358400) OR (986083200 <= e.event_end <= 1001894400) OR (1017619200 <= e.event_end <= 1033430400) OR (1049155200 <= e.event_end <= 1064966400) OR (1080777600 <= e.event_end <= 1096588800) OR (1112313600 <= e.event_end <= 1128124800) OR (1143849600 <= e.event_end <= 1159660800) OR (1175385600 <= e.event_end <= 1191196800) OR (1207008000 <= e.event_end <= 1222819200) OR (1238544000 <= e.event_end <= 1254355200) OR (1270080000 <= e.event_end <= 1285891200), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7776000 <= e.event_start <= 23587200) OR (39312000 <= e.event_start <= 55123200) OR (70934400 <= e.event_start <= 86745600) OR (102470400 <= e.event_start <= 118281600) OR (134006400 <= e.event_start <= 149817600) OR (165542400 <= e.event_start <= 181353600) OR (197164800 <= e.event_start <= 212976000) OR (228700800 <= e.event_start <= 244512000) OR (260236800 <= e.event_start <= 276048000) OR (291772800 <= e.event_start <= 307584000) OR (323395200 <= e.event_start <= 339206400) OR (354931200 <= e.event_start <= 370742400) OR (386467200 <= e.event_start <= 402278400) OR (418003200 <= e.event_start <= 433814400) OR (449625600 <= e.event_start <= 465436800) OR (481161600 <= e.event_start <= 496972800) OR (512697600 <= e.event_start <= 528508800) OR (544233600 <= e.event_start <= 560044800) OR (575856000 <= e.event_start <= 591667200) OR (607392000 <= e.event_start <= 623203200) OR (638928000 <= e.event_start <= 654739200) OR (670464000 <= e.event_start <= 686275200) OR (702086400 <= e.event_start <= 717897600) OR (733622400 <= e.event_start <= 749433600) OR (765158400 <= e.event_start <= 780969600) OR (796694400 <= e.event_start <= 812505600) OR (828316800 <= e.event_start <= 844128000) OR (859852800 <= e.event_start <= 875664000) OR (891388800 <= e.event_start <= 907200000) OR (922924800 <= e.event_start <= 938736000) OR (954547200 <= e.event_start <= 970358400) OR (986083200 <= e.event_start <= 1001894400) OR (1017619200 <= e.event_start <= 1033430400) OR (1049155200 <= e.event_start <= 1064966400) OR (1080777600 <= e.event_start <= 1096588800) OR (1112313600 <= e.event_start <= 1128124800) OR (1143849600 <= e.event_start <= 1159660800) OR (1175385600 <= e.event_start <= 1191196800) OR (1207008000 <= e.event_start <= 1222819200) OR (1238544000 <= e.event_start <= 1254355200) OR (1270080000 <= e.event_start <= 1285891200), 1, 0), IF((7776000 <= e.event_end <= 23587200) OR (39312000 <= e.event_end <= 55123200) OR (70934400 <= e.event_end <= 86745600) OR (102470400 <= e.event_end <= 118281600) OR (134006400 <= e.event_end <= 149817600) OR (165542400 <= e.event_end <= 181353600) OR (197164800 <= e.event_end <= 212976000) OR (228700800 <= e.event_end <= 244512000) OR (260236800 <= e.event_end <= 276048000) OR (291772800 <= e.event_end <= 307584000) OR (323395200 <= e.event_end <= 339206400) OR (354931200 <= e.event_end <= 370742400) OR (386467200 <= e.event_end <= 402278400) OR (418003200 <= e.event_end <= 433814400) OR (449625600 <= e.event_end <= 465436800) OR (481161600 <= e.event_end <= 496972800) OR (512697600 <= e.event_end <= 528508800) OR (544233600 <= e.event_end <= 560044800) OR (575856000 <= e.event_end <= 591667200) OR (607392000 <= e.event_end <= 623203200) OR (638928000 <= e.event_end <= 654739200) OR (670464000 <= e.event_end <= 686275200) OR (702086400 <= e.event_end <= 717897600) OR (733622400 <= e.event_end <= 749433600) OR (765158400 <= e.event_end <= 780969600) OR (796694400 <= e.event_end <= 812505600) OR (828316800 <= e.event_end <= 844128000) OR (859852800 <= e.event_end <= 875664000) OR (891388800 <= e.event_end <= 907200000) OR (922924800 <= e.event_end <= 938736000) OR (954547200 <= e.event_end <= 970358400) OR (986083200 <= e.event_end <= 1001894400) OR (1017619200 <= e.event_end <= 1033430400) OR (1049155200 <= e.event_end <= 1064966400) OR (1080777600 <= e.event_end <= 1096588800) OR (1112313600 <= e.event_end <= 1128124800) OR (1143849600 <= e.event_end <= 1159660800) OR (1175385600 <= e.event_end <= 1191196800) OR (1207008000 <= e.event_end <= 1222819200) OR (1238544000 <= e.event_end <= 1254355200) OR (1270080000 <= e.event_end <= 1285891200), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 4
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7344000 <= e.event_start <= 24364800) OR (38793600 <= e.event_start <= 55814400) OR (70848000 <= e.event_start <= 87264000) OR (102297600 <= e.event_start <= 118713600) OR (133747200 <= e.event_start <= 150768000) OR (165196800 <= e.event_start <= 182217600) OR (196646400 <= e.event_start <= 213667200) OR (228700800 <= e.event_start <= 245116800) OR (260150400 <= e.event_start <= 276566400) OR (291600000 <= e.event_start <= 308016000) OR (323049600 <= e.event_start <= 340070400) OR (354499200 <= e.event_start <= 371520000) OR (385948800 <= e.event_start <= 402969600) OR (418003200 <= e.event_start <= 434419200) OR (449452800 <= e.event_start <= 465868800) OR (480902400 <= e.event_start <= 497923200) OR (512352000 <= e.event_start <= 529372800) OR (543801600 <= e.event_start <= 560822400) OR (575856000 <= e.event_start <= 592272000) OR (607305600 <= e.event_start <= 623721600) OR (638755200 <= e.event_start <= 655171200) OR (670204800 <= e.event_start <= 687225600) OR (701654400 <= e.event_start <= 718675200) OR (733104000 <= e.event_start <= 750124800) OR (765158400 <= e.event_start <= 781574400) OR (796608000 <= e.event_start <= 813024000) OR (828057600 <= e.event_start <= 845078400) OR (859507200 <= e.event_start <= 876528000) OR (890956800 <= e.event_start <= 907977600) OR (922406400 <= e.event_start <= 939427200) OR (954460800 <= e.event_start <= 970948800) OR (985910400 <= e.event_start <= 1002398460) OR (1017360000 <= e.event_start <= 1034452920) OR (1048809600 <= e.event_start <= 1065902580) OR (1080259200 <= e.event_start <= 1097352240) OR (1112313600 <= e.event_start <= 1128801900) OR (1143763200 <= e.event_start <= 1160251560) OR (1175212800 <= e.event_start <= 1189886820) OR (1206662400 <= e.event_start <= 1223150880) OR (1238112000 <= e.event_start <= 1253995740) OR (1269561600 <= e.event_start <= 1284235800), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7344000 <= e.event_end <= 24364800) OR (38793600 <= e.event_end <= 55814400) OR (70848000 <= e.event_end <= 87264000) OR (102297600 <= e.event_end <= 118713600) OR (133747200 <= e.event_end <= 150768000) OR (165196800 <= e.event_end <= 182217600) OR (196646400 <= e.event_end <= 213667200) OR (228700800 <= e.event_end <= 245116800) OR (260150400 <= e.event_end <= 276566400) OR (291600000 <= e.event_end <= 308016000) OR (323049600 <= e.event_end <= 340070400) OR (354499200 <= e.event_end <= 371520000) OR (385948800 <= e.event_end <= 402969600) OR (418003200 <= e.event_end <= 434419200) OR (449452800 <= e.event_end <= 465868800) OR (480902400 <= e.event_end <= 497923200) OR (512352000 <= e.event_end <= 529372800) OR (543801600 <= e.event_end <= 560822400) OR (575856000 <= e.event_end <= 592272000) OR (607305600 <= e.event_end <= 623721600) OR (638755200 <= e.event_end <= 655171200) OR (670204800 <= e.event_end <= 687225600) OR (701654400 <= e.event_end <= 718675200) OR (733104000 <= e.event_end <= 750124800) OR (765158400 <= e.event_end <= 781574400) OR (796608000 <= e.event_end <= 813024000) OR (828057600 <= e.event_end <= 845078400) OR (859507200 <= e.event_end <= 876528000) OR (890956800 <= e.event_end <= 907977600) OR (922406400 <= e.event_end <= 939427200) OR (954460800 <= e.event_end <= 970948800) OR (985910400 <= e.event_end <= 1002398460) OR (1017360000 <= e.event_end <= 1034452920) OR (1048809600 <= e.event_end <= 1065902580) OR (1080259200 <= e.event_end <= 1097352240) OR (1112313600 <= e.event_end <= 1128801900) OR (1143763200 <= e.event_end <= 1160251560) OR (1175212800 <= e.event_end <= 1189886820) OR (1206662400 <= e.event_end <= 1223150880) OR (1238112000 <= e.event_end <= 1253995740) OR (1269561600 <= e.event_end <= 1284235800), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7344000 <= e.event_start <= 24364800) OR (38793600 <= e.event_start <= 55814400) OR (70848000 <= e.event_start <= 87264000) OR (102297600 <= e.event_start <= 118713600) OR (133747200 <= e.event_start <= 150768000) OR (165196800 <= e.event_start <= 182217600) OR (196646400 <= e.event_start <= 213667200) OR (228700800 <= e.event_start <= 245116800) OR (260150400 <= e.event_start <= 276566400) OR (291600000 <= e.event_start <= 308016000) OR (323049600 <= e.event_start <= 340070400) OR (354499200 <= e.event_start <= 371520000) OR (385948800 <= e.event_start <= 402969600) OR (418003200 <= e.event_start <= 434419200) OR (449452800 <= e.event_start <= 465868800) OR (480902400 <= e.event_start <= 497923200) OR (512352000 <= e.event_start <= 529372800) OR (543801600 <= e.event_start <= 560822400) OR (575856000 <= e.event_start <= 592272000) OR (607305600 <= e.event_start <= 623721600) OR (638755200 <= e.event_start <= 655171200) OR (670204800 <= e.event_start <= 687225600) OR (701654400 <= e.event_start <= 718675200) OR (733104000 <= e.event_start <= 750124800) OR (765158400 <= e.event_start <= 781574400) OR (796608000 <= e.event_start <= 813024000) OR (828057600 <= e.event_start <= 845078400) OR (859507200 <= e.event_start <= 876528000) OR (890956800 <= e.event_start <= 907977600) OR (922406400 <= e.event_start <= 939427200) OR (954460800 <= e.event_start <= 970948800) OR (985910400 <= e.event_start <= 1002398460) OR (1017360000 <= e.event_start <= 1034452920) OR (1048809600 <= e.event_start <= 1065902580) OR (1080259200 <= e.event_start <= 1097352240) OR (1112313600 <= e.event_start <= 1128801900) OR (1143763200 <= e.event_start <= 1160251560) OR (1175212800 <= e.event_start <= 1189886820) OR (1206662400 <= e.event_start <= 1223150880) OR (1238112000 <= e.event_start <= 1253995740) OR (1269561600 <= e.event_start <= 1284235800), 1, 0), IF((7344000 <= e.event_end <= 24364800) OR (38793600 <= e.event_end <= 55814400) OR (70848000 <= e.event_end <= 87264000) OR (102297600 <= e.event_end <= 118713600) OR (133747200 <= e.event_end <= 150768000) OR (165196800 <= e.event_end <= 182217600) OR (196646400 <= e.event_end <= 213667200) OR (228700800 <= e.event_end <= 245116800) OR (260150400 <= e.event_end <= 276566400) OR (291600000 <= e.event_end <= 308016000) OR (323049600 <= e.event_end <= 340070400) OR (354499200 <= e.event_end <= 371520000) OR (385948800 <= e.event_end <= 402969600) OR (418003200 <= e.event_end <= 434419200) OR (449452800 <= e.event_end <= 465868800) OR (480902400 <= e.event_end <= 497923200) OR (512352000 <= e.event_end <= 529372800) OR (543801600 <= e.event_end <= 560822400) OR (575856000 <= e.event_end <= 592272000) OR (607305600 <= e.event_end <= 623721600) OR (638755200 <= e.event_end <= 655171200) OR (670204800 <= e.event_end <= 687225600) OR (701654400 <= e.event_end <= 718675200) OR (733104000 <= e.event_end <= 750124800) OR (765158400 <= e.event_end <= 781574400) OR (796608000 <= e.event_end <= 813024000) OR (828057600 <= e.event_end <= 845078400) OR (859507200 <= e.event_end <= 876528000) OR (890956800 <= e.event_end <= 907977600) OR (922406400 <= e.event_end <= 939427200) OR (954460800 <= e.event_end <= 970948800) OR (985910400 <= e.event_end <= 1002398460) OR (1017360000 <= e.event_end <= 1034452920) OR (1048809600 <= e.event_end <= 1065902580) OR (1080259200 <= e.event_end <= 1097352240) OR (1112313600 <= e.event_end <= 1128801900) OR (1143763200 <= e.event_end <= 1160251560) OR (1175212800 <= e.event_end <= 1189886820) OR (1206662400 <= e.event_end <= 1223150880) OR (1238112000 <= e.event_end <= 1253995740) OR (1269561600 <= e.event_end <= 1284235800), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 5
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7516800 <= e.event_start <= 25660800) OR (38966400 <= e.event_start <= 57715200) OR (70416000 <= e.event_start <= 89164800) OR (101865600 <= e.event_start <= 120614400) OR (133920000 <= e.event_start <= 152064000) OR (165369600 <= e.event_start <= 183513600) OR (196819200 <= e.event_start <= 215568000) OR (228268800 <= e.event_start <= 247017600) OR (259718400 <= e.event_start <= 278467200) OR (291168000 <= e.event_start <= 309916800) OR (323222400 <= e.event_start <= 341366400) OR (354672000 <= e.event_start <= 372816000) OR (386121600 <= e.event_start <= 404870400) OR (417571200 <= e.event_start <= 436320000) OR (449020800 <= e.event_start <= 467769600) OR (481075200 <= e.event_start <= 499219200) OR (512524800 <= e.event_start <= 530668800) OR (543974400 <= e.event_start <= 562118400) OR (575424000 <= e.event_start <= 594172800) OR (606873600 <= e.event_start <= 625622400) OR (638323200 <= e.event_start <= 657072000) OR (670377600 <= e.event_start <= 688521600) OR (701827200 <= e.event_start <= 719971200) OR (733276800 <= e.event_start <= 752025600) OR (764726400 <= e.event_start <= 783475200) OR (796176000 <= e.event_start <= 814924800) OR (828230400 <= e.event_start <= 846374400) OR (859680000 <= e.event_start <= 877824000) OR (891129600 <= e.event_start <= 909273600) OR (922579200 <= e.event_start <= 941328000) OR (954028800 <= e.event_start <= 972777600) OR (985478400 <= e.event_start <= 1004227200) OR (1017532800 <= e.event_start <= 1035676800) OR (1048982400 <= e.event_start <= 1067126400) OR (1080432000 <= e.event_start <= 1099180800) OR (1111881600 <= e.event_start <= 1130630400) OR (1143331200 <= e.event_start <= 1162080000) OR (1174780800 <= e.event_start <= 1193529600) OR (1206835200 <= e.event_start <= 1224979200) OR (1238284800 <= e.event_start <= 1256428800) OR (1269734400 <= e.event_start <= 1288483200), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7516800 <= e.event_end <= 25660800) OR (38966400 <= e.event_end <= 57715200) OR (70416000 <= e.event_end <= 89164800) OR (101865600 <= e.event_end <= 120614400) OR (133920000 <= e.event_end <= 152064000) OR (165369600 <= e.event_end <= 183513600) OR (196819200 <= e.event_end <= 215568000) OR (228268800 <= e.event_end <= 247017600) OR (259718400 <= e.event_end <= 278467200) OR (291168000 <= e.event_end <= 309916800) OR (323222400 <= e.event_end <= 341366400) OR (354672000 <= e.event_end <= 372816000) OR (386121600 <= e.event_end <= 404870400) OR (417571200 <= e.event_end <= 436320000) OR (449020800 <= e.event_end <= 467769600) OR (481075200 <= e.event_end <= 499219200) OR (512524800 <= e.event_end <= 530668800) OR (543974400 <= e.event_end <= 562118400) OR (575424000 <= e.event_end <= 594172800) OR (606873600 <= e.event_end <= 625622400) OR (638323200 <= e.event_end <= 657072000) OR (670377600 <= e.event_end <= 688521600) OR (701827200 <= e.event_end <= 719971200) OR (733276800 <= e.event_end <= 752025600) OR (764726400 <= e.event_end <= 783475200) OR (796176000 <= e.event_end <= 814924800) OR (828230400 <= e.event_end <= 846374400) OR (859680000 <= e.event_end <= 877824000) OR (891129600 <= e.event_end <= 909273600) OR (922579200 <= e.event_end <= 941328000) OR (954028800 <= e.event_end <= 972777600) OR (985478400 <= e.event_end <= 1004227200) OR (1017532800 <= e.event_end <= 1035676800) OR (1048982400 <= e.event_end <= 1067126400) OR (1080432000 <= e.event_end <= 1099180800) OR (1111881600 <= e.event_end <= 1130630400) OR (1143331200 <= e.event_end <= 1162080000) OR (1174780800 <= e.event_end <= 1193529600) OR (1206835200 <= e.event_end <= 1224979200) OR (1238284800 <= e.event_end <= 1256428800) OR (1269734400 <= e.event_end <= 1288483200), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7516800 <= e.event_start <= 25660800) OR (38966400 <= e.event_start <= 57715200) OR (70416000 <= e.event_start <= 89164800) OR (101865600 <= e.event_start <= 120614400) OR (133920000 <= e.event_start <= 152064000) OR (165369600 <= e.event_start <= 183513600) OR (196819200 <= e.event_start <= 215568000) OR (228268800 <= e.event_start <= 247017600) OR (259718400 <= e.event_start <= 278467200) OR (291168000 <= e.event_start <= 309916800) OR (323222400 <= e.event_start <= 341366400) OR (354672000 <= e.event_start <= 372816000) OR (386121600 <= e.event_start <= 404870400) OR (417571200 <= e.event_start <= 436320000) OR (449020800 <= e.event_start <= 467769600) OR (481075200 <= e.event_start <= 499219200) OR (512524800 <= e.event_start <= 530668800) OR (543974400 <= e.event_start <= 562118400) OR (575424000 <= e.event_start <= 594172800) OR (606873600 <= e.event_start <= 625622400) OR (638323200 <= e.event_start <= 657072000) OR (670377600 <= e.event_start <= 688521600) OR (701827200 <= e.event_start <= 719971200) OR (733276800 <= e.event_start <= 752025600) OR (764726400 <= e.event_start <= 783475200) OR (796176000 <= e.event_start <= 814924800) OR (828230400 <= e.event_start <= 846374400) OR (859680000 <= e.event_start <= 877824000) OR (891129600 <= e.event_start <= 909273600) OR (922579200 <= e.event_start <= 941328000) OR (954028800 <= e.event_start <= 972777600) OR (985478400 <= e.event_start <= 1004227200) OR (1017532800 <= e.event_start <= 1035676800) OR (1048982400 <= e.event_start <= 1067126400) OR (1080432000 <= e.event_start <= 1099180800) OR (1111881600 <= e.event_start <= 1130630400) OR (1143331200 <= e.event_start <= 1162080000) OR (1174780800 <= e.event_start <= 1193529600) OR (1206835200 <= e.event_start <= 1224979200) OR (1238284800 <= e.event_start <= 1256428800) OR (1269734400 <= e.event_start <= 1288483200), 1, 0), IF((7516800 <= e.event_end <= 25660800) OR (38966400 <= e.event_end <= 57715200) OR (70416000 <= e.event_end <= 89164800) OR (101865600 <= e.event_end <= 120614400) OR (133920000 <= e.event_end <= 152064000) OR (165369600 <= e.event_end <= 183513600) OR (196819200 <= e.event_end <= 215568000) OR (228268800 <= e.event_end <= 247017600) OR (259718400 <= e.event_end <= 278467200) OR (291168000 <= e.event_end <= 309916800) OR (323222400 <= e.event_end <= 341366400) OR (354672000 <= e.event_end <= 372816000) OR (386121600 <= e.event_end <= 404870400) OR (417571200 <= e.event_end <= 436320000) OR (449020800 <= e.event_end <= 467769600) OR (481075200 <= e.event_end <= 499219200) OR (512524800 <= e.event_end <= 530668800) OR (543974400 <= e.event_end <= 562118400) OR (575424000 <= e.event_end <= 594172800) OR (606873600 <= e.event_end <= 625622400) OR (638323200 <= e.event_end <= 657072000) OR (670377600 <= e.event_end <= 688521600) OR (701827200 <= e.event_end <= 719971200) OR (733276800 <= e.event_end <= 752025600) OR (764726400 <= e.event_end <= 783475200) OR (796176000 <= e.event_end <= 814924800) OR (828230400 <= e.event_end <= 846374400) OR (859680000 <= e.event_end <= 877824000) OR (891129600 <= e.event_end <= 909273600) OR (922579200 <= e.event_end <= 941328000) OR (954028800 <= e.event_end <= 972777600) OR (985478400 <= e.event_end <= 1004227200) OR (1017532800 <= e.event_end <= 1035676800) OR (1048982400 <= e.event_end <= 1067126400) OR (1080432000 <= e.event_end <= 1099180800) OR (1111881600 <= e.event_end <= 1130630400) OR (1143331200 <= e.event_end <= 1162080000) OR (1174780800 <= e.event_end <= 1193529600) OR (1206835200 <= e.event_end <= 1224979200) OR (1238284800 <= e.event_end <= 1256428800) OR (1269734400 <= e.event_end <= 1288483200), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 6
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((9158400 <= e.event_start <= 24883200) OR (40608000 <= e.event_start <= 56332800) OR (72662400 <= e.event_start <= 88387200) OR (104112000 <= e.event_start <= 119836800) OR (135561600 <= e.event_start <= 151286400) OR (167011200 <= e.event_start <= 182736000) OR (198460800 <= e.event_start <= 214185600) OR (229910400 <= e.event_start <= 246240000) OR (261964800 <= e.event_start <= 277689600) OR (293414400 <= e.event_start <= 309139200) OR (324864000 <= e.event_start <= 340588800) OR (356313600 <= e.event_start <= 372038400) OR (387763200 <= e.event_start <= 403488000) OR (419212800 <= e.event_start <= 435542400) OR (451267200 <= e.event_start <= 466992000) OR (482716800 <= e.event_start <= 498441600) OR (514166400 <= e.event_start <= 529891200) OR (545616000 <= e.event_start <= 561340800) OR (577065600 <= e.event_start <= 593395200) OR (609120000 <= e.event_start <= 624844800) OR (640569600 <= e.event_start <= 656294400) OR (672019200 <= e.event_start <= 687744000) OR (703468800 <= e.event_start <= 719193600) OR (734918400 <= e.event_start <= 750643200) OR (766368000 <= e.event_start <= 782697600) OR (798422400 <= e.event_start <= 814147200) OR (829872000 <= e.event_start <= 845596800) OR (861321600 <= e.event_start <= 877046400) OR (892771200 <= e.event_start <= 908496000) OR (924220800 <= e.event_start <= 939945600) OR (956275200 <= e.event_start <= 972000000) OR (987724800 <= e.event_start <= 1003449600) OR (1019174400 <= e.event_start <= 1034899200) OR (1050624000 <= e.event_start <= 1066348800) OR (1082073600 <= e.event_start <= 1097798400) OR (1113523200 <= e.event_start <= 1129852800) OR (1145577600 <= e.event_start <= 1161302400) OR (1177027200 <= e.event_start <= 1192752000) OR (1208476800 <= e.event_start <= 1224201600) OR (1239926400 <= e.event_start <= 1255651200) OR (1271376000 <= e.event_start <= 1287100800), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((9158400 <= e.event_end <= 24883200) OR (40608000 <= e.event_end <= 56332800) OR (72662400 <= e.event_end <= 88387200) OR (104112000 <= e.event_end <= 119836800) OR (135561600 <= e.event_end <= 151286400) OR (167011200 <= e.event_end <= 182736000) OR (198460800 <= e.event_end <= 214185600) OR (229910400 <= e.event_end <= 246240000) OR (261964800 <= e.event_end <= 277689600) OR (293414400 <= e.event_end <= 309139200) OR (324864000 <= e.event_end <= 340588800) OR (356313600 <= e.event_end <= 372038400) OR (387763200 <= e.event_end <= 403488000) OR (419212800 <= e.event_end <= 435542400) OR (451267200 <= e.event_end <= 466992000) OR (482716800 <= e.event_end <= 498441600) OR (514166400 <= e.event_end <= 529891200) OR (545616000 <= e.event_end <= 561340800) OR (577065600 <= e.event_end <= 593395200) OR (609120000 <= e.event_end <= 624844800) OR (640569600 <= e.event_end <= 656294400) OR (672019200 <= e.event_end <= 687744000) OR (703468800 <= e.event_end <= 719193600) OR (734918400 <= e.event_end <= 750643200) OR (766368000 <= e.event_end <= 782697600) OR (798422400 <= e.event_end <= 814147200) OR (829872000 <= e.event_end <= 845596800) OR (861321600 <= e.event_end <= 877046400) OR (892771200 <= e.event_end <= 908496000) OR (924220800 <= e.event_end <= 939945600) OR (956275200 <= e.event_end <= 972000000) OR (987724800 <= e.event_end <= 1003449600) OR (1019174400 <= e.event_end <= 1034899200) OR (1050624000 <= e.event_end <= 1066348800) OR (1082073600 <= e.event_end <= 1097798400) OR (1113523200 <= e.event_end <= 1129852800) OR (1145577600 <= e.event_end <= 1161302400) OR (1177027200 <= e.event_end <= 1192752000) OR (1208476800 <= e.event_end <= 1224201600) OR (1239926400 <= e.event_end <= 1255651200) OR (1271376000 <= e.event_end <= 1287100800), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((9158400 <= e.event_start <= 24883200) OR (40608000 <= e.event_start <= 56332800) OR (72662400 <= e.event_start <= 88387200) OR (104112000 <= e.event_start <= 119836800) OR (135561600 <= e.event_start <= 151286400) OR (167011200 <= e.event_start <= 182736000) OR (198460800 <= e.event_start <= 214185600) OR (229910400 <= e.event_start <= 246240000) OR (261964800 <= e.event_start <= 277689600) OR (293414400 <= e.event_start <= 309139200) OR (324864000 <= e.event_start <= 340588800) OR (356313600 <= e.event_start <= 372038400) OR (387763200 <= e.event_start <= 403488000) OR (419212800 <= e.event_start <= 435542400) OR (451267200 <= e.event_start <= 466992000) OR (482716800 <= e.event_start <= 498441600) OR (514166400 <= e.event_start <= 529891200) OR (545616000 <= e.event_start <= 561340800) OR (577065600 <= e.event_start <= 593395200) OR (609120000 <= e.event_start <= 624844800) OR (640569600 <= e.event_start <= 656294400) OR (672019200 <= e.event_start <= 687744000) OR (703468800 <= e.event_start <= 719193600) OR (734918400 <= e.event_start <= 750643200) OR (766368000 <= e.event_start <= 782697600) OR (798422400 <= e.event_start <= 814147200) OR (829872000 <= e.event_start <= 845596800) OR (861321600 <= e.event_start <= 877046400) OR (892771200 <= e.event_start <= 908496000) OR (924220800 <= e.event_start <= 939945600) OR (956275200 <= e.event_start <= 972000000) OR (987724800 <= e.event_start <= 1003449600) OR (1019174400 <= e.event_start <= 1034899200) OR (1050624000 <= e.event_start <= 1066348800) OR (1082073600 <= e.event_start <= 1097798400) OR (1113523200 <= e.event_start <= 1129852800) OR (1145577600 <= e.event_start <= 1161302400) OR (1177027200 <= e.event_start <= 1192752000) OR (1208476800 <= e.event_start <= 1224201600) OR (1239926400 <= e.event_start <= 1255651200) OR (1271376000 <= e.event_start <= 1287100800), 1, 0), IF((9158400 <= e.event_end <= 24883200) OR (40608000 <= e.event_end <= 56332800) OR (72662400 <= e.event_end <= 88387200) OR (104112000 <= e.event_end <= 119836800) OR (135561600 <= e.event_end <= 151286400) OR (167011200 <= e.event_end <= 182736000) OR (198460800 <= e.event_end <= 214185600) OR (229910400 <= e.event_end <= 246240000) OR (261964800 <= e.event_end <= 277689600) OR (293414400 <= e.event_end <= 309139200) OR (324864000 <= e.event_end <= 340588800) OR (356313600 <= e.event_end <= 372038400) OR (387763200 <= e.event_end <= 403488000) OR (419212800 <= e.event_end <= 435542400) OR (451267200 <= e.event_end <= 466992000) OR (482716800 <= e.event_end <= 498441600) OR (514166400 <= e.event_end <= 529891200) OR (545616000 <= e.event_end <= 561340800) OR (577065600 <= e.event_end <= 593395200) OR (609120000 <= e.event_end <= 624844800) OR (640569600 <= e.event_end <= 656294400) OR (672019200 <= e.event_end <= 687744000) OR (703468800 <= e.event_end <= 719193600) OR (734918400 <= e.event_end <= 750643200) OR (766368000 <= e.event_end <= 782697600) OR (798422400 <= e.event_end <= 814147200) OR (829872000 <= e.event_end <= 845596800) OR (861321600 <= e.event_end <= 877046400) OR (892771200 <= e.event_end <= 908496000) OR (924220800 <= e.event_end <= 939945600) OR (956275200 <= e.event_end <= 972000000) OR (987724800 <= e.event_end <= 1003449600) OR (1019174400 <= e.event_end <= 1034899200) OR (1050624000 <= e.event_end <= 1066348800) OR (1082073600 <= e.event_end <= 1097798400) OR (1113523200 <= e.event_end <= 1129852800) OR (1145577600 <= e.event_end <= 1161302400) OR (1177027200 <= e.event_end <= 1192752000) OR (1208476800 <= e.event_end <= 1224201600) OR (1239926400 <= e.event_end <= 1255651200) OR (1271376000 <= e.event_end <= 1287100800), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 7
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((6825600 <= e.event_start <= 22896000) OR (38361600 <= e.event_start <= 54432000) OR (69984000 <= e.event_start <= 86054400) OR (101520000 <= e.event_start <= 117590400) OR (133056000 <= e.event_start <= 149126400) OR (164592000 <= e.event_start <= 180662400) OR (196214400 <= e.event_start <= 212284800) OR (227750400 <= e.event_start <= 243820800) OR (259286400 <= e.event_start <= 275356800) OR (290822400 <= e.event_start <= 306892800) OR (322444800 <= e.event_start <= 338515200) OR (353980800 <= e.event_start <= 370051200) OR (385516800 <= e.event_start <= 401587200) OR (417052800 <= e.event_start <= 433123200) OR (448675200 <= e.event_start <= 464745600) OR (480211200 <= e.event_start <= 496281600) OR (511747200 <= e.event_start <= 527817600) OR (543283200 <= e.event_start <= 559353600) OR (574905600 <= e.event_start <= 590976000) OR (606441600 <= e.event_start <= 622512000) OR (637977600 <= e.event_start <= 654048000) OR (669513600 <= e.event_start <= 685584000) OR (701136000 <= e.event_start <= 717206400) OR (732672000 <= e.event_start <= 748742400) OR (764208000 <= e.event_start <= 780278400) OR (795744000 <= e.event_start <= 811814400) OR (827366400 <= e.event_start <= 843436800) OR (858902400 <= e.event_start <= 874972800) OR (890438400 <= e.event_start <= 906508800) OR (921974400 <= e.event_start <= 938044800) OR (953596800 <= e.event_start <= 969667200) OR (985132800 <= e.event_start <= 1001203200) OR (1016668800 <= e.event_start <= 1032739200) OR (1048204800 <= e.event_start <= 1064275200) OR (1079827200 <= e.event_start <= 1095897600) OR (1111363200 <= e.event_start <= 1127433600) OR (1142899200 <= e.event_start <= 1158969600) OR (1174435200 <= e.event_start <= 1190505600) OR (1206057600 <= e.event_start <= 1222128000) OR (1237593600 <= e.event_start <= 1253664000) OR (1269129600 <= e.event_start <= 1285200000), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((6825600 <= e.event_end <= 22896000) OR (38361600 <= e.event_end <= 54432000) OR (69984000 <= e.event_end <= 86054400) OR (101520000 <= e.event_end <= 117590400) OR (133056000 <= e.event_end <= 149126400) OR (164592000 <= e.event_end <= 180662400) OR (196214400 <= e.event_end <= 212284800) OR (227750400 <= e.event_end <= 243820800) OR (259286400 <= e.event_end <= 275356800) OR (290822400 <= e.event_end <= 306892800) OR (322444800 <= e.event_end <= 338515200) OR (353980800 <= e.event_end <= 370051200) OR (385516800 <= e.event_end <= 401587200) OR (417052800 <= e.event_end <= 433123200) OR (448675200 <= e.event_end <= 464745600) OR (480211200 <= e.event_end <= 496281600) OR (511747200 <= e.event_end <= 527817600) OR (543283200 <= e.event_end <= 559353600) OR (574905600 <= e.event_end <= 590976000) OR (606441600 <= e.event_end <= 622512000) OR (637977600 <= e.event_end <= 654048000) OR (669513600 <= e.event_end <= 685584000) OR (701136000 <= e.event_end <= 717206400) OR (732672000 <= e.event_end <= 748742400) OR (764208000 <= e.event_end <= 780278400) OR (795744000 <= e.event_end <= 811814400) OR (827366400 <= e.event_end <= 843436800) OR (858902400 <= e.event_end <= 874972800) OR (890438400 <= e.event_end <= 906508800) OR (921974400 <= e.event_end <= 938044800) OR (953596800 <= e.event_end <= 969667200) OR (985132800 <= e.event_end <= 1001203200) OR (1016668800 <= e.event_end <= 1032739200) OR (1048204800 <= e.event_end <= 1064275200) OR (1079827200 <= e.event_end <= 1095897600) OR (1111363200 <= e.event_end <= 1127433600) OR (1142899200 <= e.event_end <= 1158969600) OR (1174435200 <= e.event_end <= 1190505600) OR (1206057600 <= e.event_end <= 1222128000) OR (1237593600 <= e.event_end <= 1253664000) OR (1269129600 <= e.event_end <= 1285200000), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((6825600 <= e.event_start <= 22896000) OR (38361600 <= e.event_start <= 54432000) OR (69984000 <= e.event_start <= 86054400) OR (101520000 <= e.event_start <= 117590400) OR (133056000 <= e.event_start <= 149126400) OR (164592000 <= e.event_start <= 180662400) OR (196214400 <= e.event_start <= 212284800) OR (227750400 <= e.event_start <= 243820800) OR (259286400 <= e.event_start <= 275356800) OR (290822400 <= e.event_start <= 306892800) OR (322444800 <= e.event_start <= 338515200) OR (353980800 <= e.event_start <= 370051200) OR (385516800 <= e.event_start <= 401587200) OR (417052800 <= e.event_start <= 433123200) OR (448675200 <= e.event_start <= 464745600) OR (480211200 <= e.event_start <= 496281600) OR (511747200 <= e.event_start <= 527817600) OR (543283200 <= e.event_start <= 559353600) OR (574905600 <= e.event_start <= 590976000) OR (606441600 <= e.event_start <= 622512000) OR (637977600 <= e.event_start <= 654048000) OR (669513600 <= e.event_start <= 685584000) OR (701136000 <= e.event_start <= 717206400) OR (732672000 <= e.event_start <= 748742400) OR (764208000 <= e.event_start <= 780278400) OR (795744000 <= e.event_start <= 811814400) OR (827366400 <= e.event_start <= 843436800) OR (858902400 <= e.event_start <= 874972800) OR (890438400 <= e.event_start <= 906508800) OR (921974400 <= e.event_start <= 938044800) OR (953596800 <= e.event_start <= 969667200) OR (985132800 <= e.event_start <= 1001203200) OR (1016668800 <= e.event_start <= 1032739200) OR (1048204800 <= e.event_start <= 1064275200) OR (1079827200 <= e.event_start <= 1095897600) OR (1111363200 <= e.event_start <= 1127433600) OR (1142899200 <= e.event_start <= 1158969600) OR (1174435200 <= e.event_start <= 1190505600) OR (1206057600 <= e.event_start <= 1222128000) OR (1237593600 <= e.event_start <= 1253664000) OR (1269129600 <= e.event_start <= 1285200000), 1, 0), IF((6825600 <= e.event_end <= 22896000) OR (38361600 <= e.event_end <= 54432000) OR (69984000 <= e.event_end <= 86054400) OR (101520000 <= e.event_end <= 117590400) OR (133056000 <= e.event_end <= 149126400) OR (164592000 <= e.event_end <= 180662400) OR (196214400 <= e.event_end <= 212284800) OR (227750400 <= e.event_end <= 243820800) OR (259286400 <= e.event_end <= 275356800) OR (290822400 <= e.event_end <= 306892800) OR (322444800 <= e.event_end <= 338515200) OR (353980800 <= e.event_end <= 370051200) OR (385516800 <= e.event_end <= 401587200) OR (417052800 <= e.event_end <= 433123200) OR (448675200 <= e.event_end <= 464745600) OR (480211200 <= e.event_end <= 496281600) OR (511747200 <= e.event_end <= 527817600) OR (543283200 <= e.event_end <= 559353600) OR (574905600 <= e.event_end <= 590976000) OR (606441600 <= e.event_end <= 622512000) OR (637977600 <= e.event_end <= 654048000) OR (669513600 <= e.event_end <= 685584000) OR (701136000 <= e.event_end <= 717206400) OR (732672000 <= e.event_end <= 748742400) OR (764208000 <= e.event_end <= 780278400) OR (795744000 <= e.event_end <= 811814400) OR (827366400 <= e.event_end <= 843436800) OR (858902400 <= e.event_end <= 874972800) OR (890438400 <= e.event_end <= 906508800) OR (921974400 <= e.event_end <= 938044800) OR (953596800 <= e.event_end <= 969667200) OR (985132800 <= e.event_end <= 1001203200) OR (1016668800 <= e.event_end <= 1032739200) OR (1048204800 <= e.event_end <= 1064275200) OR (1079827200 <= e.event_end <= 1095897600) OR (1111363200 <= e.event_end <= 1127433600) OR (1142899200 <= e.event_end <= 1158969600) OR (1174435200 <= e.event_end <= 1190505600) OR (1206057600 <= e.event_end <= 1222128000) OR (1237593600 <= e.event_end <= 1253664000) OR (1269129600 <= e.event_end <= 1285200000), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 8
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((25660800 <= e.event_start <= 7516800) OR (57715200 <= e.event_start <= 38966400) OR (89164800 <= e.event_start <= 70416000) OR (120614400 <= e.event_start <= 101865600) OR (152064000 <= e.event_start <= 133920000) OR (183513600 <= e.event_start <= 165369600) OR (215568000 <= e.event_start <= 196819200) OR (247017600 <= e.event_start <= 228268800) OR (278467200 <= e.event_start <= 259718400) OR (309916800 <= e.event_start <= 291168000) OR (341366400 <= e.event_start <= 323222400) OR (372816000 <= e.event_start <= 354672000) OR (404870400 <= e.event_start <= 386121600) OR (436320000 <= e.event_start <= 417571200) OR (467769600 <= e.event_start <= 449020800) OR (499219200 <= e.event_start <= 481075200) OR (530668800 <= e.event_start <= 512524800) OR (562118400 <= e.event_start <= 543974400) OR (594172800 <= e.event_start <= 575424000) OR (625622400 <= e.event_start <= 606873600) OR (657072000 <= e.event_start <= 638323200) OR (688521600 <= e.event_start <= 670377600) OR (719971200 <= e.event_start <= 701827200) OR (752025600 <= e.event_start <= 733276800) OR (783475200 <= e.event_start <= 764726400) OR (814924800 <= e.event_start <= 796176000) OR (846374400 <= e.event_start <= 828230400) OR (877824000 <= e.event_start <= 859680000) OR (909273600 <= e.event_start <= 891129600) OR (941328000 <= e.event_start <= 922579200) OR (972777600 <= e.event_start <= 954028800) OR (1004227200 <= e.event_start <= 985478400) OR (1035676800 <= e.event_start <= 1017532800) OR (1067126400 <= e.event_start <= 1048982400) OR (1099180800 <= e.event_start <= 1080432000) OR (1130630400 <= e.event_start <= 1111881600) OR (1162080000 <= e.event_start <= 1143331200) OR (1193529600 <= e.event_start <= 1174780800) OR (1224979200 <= e.event_start <= 1206835200) OR (1256428800 <= e.event_start <= 1238284800) OR (1288483200 <= e.event_start <= 1269734400), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((25660800 <= e.event_end <= 7516800) OR (57715200 <= e.event_end <= 38966400) OR (89164800 <= e.event_end <= 70416000) OR (120614400 <= e.event_end <= 101865600) OR (152064000 <= e.event_end <= 133920000) OR (183513600 <= e.event_end <= 165369600) OR (215568000 <= e.event_end <= 196819200) OR (247017600 <= e.event_end <= 228268800) OR (278467200 <= e.event_end <= 259718400) OR (309916800 <= e.event_end <= 291168000) OR (341366400 <= e.event_end <= 323222400) OR (372816000 <= e.event_end <= 354672000) OR (404870400 <= e.event_end <= 386121600) OR (436320000 <= e.event_end <= 417571200) OR (467769600 <= e.event_end <= 449020800) OR (499219200 <= e.event_end <= 481075200) OR (530668800 <= e.event_end <= 512524800) OR (562118400 <= e.event_end <= 543974400) OR (594172800 <= e.event_end <= 575424000) OR (625622400 <= e.event_end <= 606873600) OR (657072000 <= e.event_end <= 638323200) OR (688521600 <= e.event_end <= 670377600) OR (719971200 <= e.event_end <= 701827200) OR (752025600 <= e.event_end <= 733276800) OR (783475200 <= e.event_end <= 764726400) OR (814924800 <= e.event_end <= 796176000) OR (846374400 <= e.event_end <= 828230400) OR (877824000 <= e.event_end <= 859680000) OR (909273600 <= e.event_end <= 891129600) OR (941328000 <= e.event_end <= 922579200) OR (972777600 <= e.event_end <= 954028800) OR (1004227200 <= e.event_end <= 985478400) OR (1035676800 <= e.event_end <= 1017532800) OR (1067126400 <= e.event_end <= 1048982400) OR (1099180800 <= e.event_end <= 1080432000) OR (1130630400 <= e.event_end <= 1111881600) OR (1162080000 <= e.event_end <= 1143331200) OR (1193529600 <= e.event_end <= 1174780800) OR (1224979200 <= e.event_end <= 1206835200) OR (1256428800 <= e.event_end <= 1238284800) OR (1288483200 <= e.event_end <= 1269734400), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((25660800 <= e.event_start <= 7516800) OR (57715200 <= e.event_start <= 38966400) OR (89164800 <= e.event_start <= 70416000) OR (120614400 <= e.event_start <= 101865600) OR (152064000 <= e.event_start <= 133920000) OR (183513600 <= e.event_start <= 165369600) OR (215568000 <= e.event_start <= 196819200) OR (247017600 <= e.event_start <= 228268800) OR (278467200 <= e.event_start <= 259718400) OR (309916800 <= e.event_start <= 291168000) OR (341366400 <= e.event_start <= 323222400) OR (372816000 <= e.event_start <= 354672000) OR (404870400 <= e.event_start <= 386121600) OR (436320000 <= e.event_start <= 417571200) OR (467769600 <= e.event_start <= 449020800) OR (499219200 <= e.event_start <= 481075200) OR (530668800 <= e.event_start <= 512524800) OR (562118400 <= e.event_start <= 543974400) OR (594172800 <= e.event_start <= 575424000) OR (625622400 <= e.event_start <= 606873600) OR (657072000 <= e.event_start <= 638323200) OR (688521600 <= e.event_start <= 670377600) OR (719971200 <= e.event_start <= 701827200) OR (752025600 <= e.event_start <= 733276800) OR (783475200 <= e.event_start <= 764726400) OR (814924800 <= e.event_start <= 796176000) OR (846374400 <= e.event_start <= 828230400) OR (877824000 <= e.event_start <= 859680000) OR (909273600 <= e.event_start <= 891129600) OR (941328000 <= e.event_start <= 922579200) OR (972777600 <= e.event_start <= 954028800) OR (1004227200 <= e.event_start <= 985478400) OR (1035676800 <= e.event_start <= 1017532800) OR (1067126400 <= e.event_start <= 1048982400) OR (1099180800 <= e.event_start <= 1080432000) OR (1130630400 <= e.event_start <= 1111881600) OR (1162080000 <= e.event_start <= 1143331200) OR (1193529600 <= e.event_start <= 1174780800) OR (1224979200 <= e.event_start <= 1206835200) OR (1256428800 <= e.event_start <= 1238284800) OR (1288483200 <= e.event_start <= 1269734400), 1, 0), IF((25660800 <= e.event_end <= 7516800) OR (57715200 <= e.event_end <= 38966400) OR (89164800 <= e.event_end <= 70416000) OR (120614400 <= e.event_end <= 101865600) OR (152064000 <= e.event_end <= 133920000) OR (183513600 <= e.event_end <= 165369600) OR (215568000 <= e.event_end <= 196819200) OR (247017600 <= e.event_end <= 228268800) OR (278467200 <= e.event_end <= 259718400) OR (309916800 <= e.event_end <= 291168000) OR (341366400 <= e.event_end <= 323222400) OR (372816000 <= e.event_end <= 354672000) OR (404870400 <= e.event_end <= 386121600) OR (436320000 <= e.event_end <= 417571200) OR (467769600 <= e.event_end <= 449020800) OR (499219200 <= e.event_end <= 481075200) OR (530668800 <= e.event_end <= 512524800) OR (562118400 <= e.event_end <= 543974400) OR (594172800 <= e.event_end <= 575424000) OR (625622400 <= e.event_end <= 606873600) OR (657072000 <= e.event_end <= 638323200) OR (688521600 <= e.event_end <= 670377600) OR (719971200 <= e.event_end <= 701827200) OR (752025600 <= e.event_end <= 733276800) OR (783475200 <= e.event_end <= 764726400) OR (814924800 <= e.event_end <= 796176000) OR (846374400 <= e.event_end <= 828230400) OR (877824000 <= e.event_end <= 859680000) OR (909273600 <= e.event_end <= 891129600) OR (941328000 <= e.event_end <= 922579200) OR (972777600 <= e.event_end <= 954028800) OR (1004227200 <= e.event_end <= 985478400) OR (1035676800 <= e.event_end <= 1017532800) OR (1067126400 <= e.event_end <= 1048982400) OR (1099180800 <= e.event_end <= 1080432000) OR (1130630400 <= e.event_end <= 1111881600) OR (1162080000 <= e.event_end <= 1143331200) OR (1193529600 <= e.event_end <= 1174780800) OR (1224979200 <= e.event_end <= 1206835200) OR (1256428800 <= e.event_end <= 1238284800) OR (1288483200 <= e.event_end <= 1269734400), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 9
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((24451200 <= e.event_start <= 7516800) OR (55900800 <= e.event_start <= 38966400) OR (87350400 <= e.event_start <= 70416000) OR (119404800 <= e.event_start <= 101865600) OR (150854400 <= e.event_start <= 133920000) OR (182304000 <= e.event_start <= 165369600) OR (213753600 <= e.event_start <= 196819200) OR (245203200 <= e.event_start <= 228268800) OR (276652800 <= e.event_start <= 259718400) OR (308707200 <= e.event_start <= 291168000) OR (340156800 <= e.event_start <= 323222400) OR (371606400 <= e.event_start <= 354672000) OR (403056000 <= e.event_start <= 386121600) OR (434505600 <= e.event_start <= 417571200) OR (466560000 <= e.event_start <= 449020800) OR (498009600 <= e.event_start <= 481075200) OR (529459200 <= e.event_start <= 512524800) OR (560908800 <= e.event_start <= 543974400) OR (592358400 <= e.event_start <= 575424000) OR (623808000 <= e.event_start <= 606873600) OR (655862400 <= e.event_start <= 638323200) OR (687312000 <= e.event_start <= 670377600) OR (718761600 <= e.event_start <= 701827200) OR (750211200 <= e.event_start <= 733276800) OR (781660800 <= e.event_start <= 764726400) OR (813110400 <= e.event_start <= 796176000) OR (845164800 <= e.event_start <= 828230400) OR (876614400 <= e.event_start <= 859680000) OR (908064000 <= e.event_start <= 891129600) OR (939513600 <= e.event_start <= 922579200) OR (970963200 <= e.event_start <= 954028800) OR (1003017600 <= e.event_start <= 985478400) OR (1034467200 <= e.event_start <= 1017532800) OR (1065916800 <= e.event_start <= 1048982400) OR (1097366400 <= e.event_start <= 1080432000) OR (1128816000 <= e.event_start <= 1111881600) OR (1160265600 <= e.event_start <= 1143331200) OR (1192320000 <= e.event_start <= 1174780800) OR (1223769600 <= e.event_start <= 1206835200) OR (1255219200 <= e.event_start <= 1238284800) OR (1286668800 <= e.event_start <= 1269734400), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((24451200 <= e.event_end <= 7516800) OR (55900800 <= e.event_end <= 38966400) OR (87350400 <= e.event_end <= 70416000) OR (119404800 <= e.event_end <= 101865600) OR (150854400 <= e.event_end <= 133920000) OR (182304000 <= e.event_end <= 165369600) OR (213753600 <= e.event_end <= 196819200) OR (245203200 <= e.event_end <= 228268800) OR (276652800 <= e.event_end <= 259718400) OR (308707200 <= e.event_end <= 291168000) OR (340156800 <= e.event_end <= 323222400) OR (371606400 <= e.event_end <= 354672000) OR (403056000 <= e.event_end <= 386121600) OR (434505600 <= e.event_end <= 417571200) OR (466560000 <= e.event_end <= 449020800) OR (498009600 <= e.event_end <= 481075200) OR (529459200 <= e.event_end <= 512524800) OR (560908800 <= e.event_end <= 543974400) OR (592358400 <= e.event_end <= 575424000) OR (623808000 <= e.event_end <= 606873600) OR (655862400 <= e.event_end <= 638323200) OR (687312000 <= e.event_end <= 670377600) OR (718761600 <= e.event_end <= 701827200) OR (750211200 <= e.event_end <= 733276800) OR (781660800 <= e.event_end <= 764726400) OR (813110400 <= e.event_end <= 796176000) OR (845164800 <= e.event_end <= 828230400) OR (876614400 <= e.event_end <= 859680000) OR (908064000 <= e.event_end <= 891129600) OR (939513600 <= e.event_end <= 922579200) OR (970963200 <= e.event_end <= 954028800) OR (1003017600 <= e.event_end <= 985478400) OR (1034467200 <= e.event_end <= 1017532800) OR (1065916800 <= e.event_end <= 1048982400) OR (1097366400 <= e.event_end <= 1080432000) OR (1128816000 <= e.event_end <= 1111881600) OR (1160265600 <= e.event_end <= 1143331200) OR (1192320000 <= e.event_end <= 1174780800) OR (1223769600 <= e.event_end <= 1206835200) OR (1255219200 <= e.event_end <= 1238284800) OR (1286668800 <= e.event_end <= 1269734400), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((24451200 <= e.event_start <= 7516800) OR (55900800 <= e.event_start <= 38966400) OR (87350400 <= e.event_start <= 70416000) OR (119404800 <= e.event_start <= 101865600) OR (150854400 <= e.event_start <= 133920000) OR (182304000 <= e.event_start <= 165369600) OR (213753600 <= e.event_start <= 196819200) OR (245203200 <= e.event_start <= 228268800) OR (276652800 <= e.event_start <= 259718400) OR (308707200 <= e.event_start <= 291168000) OR (340156800 <= e.event_start <= 323222400) OR (371606400 <= e.event_start <= 354672000) OR (403056000 <= e.event_start <= 386121600) OR (434505600 <= e.event_start <= 417571200) OR (466560000 <= e.event_start <= 449020800) OR (498009600 <= e.event_start <= 481075200) OR (529459200 <= e.event_start <= 512524800) OR (560908800 <= e.event_start <= 543974400) OR (592358400 <= e.event_start <= 575424000) OR (623808000 <= e.event_start <= 606873600) OR (655862400 <= e.event_start <= 638323200) OR (687312000 <= e.event_start <= 670377600) OR (718761600 <= e.event_start <= 701827200) OR (750211200 <= e.event_start <= 733276800) OR (781660800 <= e.event_start <= 764726400) OR (813110400 <= e.event_start <= 796176000) OR (845164800 <= e.event_start <= 828230400) OR (876614400 <= e.event_start <= 859680000) OR (908064000 <= e.event_start <= 891129600) OR (939513600 <= e.event_start <= 922579200) OR (970963200 <= e.event_start <= 954028800) OR (1003017600 <= e.event_start <= 985478400) OR (1034467200 <= e.event_start <= 1017532800) OR (1065916800 <= e.event_start <= 1048982400) OR (1097366400 <= e.event_start <= 1080432000) OR (1128816000 <= e.event_start <= 1111881600) OR (1160265600 <= e.event_start <= 1143331200) OR (1192320000 <= e.event_start <= 1174780800) OR (1223769600 <= e.event_start <= 1206835200) OR (1255219200 <= e.event_start <= 1238284800) OR (1286668800 <= e.event_start <= 1269734400), 1, 0), IF((24451200 <= e.event_end <= 7516800) OR (55900800 <= e.event_end <= 38966400) OR (87350400 <= e.event_end <= 70416000) OR (119404800 <= e.event_end <= 101865600) OR (150854400 <= e.event_end <= 133920000) OR (182304000 <= e.event_end <= 165369600) OR (213753600 <= e.event_end <= 196819200) OR (245203200 <= e.event_end <= 228268800) OR (276652800 <= e.event_end <= 259718400) OR (308707200 <= e.event_end <= 291168000) OR (340156800 <= e.event_end <= 323222400) OR (371606400 <= e.event_end <= 354672000) OR (403056000 <= e.event_end <= 386121600) OR (434505600 <= e.event_end <= 417571200) OR (466560000 <= e.event_end <= 449020800) OR (498009600 <= e.event_end <= 481075200) OR (529459200 <= e.event_end <= 512524800) OR (560908800 <= e.event_end <= 543974400) OR (592358400 <= e.event_end <= 575424000) OR (623808000 <= e.event_end <= 606873600) OR (655862400 <= e.event_end <= 638323200) OR (687312000 <= e.event_end <= 670377600) OR (718761600 <= e.event_end <= 701827200) OR (750211200 <= e.event_end <= 733276800) OR (781660800 <= e.event_end <= 764726400) OR (813110400 <= e.event_end <= 796176000) OR (845164800 <= e.event_end <= 828230400) OR (876614400 <= e.event_end <= 859680000) OR (908064000 <= e.event_end <= 891129600) OR (939513600 <= e.event_end <= 922579200) OR (970963200 <= e.event_end <= 954028800) OR (1003017600 <= e.event_end <= 985478400) OR (1034467200 <= e.event_end <= 1017532800) OR (1065916800 <= e.event_end <= 1048982400) OR (1097366400 <= e.event_end <= 1080432000) OR (1128816000 <= e.event_end <= 1111881600) OR (1160265600 <= e.event_end <= 1143331200) OR (1192320000 <= e.event_end <= 1174780800) OR (1223769600 <= e.event_end <= 1206835200) OR (1255219200 <= e.event_end <= 1238284800) OR (1286668800 <= e.event_end <= 1269734400), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 10
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((24451200 <= e.event_start <= 6912000) OR (55900800 <= e.event_start <= 38966400) OR (87350400 <= e.event_start <= 70416000) OR (119404800 <= e.event_start <= 101865600) OR (150854400 <= e.event_start <= 133315200) OR (182304000 <= e.event_start <= 164764800) OR (213753600 <= e.event_start <= 196819200) OR (245203200 <= e.event_start <= 228268800) OR (276652800 <= e.event_start <= 259718400) OR (308707200 <= e.event_start <= 291168000) OR (340156800 <= e.event_start <= 322617600) OR (371606400 <= e.event_start <= 354067200) OR (403056000 <= e.event_start <= 386121600) OR (434505600 <= e.event_start <= 417571200) OR (466560000 <= e.event_start <= 449020800) OR (498009600 <= e.event_start <= 480470400) OR (529459200 <= e.event_start <= 511920000) OR (560908800 <= e.event_start <= 543369600) OR (592358400 <= e.event_start <= 575424000) OR (623808000 <= e.event_start <= 606873600) OR (655862400 <= e.event_start <= 638323200) OR (687312000 <= e.event_start <= 669772800) OR (718761600 <= e.event_start <= 701222400) OR (750211200 <= e.event_start <= 733276800) OR (781660800 <= e.event_start <= 764726400) OR (813110400 <= e.event_start <= 796176000) OR (845164800 <= e.event_start <= 827625600) OR (876614400 <= e.event_start <= 859075200) OR (908064000 <= e.event_start <= 890524800) OR (939513600 <= e.event_start <= 922579200) OR (970963200 <= e.event_start <= 954028800) OR (1003017600 <= e.event_start <= 985478400) OR (1034467200 <= e.event_start <= 1016928000) OR (1065916800 <= e.event_start <= 1048377600) OR (1097366400 <= e.event_start <= 1080432000) OR (1128816000 <= e.event_start <= 1111881600) OR (1160265600 <= e.event_start <= 1143331200) OR (1192320000 <= e.event_start <= 1174780800) OR (1223769600 <= e.event_start <= 1206230400) OR (1255219200 <= e.event_start <= 1237680000) OR (1286668800 <= e.event_start <= 1269734400), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((24451200 <= e.event_end <= 6912000) OR (55900800 <= e.event_end <= 38966400) OR (87350400 <= e.event_end <= 70416000) OR (119404800 <= e.event_end <= 101865600) OR (150854400 <= e.event_end <= 133315200) OR (182304000 <= e.event_end <= 164764800) OR (213753600 <= e.event_end <= 196819200) OR (245203200 <= e.event_end <= 228268800) OR (276652800 <= e.event_end <= 259718400) OR (308707200 <= e.event_end <= 291168000) OR (340156800 <= e.event_end <= 322617600) OR (371606400 <= e.event_end <= 354067200) OR (403056000 <= e.event_end <= 386121600) OR (434505600 <= e.event_end <= 417571200) OR (466560000 <= e.event_end <= 449020800) OR (498009600 <= e.event_end <= 480470400) OR (529459200 <= e.event_end <= 511920000) OR (560908800 <= e.event_end <= 543369600) OR (592358400 <= e.event_end <= 575424000) OR (623808000 <= e.event_end <= 606873600) OR (655862400 <= e.event_end <= 638323200) OR (687312000 <= e.event_end <= 669772800) OR (718761600 <= e.event_end <= 701222400) OR (750211200 <= e.event_end <= 733276800) OR (781660800 <= e.event_end <= 764726400) OR (813110400 <= e.event_end <= 796176000) OR (845164800 <= e.event_end <= 827625600) OR (876614400 <= e.event_end <= 859075200) OR (908064000 <= e.event_end <= 890524800) OR (939513600 <= e.event_end <= 922579200) OR (970963200 <= e.event_end <= 954028800) OR (1003017600 <= e.event_end <= 985478400) OR (1034467200 <= e.event_end <= 1016928000) OR (1065916800 <= e.event_end <= 1048377600) OR (1097366400 <= e.event_end <= 1080432000) OR (1128816000 <= e.event_end <= 1111881600) OR (1160265600 <= e.event_end <= 1143331200) OR (1192320000 <= e.event_end <= 1174780800) OR (1223769600 <= e.event_end <= 1206230400) OR (1255219200 <= e.event_end <= 1237680000) OR (1286668800 <= e.event_end <= 1269734400), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((24451200 <= e.event_start <= 6912000) OR (55900800 <= e.event_start <= 38966400) OR (87350400 <= e.event_start <= 70416000) OR (119404800 <= e.event_start <= 101865600) OR (150854400 <= e.event_start <= 133315200) OR (182304000 <= e.event_start <= 164764800) OR (213753600 <= e.event_start <= 196819200) OR (245203200 <= e.event_start <= 228268800) OR (276652800 <= e.event_start <= 259718400) OR (308707200 <= e.event_start <= 291168000) OR (340156800 <= e.event_start <= 322617600) OR (371606400 <= e.event_start <= 354067200) OR (403056000 <= e.event_start <= 386121600) OR (434505600 <= e.event_start <= 417571200) OR (466560000 <= e.event_start <= 449020800) OR (498009600 <= e.event_start <= 480470400) OR (529459200 <= e.event_start <= 511920000) OR (560908800 <= e.event_start <= 543369600) OR (592358400 <= e.event_start <= 575424000) OR (623808000 <= e.event_start <= 606873600) OR (655862400 <= e.event_start <= 638323200) OR (687312000 <= e.event_start <= 669772800) OR (718761600 <= e.event_start <= 701222400) OR (750211200 <= e.event_start <= 733276800) OR (781660800 <= e.event_start <= 764726400) OR (813110400 <= e.event_start <= 796176000) OR (845164800 <= e.event_start <= 827625600) OR (876614400 <= e.event_start <= 859075200) OR (908064000 <= e.event_start <= 890524800) OR (939513600 <= e.event_start <= 922579200) OR (970963200 <= e.event_start <= 954028800) OR (1003017600 <= e.event_start <= 985478400) OR (1034467200 <= e.event_start <= 1016928000) OR (1065916800 <= e.event_start <= 1048377600) OR (1097366400 <= e.event_start <= 1080432000) OR (1128816000 <= e.event_start <= 1111881600) OR (1160265600 <= e.event_start <= 1143331200) OR (1192320000 <= e.event_start <= 1174780800) OR (1223769600 <= e.event_start <= 1206230400) OR (1255219200 <= e.event_start <= 1237680000) OR (1286668800 <= e.event_start <= 1269734400), 1, 0), IF((24451200 <= e.event_end <= 6912000) OR (55900800 <= e.event_end <= 38966400) OR (87350400 <= e.event_end <= 70416000) OR (119404800 <= e.event_end <= 101865600) OR (150854400 <= e.event_end <= 133315200) OR (182304000 <= e.event_end <= 164764800) OR (213753600 <= e.event_end <= 196819200) OR (245203200 <= e.event_end <= 228268800) OR (276652800 <= e.event_end <= 259718400) OR (308707200 <= e.event_end <= 291168000) OR (340156800 <= e.event_end <= 322617600) OR (371606400 <= e.event_end <= 354067200) OR (403056000 <= e.event_end <= 386121600) OR (434505600 <= e.event_end <= 417571200) OR (466560000 <= e.event_end <= 449020800) OR (498009600 <= e.event_end <= 480470400) OR (529459200 <= e.event_end <= 511920000) OR (560908800 <= e.event_end <= 543369600) OR (592358400 <= e.event_end <= 575424000) OR (623808000 <= e.event_end <= 606873600) OR (655862400 <= e.event_end <= 638323200) OR (687312000 <= e.event_end <= 669772800) OR (718761600 <= e.event_end <= 701222400) OR (750211200 <= e.event_end <= 733276800) OR (781660800 <= e.event_end <= 764726400) OR (813110400 <= e.event_end <= 796176000) OR (845164800 <= e.event_end <= 827625600) OR (876614400 <= e.event_end <= 859075200) OR (908064000 <= e.event_end <= 890524800) OR (939513600 <= e.event_end <= 922579200) OR (970963200 <= e.event_end <= 954028800) OR (1003017600 <= e.event_end <= 985478400) OR (1034467200 <= e.event_end <= 1016928000) OR (1065916800 <= e.event_end <= 1048377600) OR (1097366400 <= e.event_end <= 1080432000) OR (1128816000 <= e.event_end <= 1111881600) OR (1160265600 <= e.event_end <= 1143331200) OR (1192320000 <= e.event_end <= 1174780800) OR (1223769600 <= e.event_end <= 1206230400) OR (1255219200 <= e.event_end <= 1237680000) OR (1286668800 <= e.event_end <= 1269734400), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 11
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((26870400 <= e.event_start <= 2073600) OR (58924800 <= e.event_start <= 34128000) OR (90374400 <= e.event_start <= 65577600) OR (121824000 <= e.event_start <= 97027200) OR (153273600 <= e.event_start <= 128476800) OR (184723200 <= e.event_start <= 159926400) OR (216777600 <= e.event_start <= 191376000) OR (248227200 <= e.event_start <= 223430400) OR (279676800 <= e.event_start <= 254880000) OR (311126400 <= e.event_start <= 286329600) OR (342576000 <= e.event_start <= 317779200) OR (374025600 <= e.event_start <= 349228800) OR (406080000 <= e.event_start <= 381283200) OR (437529600 <= e.event_start <= 412732800) OR (468979200 <= e.event_start <= 444182400) OR (500428800 <= e.event_start <= 475632000) OR (531878400 <= e.event_start <= 507081600) OR (563328000 <= e.event_start <= 538531200) OR (595382400 <= e.event_start <= 570585600) OR (626832000 <= e.event_start <= 602035200) OR (658281600 <= e.event_start <= 633484800) OR (689731200 <= e.event_start <= 664934400) OR (721180800 <= e.event_start <= 696384000) OR (753235200 <= e.event_start <= 728438400) OR (784684800 <= e.event_start <= 759888000) OR (816134400 <= e.event_start <= 791337600) OR (847584000 <= e.event_start <= 822787200) OR (879033600 <= e.event_start <= 854236800) OR (910483200 <= e.event_start <= 885686400) OR (942537600 <= e.event_start <= 917740800) OR (973987200 <= e.event_start <= 949190400) OR (1005436800 <= e.event_start <= 980640000) OR (1036886400 <= e.event_start <= 1012089600) OR (1068336000 <= e.event_start <= 1043539200) OR (1100390400 <= e.event_start <= 1074988800) OR (1131840000 <= e.event_start <= 1107043200) OR (1163289600 <= e.event_start <= 1138492800) OR (1194739200 <= e.event_start <= 1169942400) OR (1226188800 <= e.event_start <= 1201392000) OR (1257638400 <= e.event_start <= 1232841600) OR (1289692800 <= e.event_start <= 1264896000), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((26870400 <= e.event_end <= 2073600) OR (58924800 <= e.event_end <= 34128000) OR (90374400 <= e.event_end <= 65577600) OR (121824000 <= e.event_end <= 97027200) OR (153273600 <= e.event_end <= 128476800) OR (184723200 <= e.event_end <= 159926400) OR (216777600 <= e.event_end <= 191376000) OR (248227200 <= e.event_end <= 223430400) OR (279676800 <= e.event_end <= 254880000) OR (311126400 <= e.event_end <= 286329600) OR (342576000 <= e.event_end <= 317779200) OR (374025600 <= e.event_end <= 349228800) OR (406080000 <= e.event_end <= 381283200) OR (437529600 <= e.event_end <= 412732800) OR (468979200 <= e.event_end <= 444182400) OR (500428800 <= e.event_end <= 475632000) OR (531878400 <= e.event_end <= 507081600) OR (563328000 <= e.event_end <= 538531200) OR (595382400 <= e.event_end <= 570585600) OR (626832000 <= e.event_end <= 602035200) OR (658281600 <= e.event_end <= 633484800) OR (689731200 <= e.event_end <= 664934400) OR (721180800 <= e.event_end <= 696384000) OR (753235200 <= e.event_end <= 728438400) OR (784684800 <= e.event_end <= 759888000) OR (816134400 <= e.event_end <= 791337600) OR (847584000 <= e.event_end <= 822787200) OR (879033600 <= e.event_end <= 854236800) OR (910483200 <= e.event_end <= 885686400) OR (942537600 <= e.event_end <= 917740800) OR (973987200 <= e.event_end <= 949190400) OR (1005436800 <= e.event_end <= 980640000) OR (1036886400 <= e.event_end <= 1012089600) OR (1068336000 <= e.event_end <= 1043539200) OR (1100390400 <= e.event_end <= 1074988800) OR (1131840000 <= e.event_end <= 1107043200) OR (1163289600 <= e.event_end <= 1138492800) OR (1194739200 <= e.event_end <= 1169942400) OR (1226188800 <= e.event_end <= 1201392000) OR (1257638400 <= e.event_end <= 1232841600) OR (1289692800 <= e.event_end <= 1264896000), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((26870400 <= e.event_start <= 2073600) OR (58924800 <= e.event_start <= 34128000) OR (90374400 <= e.event_start <= 65577600) OR (121824000 <= e.event_start <= 97027200) OR (153273600 <= e.event_start <= 128476800) OR (184723200 <= e.event_start <= 159926400) OR (216777600 <= e.event_start <= 191376000) OR (248227200 <= e.event_start <= 223430400) OR (279676800 <= e.event_start <= 254880000) OR (311126400 <= e.event_start <= 286329600) OR (342576000 <= e.event_start <= 317779200) OR (374025600 <= e.event_start <= 349228800) OR (406080000 <= e.event_start <= 381283200) OR (437529600 <= e.event_start <= 412732800) OR (468979200 <= e.event_start <= 444182400) OR (500428800 <= e.event_start <= 475632000) OR (531878400 <= e.event_start <= 507081600) OR (563328000 <= e.event_start <= 538531200) OR (595382400 <= e.event_start <= 570585600) OR (626832000 <= e.event_start <= 602035200) OR (658281600 <= e.event_start <= 633484800) OR (689731200 <= e.event_start <= 664934400) OR (721180800 <= e.event_start <= 696384000) OR (753235200 <= e.event_start <= 728438400) OR (784684800 <= e.event_start <= 759888000) OR (816134400 <= e.event_start <= 791337600) OR (847584000 <= e.event_start <= 822787200) OR (879033600 <= e.event_start <= 854236800) OR (910483200 <= e.event_start <= 885686400) OR (942537600 <= e.event_start <= 917740800) OR (973987200 <= e.event_start <= 949190400) OR (1005436800 <= e.event_start <= 980640000) OR (1036886400 <= e.event_start <= 1012089600) OR (1068336000 <= e.event_start <= 1043539200) OR (1100390400 <= e.event_start <= 1074988800) OR (1131840000 <= e.event_start <= 1107043200) OR (1163289600 <= e.event_start <= 1138492800) OR (1194739200 <= e.event_start <= 1169942400) OR (1226188800 <= e.event_start <= 1201392000) OR (1257638400 <= e.event_start <= 1232841600) OR (1289692800 <= e.event_start <= 1264896000), 1, 0), IF((26870400 <= e.event_end <= 2073600) OR (58924800 <= e.event_end <= 34128000) OR (90374400 <= e.event_end <= 65577600) OR (121824000 <= e.event_end <= 97027200) OR (153273600 <= e.event_end <= 128476800) OR (184723200 <= e.event_end <= 159926400) OR (216777600 <= e.event_end <= 191376000) OR (248227200 <= e.event_end <= 223430400) OR (279676800 <= e.event_end <= 254880000) OR (311126400 <= e.event_end <= 286329600) OR (342576000 <= e.event_end <= 317779200) OR (374025600 <= e.event_end <= 349228800) OR (406080000 <= e.event_end <= 381283200) OR (437529600 <= e.event_end <= 412732800) OR (468979200 <= e.event_end <= 444182400) OR (500428800 <= e.event_end <= 475632000) OR (531878400 <= e.event_end <= 507081600) OR (563328000 <= e.event_end <= 538531200) OR (595382400 <= e.event_end <= 570585600) OR (626832000 <= e.event_end <= 602035200) OR (658281600 <= e.event_end <= 633484800) OR (689731200 <= e.event_end <= 664934400) OR (721180800 <= e.event_end <= 696384000) OR (753235200 <= e.event_end <= 728438400) OR (784684800 <= e.event_end <= 759888000) OR (816134400 <= e.event_end <= 791337600) OR (847584000 <= e.event_end <= 822787200) OR (879033600 <= e.event_end <= 854236800) OR (910483200 <= e.event_end <= 885686400) OR (942537600 <= e.event_end <= 917740800) OR (973987200 <= e.event_end <= 949190400) OR (1005436800 <= e.event_end <= 980640000) OR (1036886400 <= e.event_end <= 1012089600) OR (1068336000 <= e.event_end <= 1043539200) OR (1100390400 <= e.event_end <= 1074988800) OR (1131840000 <= e.event_end <= 1107043200) OR (1163289600 <= e.event_end <= 1138492800) OR (1194739200 <= e.event_end <= 1169942400) OR (1226188800 <= e.event_end <= 1201392000) OR (1257638400 <= e.event_end <= 1232841600) OR (1289692800 <= e.event_end <= 1264896000), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 12
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7520400 <= e.event_start <= 25664400) OR (38970000 <= e.event_start <= 57718800) OR (70419600 <= e.event_start <= 89168400) OR (101869200 <= e.event_start <= 120618000) OR (133923600 <= e.event_start <= 152067600) OR (165373200 <= e.event_start <= 183517200) OR (196822800 <= e.event_start <= 215571600) OR (228272400 <= e.event_start <= 247021200) OR (259722000 <= e.event_start <= 278470800) OR (291171600 <= e.event_start <= 309920400) OR (323226000 <= e.event_start <= 341370000) OR (354675600 <= e.event_start <= 372819600) OR (386125200 <= e.event_start <= 404874000) OR (417574800 <= e.event_start <= 436323600) OR (449024400 <= e.event_start <= 467773200) OR (481078800 <= e.event_start <= 499222800) OR (512528400 <= e.event_start <= 530672400) OR (543978000 <= e.event_start <= 562122000) OR (575427600 <= e.event_start <= 594176400) OR (606877200 <= e.event_start <= 625626000) OR (638326800 <= e.event_start <= 657075600) OR (670381200 <= e.event_start <= 688525200) OR (701830800 <= e.event_start <= 719974800) OR (733280400 <= e.event_start <= 752029200) OR (764730000 <= e.event_start <= 783478800) OR (796179600 <= e.event_start <= 814928400) OR (828234000 <= e.event_start <= 846378000) OR (859683600 <= e.event_start <= 877827600) OR (891133200 <= e.event_start <= 909277200) OR (922582800 <= e.event_start <= 941331600) OR (954032400 <= e.event_start <= 972781200) OR (985482000 <= e.event_start <= 1004230800) OR (1017536400 <= e.event_start <= 1035680400) OR (1048986000 <= e.event_start <= 1067130000) OR (1080435600 <= e.event_start <= 1099184400) OR (1111885200 <= e.event_start <= 1130634000) OR (1143334800 <= e.event_start <= 1162083600) OR (1174784400 <= e.event_start <= 1193533200) OR (1206838800 <= e.event_start <= 1224982800) OR (1238288400 <= e.event_start <= 1256432400) OR (1269738000 <= e.event_start <= 1288486800), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7520400 <= e.event_end <= 25664400) OR (38970000 <= e.event_end <= 57718800) OR (70419600 <= e.event_end <= 89168400) OR (101869200 <= e.event_end <= 120618000) OR (133923600 <= e.event_end <= 152067600) OR (165373200 <= e.event_end <= 183517200) OR (196822800 <= e.event_end <= 215571600) OR (228272400 <= e.event_end <= 247021200) OR (259722000 <= e.event_end <= 278470800) OR (291171600 <= e.event_end <= 309920400) OR (323226000 <= e.event_end <= 341370000) OR (354675600 <= e.event_end <= 372819600) OR (386125200 <= e.event_end <= 404874000) OR (417574800 <= e.event_end <= 436323600) OR (449024400 <= e.event_end <= 467773200) OR (481078800 <= e.event_end <= 499222800) OR (512528400 <= e.event_end <= 530672400) OR (543978000 <= e.event_end <= 562122000) OR (575427600 <= e.event_end <= 594176400) OR (606877200 <= e.event_end <= 625626000) OR (638326800 <= e.event_end <= 657075600) OR (670381200 <= e.event_end <= 688525200) OR (701830800 <= e.event_end <= 719974800) OR (733280400 <= e.event_end <= 752029200) OR (764730000 <= e.event_end <= 783478800) OR (796179600 <= e.event_end <= 814928400) OR (828234000 <= e.event_end <= 846378000) OR (859683600 <= e.event_end <= 877827600) OR (891133200 <= e.event_end <= 909277200) OR (922582800 <= e.event_end <= 941331600) OR (954032400 <= e.event_end <= 972781200) OR (985482000 <= e.event_end <= 1004230800) OR (1017536400 <= e.event_end <= 1035680400) OR (1048986000 <= e.event_end <= 1067130000) OR (1080435600 <= e.event_end <= 1099184400) OR (1111885200 <= e.event_end <= 1130634000) OR (1143334800 <= e.event_end <= 1162083600) OR (1174784400 <= e.event_end <= 1193533200) OR (1206838800 <= e.event_end <= 1224982800) OR (1238288400 <= e.event_end <= 1256432400) OR (1269738000 <= e.event_end <= 1288486800), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7520400 <= e.event_start <= 25664400) OR (38970000 <= e.event_start <= 57718800) OR (70419600 <= e.event_start <= 89168400) OR (101869200 <= e.event_start <= 120618000) OR (133923600 <= e.event_start <= 152067600) OR (165373200 <= e.event_start <= 183517200) OR (196822800 <= e.event_start <= 215571600) OR (228272400 <= e.event_start <= 247021200) OR (259722000 <= e.event_start <= 278470800) OR (291171600 <= e.event_start <= 309920400) OR (323226000 <= e.event_start <= 341370000) OR (354675600 <= e.event_start <= 372819600) OR (386125200 <= e.event_start <= 404874000) OR (417574800 <= e.event_start <= 436323600) OR (449024400 <= e.event_start <= 467773200) OR (481078800 <= e.event_start <= 499222800) OR (512528400 <= e.event_start <= 530672400) OR (543978000 <= e.event_start <= 562122000) OR (575427600 <= e.event_start <= 594176400) OR (606877200 <= e.event_start <= 625626000) OR (638326800 <= e.event_start <= 657075600) OR (670381200 <= e.event_start <= 688525200) OR (701830800 <= e.event_start <= 719974800) OR (733280400 <= e.event_start <= 752029200) OR (764730000 <= e.event_start <= 783478800) OR (796179600 <= e.event_start <= 814928400) OR (828234000 <= e.event_start <= 846378000) OR (859683600 <= e.event_start <= 877827600) OR (891133200 <= e.event_start <= 909277200) OR (922582800 <= e.event_start <= 941331600) OR (954032400 <= e.event_start <= 972781200) OR (985482000 <= e.event_start <= 1004230800) OR (1017536400 <= e.event_start <= 1035680400) OR (1048986000 <= e.event_start <= 1067130000) OR (1080435600 <= e.event_start <= 1099184400) OR (1111885200 <= e.event_start <= 1130634000) OR (1143334800 <= e.event_start <= 1162083600) OR (1174784400 <= e.event_start <= 1193533200) OR (1206838800 <= e.event_start <= 1224982800) OR (1238288400 <= e.event_start <= 1256432400) OR (1269738000 <= e.event_start <= 1288486800), 1, 0), IF((7520400 <= e.event_end <= 25664400) OR (38970000 <= e.event_end <= 57718800) OR (70419600 <= e.event_end <= 89168400) OR (101869200 <= e.event_end <= 120618000) OR (133923600 <= e.event_end <= 152067600) OR (165373200 <= e.event_end <= 183517200) OR (196822800 <= e.event_end <= 215571600) OR (228272400 <= e.event_end <= 247021200) OR (259722000 <= e.event_end <= 278470800) OR (291171600 <= e.event_end <= 309920400) OR (323226000 <= e.event_end <= 341370000) OR (354675600 <= e.event_end <= 372819600) OR (386125200 <= e.event_end <= 404874000) OR (417574800 <= e.event_end <= 436323600) OR (449024400 <= e.event_end <= 467773200) OR (481078800 <= e.event_end <= 499222800) OR (512528400 <= e.event_end <= 530672400) OR (543978000 <= e.event_end <= 562122000) OR (575427600 <= e.event_end <= 594176400) OR (606877200 <= e.event_end <= 625626000) OR (638326800 <= e.event_end <= 657075600) OR (670381200 <= e.event_end <= 688525200) OR (701830800 <= e.event_end <= 719974800) OR (733280400 <= e.event_end <= 752029200) OR (764730000 <= e.event_end <= 783478800) OR (796179600 <= e.event_end <= 814928400) OR (828234000 <= e.event_end <= 846378000) OR (859683600 <= e.event_end <= 877827600) OR (891133200 <= e.event_end <= 909277200) OR (922582800 <= e.event_end <= 941331600) OR (954032400 <= e.event_end <= 972781200) OR (985482000 <= e.event_end <= 1004230800) OR (1017536400 <= e.event_end <= 1035680400) OR (1048986000 <= e.event_end <= 1067130000) OR (1080435600 <= e.event_end <= 1099184400) OR (1111885200 <= e.event_end <= 1130634000) OR (1143334800 <= e.event_end <= 1162083600) OR (1174784400 <= e.event_end <= 1193533200) OR (1206838800 <= e.event_end <= 1224982800) OR (1238288400 <= e.event_end <= 1256432400) OR (1269738000 <= e.event_end <= 1288486800), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 13
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7524000 <= e.event_start <= 25668000) OR (38973600 <= e.event_start <= 57722400) OR (70423200 <= e.event_start <= 89172000) OR (101872800 <= e.event_start <= 120621600) OR (133927200 <= e.event_start <= 152071200) OR (165376800 <= e.event_start <= 183520800) OR (196826400 <= e.event_start <= 215575200) OR (228276000 <= e.event_start <= 247024800) OR (259725600 <= e.event_start <= 278474400) OR (291175200 <= e.event_start <= 309924000) OR (323229600 <= e.event_start <= 341373600) OR (354679200 <= e.event_start <= 372823200) OR (386128800 <= e.event_start <= 404877600) OR (417578400 <= e.event_start <= 436327200) OR (449028000 <= e.event_start <= 467776800) OR (481082400 <= e.event_start <= 499226400) OR (512532000 <= e.event_start <= 530676000) OR (543981600 <= e.event_start <= 562125600) OR (575431200 <= e.event_start <= 594180000) OR (606880800 <= e.event_start <= 625629600) OR (638330400 <= e.event_start <= 657079200) OR (670384800 <= e.event_start <= 688528800) OR (701834400 <= e.event_start <= 719978400) OR (733284000 <= e.event_start <= 752032800) OR (764733600 <= e.event_start <= 783482400) OR (796183200 <= e.event_start <= 814932000) OR (828237600 <= e.event_start <= 846381600) OR (859687200 <= e.event_start <= 877831200) OR (891136800 <= e.event_start <= 909280800) OR (922586400 <= e.event_start <= 941335200) OR (954036000 <= e.event_start <= 972784800) OR (985485600 <= e.event_start <= 1004234400) OR (1017540000 <= e.event_start <= 1035684000) OR (1048989600 <= e.event_start <= 1067133600) OR (1080439200 <= e.event_start <= 1099188000) OR (1111888800 <= e.event_start <= 1130637600) OR (1143338400 <= e.event_start <= 1162087200) OR (1174788000 <= e.event_start <= 1193536800) OR (1206842400 <= e.event_start <= 1224986400) OR (1238292000 <= e.event_start <= 1256436000) OR (1269741600 <= e.event_start <= 1288490400), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7524000 <= e.event_end <= 25668000) OR (38973600 <= e.event_end <= 57722400) OR (70423200 <= e.event_end <= 89172000) OR (101872800 <= e.event_end <= 120621600) OR (133927200 <= e.event_end <= 152071200) OR (165376800 <= e.event_end <= 183520800) OR (196826400 <= e.event_end <= 215575200) OR (228276000 <= e.event_end <= 247024800) OR (259725600 <= e.event_end <= 278474400) OR (291175200 <= e.event_end <= 309924000) OR (323229600 <= e.event_end <= 341373600) OR (354679200 <= e.event_end <= 372823200) OR (386128800 <= e.event_end <= 404877600) OR (417578400 <= e.event_end <= 436327200) OR (449028000 <= e.event_end <= 467776800) OR (481082400 <= e.event_end <= 499226400) OR (512532000 <= e.event_end <= 530676000) OR (543981600 <= e.event_end <= 562125600) OR (575431200 <= e.event_end <= 594180000) OR (606880800 <= e.event_end <= 625629600) OR (638330400 <= e.event_end <= 657079200) OR (670384800 <= e.event_end <= 688528800) OR (701834400 <= e.event_end <= 719978400) OR (733284000 <= e.event_end <= 752032800) OR (764733600 <= e.event_end <= 783482400) OR (796183200 <= e.event_end <= 814932000) OR (828237600 <= e.event_end <= 846381600) OR (859687200 <= e.event_end <= 877831200) OR (891136800 <= e.event_end <= 909280800) OR (922586400 <= e.event_end <= 941335200) OR (954036000 <= e.event_end <= 972784800) OR (985485600 <= e.event_end <= 1004234400) OR (1017540000 <= e.event_end <= 1035684000) OR (1048989600 <= e.event_end <= 1067133600) OR (1080439200 <= e.event_end <= 1099188000) OR (1111888800 <= e.event_end <= 1130637600) OR (1143338400 <= e.event_end <= 1162087200) OR (1174788000 <= e.event_end <= 1193536800) OR (1206842400 <= e.event_end <= 1224986400) OR (1238292000 <= e.event_end <= 1256436000) OR (1269741600 <= e.event_end <= 1288490400), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7524000 <= e.event_start <= 25668000) OR (38973600 <= e.event_start <= 57722400) OR (70423200 <= e.event_start <= 89172000) OR (101872800 <= e.event_start <= 120621600) OR (133927200 <= e.event_start <= 152071200) OR (165376800 <= e.event_start <= 183520800) OR (196826400 <= e.event_start <= 215575200) OR (228276000 <= e.event_start <= 247024800) OR (259725600 <= e.event_start <= 278474400) OR (291175200 <= e.event_start <= 309924000) OR (323229600 <= e.event_start <= 341373600) OR (354679200 <= e.event_start <= 372823200) OR (386128800 <= e.event_start <= 404877600) OR (417578400 <= e.event_start <= 436327200) OR (449028000 <= e.event_start <= 467776800) OR (481082400 <= e.event_start <= 499226400) OR (512532000 <= e.event_start <= 530676000) OR (543981600 <= e.event_start <= 562125600) OR (575431200 <= e.event_start <= 594180000) OR (606880800 <= e.event_start <= 625629600) OR (638330400 <= e.event_start <= 657079200) OR (670384800 <= e.event_start <= 688528800) OR (701834400 <= e.event_start <= 719978400) OR (733284000 <= e.event_start <= 752032800) OR (764733600 <= e.event_start <= 783482400) OR (796183200 <= e.event_start <= 814932000) OR (828237600 <= e.event_start <= 846381600) OR (859687200 <= e.event_start <= 877831200) OR (891136800 <= e.event_start <= 909280800) OR (922586400 <= e.event_start <= 941335200) OR (954036000 <= e.event_start <= 972784800) OR (985485600 <= e.event_start <= 1004234400) OR (1017540000 <= e.event_start <= 1035684000) OR (1048989600 <= e.event_start <= 1067133600) OR (1080439200 <= e.event_start <= 1099188000) OR (1111888800 <= e.event_start <= 1130637600) OR (1143338400 <= e.event_start <= 1162087200) OR (1174788000 <= e.event_start <= 1193536800) OR (1206842400 <= e.event_start <= 1224986400) OR (1238292000 <= e.event_start <= 1256436000) OR (1269741600 <= e.event_start <= 1288490400), 1, 0), IF((7524000 <= e.event_end <= 25668000) OR (38973600 <= e.event_end <= 57722400) OR (70423200 <= e.event_end <= 89172000) OR (101872800 <= e.event_end <= 120621600) OR (133927200 <= e.event_end <= 152071200) OR (165376800 <= e.event_end <= 183520800) OR (196826400 <= e.event_end <= 215575200) OR (228276000 <= e.event_end <= 247024800) OR (259725600 <= e.event_end <= 278474400) OR (291175200 <= e.event_end <= 309924000) OR (323229600 <= e.event_end <= 341373600) OR (354679200 <= e.event_end <= 372823200) OR (386128800 <= e.event_end <= 404877600) OR (417578400 <= e.event_end <= 436327200) OR (449028000 <= e.event_end <= 467776800) OR (481082400 <= e.event_end <= 499226400) OR (512532000 <= e.event_end <= 530676000) OR (543981600 <= e.event_end <= 562125600) OR (575431200 <= e.event_end <= 594180000) OR (606880800 <= e.event_end <= 625629600) OR (638330400 <= e.event_end <= 657079200) OR (670384800 <= e.event_end <= 688528800) OR (701834400 <= e.event_end <= 719978400) OR (733284000 <= e.event_end <= 752032800) OR (764733600 <= e.event_end <= 783482400) OR (796183200 <= e.event_end <= 814932000) OR (828237600 <= e.event_end <= 846381600) OR (859687200 <= e.event_end <= 877831200) OR (891136800 <= e.event_end <= 909280800) OR (922586400 <= e.event_end <= 941335200) OR (954036000 <= e.event_end <= 972784800) OR (985485600 <= e.event_end <= 1004234400) OR (1017540000 <= e.event_end <= 1035684000) OR (1048989600 <= e.event_end <= 1067133600) OR (1080439200 <= e.event_end <= 1099188000) OR (1111888800 <= e.event_end <= 1130637600) OR (1143338400 <= e.event_end <= 1162087200) OR (1174788000 <= e.event_end <= 1193536800) OR (1206842400 <= e.event_end <= 1224986400) OR (1238292000 <= e.event_end <= 1256436000) OR (1269741600 <= e.event_end <= 1288490400), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 14
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((8128800 <= e.event_start <= 25668000) OR (39578400 <= e.event_start <= 57722400) OR (71028000 <= e.event_start <= 89172000) OR (102477600 <= e.event_start <= 120621600) OR (134532000 <= e.event_start <= 152071200) OR (165981600 <= e.event_start <= 183520800) OR (197431200 <= e.event_start <= 215575200) OR (228880800 <= e.event_start <= 247024800) OR (260330400 <= e.event_start <= 278474400) OR (291780000 <= e.event_start <= 309924000) OR (323834400 <= e.event_start <= 341373600) OR (355284000 <= e.event_start <= 372823200) OR (386733600 <= e.event_start <= 404877600) OR (418183200 <= e.event_start <= 436327200) OR (449632800 <= e.event_start <= 467776800) OR (481687200 <= e.event_start <= 499226400) OR (513136800 <= e.event_start <= 530676000) OR (544586400 <= e.event_start <= 562125600) OR (576036000 <= e.event_start <= 594180000) OR (607485600 <= e.event_start <= 625629600) OR (638935200 <= e.event_start <= 657079200) OR (670989600 <= e.event_start <= 688528800) OR (702439200 <= e.event_start <= 719978400) OR (733888800 <= e.event_start <= 752032800) OR (765338400 <= e.event_start <= 783482400) OR (796788000 <= e.event_start <= 814932000) OR (828842400 <= e.event_start <= 846381600) OR (860292000 <= e.event_start <= 877831200) OR (891741600 <= e.event_start <= 909280800) OR (923191200 <= e.event_start <= 941335200) OR (954640800 <= e.event_start <= 972784800) OR (986090400 <= e.event_start <= 1004234400) OR (1018144800 <= e.event_start <= 1035684000) OR (1049594400 <= e.event_start <= 1067133600) OR (1081044000 <= e.event_start <= 1099188000) OR (1112493600 <= e.event_start <= 1130637600) OR (1143943200 <= e.event_start <= 1162087200) OR (1173578400 <= e.event_start <= 1193536800) OR (1205028000 <= e.event_start <= 1224986400) OR (1236477600 <= e.event_start <= 1256436000) OR (1268532000 <= e.event_start <= 1288490400), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((8128800 <= e.event_end <= 25668000) OR (39578400 <= e.event_end <= 57722400) OR (71028000 <= e.event_end <= 89172000) OR (102477600 <= e.event_end <= 120621600) OR (134532000 <= e.event_end <= 152071200) OR (165981600 <= e.event_end <= 183520800) OR (197431200 <= e.event_end <= 215575200) OR (228880800 <= e.event_end <= 247024800) OR (260330400 <= e.event_end <= 278474400) OR (291780000 <= e.event_end <= 309924000) OR (323834400 <= e.event_end <= 341373600) OR (355284000 <= e.event_end <= 372823200) OR (386733600 <= e.event_end <= 404877600) OR (418183200 <= e.event_end <= 436327200) OR (449632800 <= e.event_end <= 467776800) OR (481687200 <= e.event_end <= 499226400) OR (513136800 <= e.event_end <= 530676000) OR (544586400 <= e.event_end <= 562125600) OR (576036000 <= e.event_end <= 594180000) OR (607485600 <= e.event_end <= 625629600) OR (638935200 <= e.event_end <= 657079200) OR (670989600 <= e.event_end <= 688528800) OR (702439200 <= e.event_end <= 719978400) OR (733888800 <= e.event_end <= 752032800) OR (765338400 <= e.event_end <= 783482400) OR (796788000 <= e.event_end <= 814932000) OR (828842400 <= e.event_end <= 846381600) OR (860292000 <= e.event_end <= 877831200) OR (891741600 <= e.event_end <= 909280800) OR (923191200 <= e.event_end <= 941335200) OR (954640800 <= e.event_end <= 972784800) OR (986090400 <= e.event_end <= 1004234400) OR (1018144800 <= e.event_end <= 1035684000) OR (1049594400 <= e.event_end <= 1067133600) OR (1081044000 <= e.event_end <= 1099188000) OR (1112493600 <= e.event_end <= 1130637600) OR (1143943200 <= e.event_end <= 1162087200) OR (1173578400 <= e.event_end <= 1193536800) OR (1205028000 <= e.event_end <= 1224986400) OR (1236477600 <= e.event_end <= 1256436000) OR (1268532000 <= e.event_end <= 1288490400), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((8128800 <= e.event_start <= 25668000) OR (39578400 <= e.event_start <= 57722400) OR (71028000 <= e.event_start <= 89172000) OR (102477600 <= e.event_start <= 120621600) OR (134532000 <= e.event_start <= 152071200) OR (165981600 <= e.event_start <= 183520800) OR (197431200 <= e.event_start <= 215575200) OR (228880800 <= e.event_start <= 247024800) OR (260330400 <= e.event_start <= 278474400) OR (291780000 <= e.event_start <= 309924000) OR (323834400 <= e.event_start <= 341373600) OR (355284000 <= e.event_start <= 372823200) OR (386733600 <= e.event_start <= 404877600) OR (418183200 <= e.event_start <= 436327200) OR (449632800 <= e.event_start <= 467776800) OR (481687200 <= e.event_start <= 499226400) OR (513136800 <= e.event_start <= 530676000) OR (544586400 <= e.event_start <= 562125600) OR (576036000 <= e.event_start <= 594180000) OR (607485600 <= e.event_start <= 625629600) OR (638935200 <= e.event_start <= 657079200) OR (670989600 <= e.event_start <= 688528800) OR (702439200 <= e.event_start <= 719978400) OR (733888800 <= e.event_start <= 752032800) OR (765338400 <= e.event_start <= 783482400) OR (796788000 <= e.event_start <= 814932000) OR (828842400 <= e.event_start <= 846381600) OR (860292000 <= e.event_start <= 877831200) OR (891741600 <= e.event_start <= 909280800) OR (923191200 <= e.event_start <= 941335200) OR (954640800 <= e.event_start <= 972784800) OR (986090400 <= e.event_start <= 1004234400) OR (1018144800 <= e.event_start <= 1035684000) OR (1049594400 <= e.event_start <= 1067133600) OR (1081044000 <= e.event_start <= 1099188000) OR (1112493600 <= e.event_start <= 1130637600) OR (1143943200 <= e.event_start <= 1162087200) OR (1173578400 <= e.event_start <= 1193536800) OR (1205028000 <= e.event_start <= 1224986400) OR (1236477600 <= e.event_start <= 1256436000) OR (1268532000 <= e.event_start <= 1288490400), 1, 0), IF((8128800 <= e.event_end <= 25668000) OR (39578400 <= e.event_end <= 57722400) OR (71028000 <= e.event_end <= 89172000) OR (102477600 <= e.event_end <= 120621600) OR (134532000 <= e.event_end <= 152071200) OR (165981600 <= e.event_end <= 183520800) OR (197431200 <= e.event_end <= 215575200) OR (228880800 <= e.event_end <= 247024800) OR (260330400 <= e.event_end <= 278474400) OR (291780000 <= e.event_end <= 309924000) OR (323834400 <= e.event_end <= 341373600) OR (355284000 <= e.event_end <= 372823200) OR (386733600 <= e.event_end <= 404877600) OR (418183200 <= e.event_end <= 436327200) OR (449632800 <= e.event_end <= 467776800) OR (481687200 <= e.event_end <= 499226400) OR (513136800 <= e.event_end <= 530676000) OR (544586400 <= e.event_end <= 562125600) OR (576036000 <= e.event_end <= 594180000) OR (607485600 <= e.event_end <= 625629600) OR (638935200 <= e.event_end <= 657079200) OR (670989600 <= e.event_end <= 688528800) OR (702439200 <= e.event_end <= 719978400) OR (733888800 <= e.event_end <= 752032800) OR (765338400 <= e.event_end <= 783482400) OR (796788000 <= e.event_end <= 814932000) OR (828842400 <= e.event_end <= 846381600) OR (860292000 <= e.event_end <= 877831200) OR (891741600 <= e.event_end <= 909280800) OR (923191200 <= e.event_end <= 941335200) OR (954640800 <= e.event_end <= 972784800) OR (986090400 <= e.event_end <= 1004234400) OR (1018144800 <= e.event_end <= 1035684000) OR (1049594400 <= e.event_end <= 1067133600) OR (1081044000 <= e.event_end <= 1099188000) OR (1112493600 <= e.event_end <= 1130637600) OR (1143943200 <= e.event_end <= 1162087200) OR (1173578400 <= e.event_end <= 1193536800) OR (1205028000 <= e.event_end <= 1224986400) OR (1236477600 <= e.event_end <= 1256436000) OR (1268532000 <= e.event_end <= 1288490400), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 15
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((7776000 <= e.event_start <= 25660800) OR (39312000 <= e.event_start <= 57715200) OR (70934400 <= e.event_start <= 89164800) OR (102470400 <= e.event_start <= 120614400) OR (134006400 <= e.event_start <= 152064000) OR (165542400 <= e.event_start <= 183513600) OR (197164800 <= e.event_start <= 215568000) OR (228700800 <= e.event_start <= 247017600) OR (260236800 <= e.event_start <= 278467200) OR (291772800 <= e.event_start <= 309916800) OR (323395200 <= e.event_start <= 341366400) OR (354931200 <= e.event_start <= 372816000) OR (386467200 <= e.event_start <= 404870400) OR (418003200 <= e.event_start <= 436320000) OR (449625600 <= e.event_start <= 467769600) OR (481161600 <= e.event_start <= 499219200) OR (512697600 <= e.event_start <= 530668800) OR (544233600 <= e.event_start <= 562118400) OR (575856000 <= e.event_start <= 594172800) OR (607392000 <= e.event_start <= 625622400) OR (638928000 <= e.event_start <= 657072000) OR (670464000 <= e.event_start <= 688521600) OR (702086400 <= e.event_start <= 719971200) OR (733622400 <= e.event_start <= 752025600) OR (765158400 <= e.event_start <= 783475200) OR (796694400 <= e.event_start <= 814924800) OR (828316800 <= e.event_start <= 846374400) OR (859852800 <= e.event_start <= 877824000) OR (891388800 <= e.event_start <= 909273600) OR (922924800 <= e.event_start <= 941328000) OR (954547200 <= e.event_start <= 972777600) OR (986083200 <= e.event_start <= 1004227200) OR (1017619200 <= e.event_start <= 1035676800) OR (1049155200 <= e.event_start <= 1067126400) OR (1080777600 <= e.event_start <= 1099180800) OR (1112313600 <= e.event_start <= 1130630400) OR (1143849600 <= e.event_start <= 1162080000) OR (1175385600 <= e.event_start <= 1193529600) OR (1207008000 <= e.event_start <= 1224979200) OR (1238544000 <= e.event_start <= 1256428800) OR (1270080000 <= e.event_start <= 1288483200), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((7776000 <= e.event_end <= 25660800) OR (39312000 <= e.event_end <= 57715200) OR (70934400 <= e.event_end <= 89164800) OR (102470400 <= e.event_end <= 120614400) OR (134006400 <= e.event_end <= 152064000) OR (165542400 <= e.event_end <= 183513600) OR (197164800 <= e.event_end <= 215568000) OR (228700800 <= e.event_end <= 247017600) OR (260236800 <= e.event_end <= 278467200) OR (291772800 <= e.event_end <= 309916800) OR (323395200 <= e.event_end <= 341366400) OR (354931200 <= e.event_end <= 372816000) OR (386467200 <= e.event_end <= 404870400) OR (418003200 <= e.event_end <= 436320000) OR (449625600 <= e.event_end <= 467769600) OR (481161600 <= e.event_end <= 499219200) OR (512697600 <= e.event_end <= 530668800) OR (544233600 <= e.event_end <= 562118400) OR (575856000 <= e.event_end <= 594172800) OR (607392000 <= e.event_end <= 625622400) OR (638928000 <= e.event_end <= 657072000) OR (670464000 <= e.event_end <= 688521600) OR (702086400 <= e.event_end <= 719971200) OR (733622400 <= e.event_end <= 752025600) OR (765158400 <= e.event_end <= 783475200) OR (796694400 <= e.event_end <= 814924800) OR (828316800 <= e.event_end <= 846374400) OR (859852800 <= e.event_end <= 877824000) OR (891388800 <= e.event_end <= 909273600) OR (922924800 <= e.event_end <= 941328000) OR (954547200 <= e.event_end <= 972777600) OR (986083200 <= e.event_end <= 1004227200) OR (1017619200 <= e.event_end <= 1035676800) OR (1049155200 <= e.event_end <= 1067126400) OR (1080777600 <= e.event_end <= 1099180800) OR (1112313600 <= e.event_end <= 1130630400) OR (1143849600 <= e.event_end <= 1162080000) OR (1175385600 <= e.event_end <= 1193529600) OR (1207008000 <= e.event_end <= 1224979200) OR (1238544000 <= e.event_end <= 1256428800) OR (1270080000 <= e.event_end <= 1288483200), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((7776000 <= e.event_start <= 25660800) OR (39312000 <= e.event_start <= 57715200) OR (70934400 <= e.event_start <= 89164800) OR (102470400 <= e.event_start <= 120614400) OR (134006400 <= e.event_start <= 152064000) OR (165542400 <= e.event_start <= 183513600) OR (197164800 <= e.event_start <= 215568000) OR (228700800 <= e.event_start <= 247017600) OR (260236800 <= e.event_start <= 278467200) OR (291772800 <= e.event_start <= 309916800) OR (323395200 <= e.event_start <= 341366400) OR (354931200 <= e.event_start <= 372816000) OR (386467200 <= e.event_start <= 404870400) OR (418003200 <= e.event_start <= 436320000) OR (449625600 <= e.event_start <= 467769600) OR (481161600 <= e.event_start <= 499219200) OR (512697600 <= e.event_start <= 530668800) OR (544233600 <= e.event_start <= 562118400) OR (575856000 <= e.event_start <= 594172800) OR (607392000 <= e.event_start <= 625622400) OR (638928000 <= e.event_start <= 657072000) OR (670464000 <= e.event_start <= 688521600) OR (702086400 <= e.event_start <= 719971200) OR (733622400 <= e.event_start <= 752025600) OR (765158400 <= e.event_start <= 783475200) OR (796694400 <= e.event_start <= 814924800) OR (828316800 <= e.event_start <= 846374400) OR (859852800 <= e.event_start <= 877824000) OR (891388800 <= e.event_start <= 909273600) OR (922924800 <= e.event_start <= 941328000) OR (954547200 <= e.event_start <= 972777600) OR (986083200 <= e.event_start <= 1004227200) OR (1017619200 <= e.event_start <= 1035676800) OR (1049155200 <= e.event_start <= 1067126400) OR (1080777600 <= e.event_start <= 1099180800) OR (1112313600 <= e.event_start <= 1130630400) OR (1143849600 <= e.event_start <= 1162080000) OR (1175385600 <= e.event_start <= 1193529600) OR (1207008000 <= e.event_start <= 1224979200) OR (1238544000 <= e.event_start <= 1256428800) OR (1270080000 <= e.event_start <= 1288483200), 1, 0), IF((7776000 <= e.event_end <= 25660800) OR (39312000 <= e.event_end <= 57715200) OR (70934400 <= e.event_end <= 89164800) OR (102470400 <= e.event_end <= 120614400) OR (134006400 <= e.event_end <= 152064000) OR (165542400 <= e.event_end <= 183513600) OR (197164800 <= e.event_end <= 215568000) OR (228700800 <= e.event_end <= 247017600) OR (260236800 <= e.event_end <= 278467200) OR (291772800 <= e.event_end <= 309916800) OR (323395200 <= e.event_end <= 341366400) OR (354931200 <= e.event_end <= 372816000) OR (386467200 <= e.event_end <= 404870400) OR (418003200 <= e.event_end <= 436320000) OR (449625600 <= e.event_end <= 467769600) OR (481161600 <= e.event_end <= 499219200) OR (512697600 <= e.event_end <= 530668800) OR (544233600 <= e.event_end <= 562118400) OR (575856000 <= e.event_end <= 594172800) OR (607392000 <= e.event_end <= 625622400) OR (638928000 <= e.event_end <= 657072000) OR (670464000 <= e.event_end <= 688521600) OR (702086400 <= e.event_end <= 719971200) OR (733622400 <= e.event_end <= 752025600) OR (765158400 <= e.event_end <= 783475200) OR (796694400 <= e.event_end <= 814924800) OR (828316800 <= e.event_end <= 846374400) OR (859852800 <= e.event_end <= 877824000) OR (891388800 <= e.event_end <= 909273600) OR (922924800 <= e.event_end <= 941328000) OR (954547200 <= e.event_end <= 972777600) OR (986083200 <= e.event_end <= 1004227200) OR (1017619200 <= e.event_end <= 1035676800) OR (1049155200 <= e.event_end <= 1067126400) OR (1080777600 <= e.event_end <= 1099180800) OR (1112313600 <= e.event_end <= 1130630400) OR (1143849600 <= e.event_end <= 1162080000) OR (1175385600 <= e.event_end <= 1193529600) OR (1207008000 <= e.event_end <= 1224979200) OR (1238544000 <= e.event_end <= 1256428800) OR (1270080000 <= e.event_end <= 1288483200), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 16
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((26870400 <= e.event_start <= 4492800) OR (58924800 <= e.event_start <= 36547200) OR (90374400 <= e.event_start <= 67996800) OR (121824000 <= e.event_start <= 99446400) OR (153273600 <= e.event_start <= 130896000) OR (184723200 <= e.event_start <= 162345600) OR (216777600 <= e.event_start <= 193795200) OR (248227200 <= e.event_start <= 225849600) OR (279676800 <= e.event_start <= 257299200) OR (311126400 <= e.event_start <= 288748800) OR (342576000 <= e.event_start <= 320198400) OR (374025600 <= e.event_start <= 351648000) OR (406080000 <= e.event_start <= 383702400) OR (437529600 <= e.event_start <= 415152000) OR (468979200 <= e.event_start <= 446601600) OR (500428800 <= e.event_start <= 478051200) OR (531878400 <= e.event_start <= 509500800) OR (563328000 <= e.event_start <= 540950400) OR (595382400 <= e.event_start <= 573004800) OR (626832000 <= e.event_start <= 604454400) OR (658281600 <= e.event_start <= 635904000) OR (689731200 <= e.event_start <= 667353600) OR (721180800 <= e.event_start <= 698803200) OR (753235200 <= e.event_start <= 730857600) OR (784684800 <= e.event_start <= 762307200) OR (816134400 <= e.event_start <= 793756800) OR (847584000 <= e.event_start <= 825206400) OR (879033600 <= e.event_start <= 856656000) OR (910483200 <= e.event_start <= 888105600) OR (942537600 <= e.event_start <= 920160000) OR (973987200 <= e.event_start <= 951609600) OR (1005436800 <= e.event_start <= 983059200) OR (1036886400 <= e.event_start <= 1014508800) OR (1068336000 <= e.event_start <= 1045958400) OR (1100390400 <= e.event_start <= 1077408000) OR (1131840000 <= e.event_start <= 1109462400) OR (1163289600 <= e.event_start <= 1140912000) OR (1194739200 <= e.event_start <= 1172361600) OR (1226188800 <= e.event_start <= 1203811200) OR (1257638400 <= e.event_start <= 1235260800) OR (1289692800 <= e.event_start <= 1267315200), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((26870400 <= e.event_end <= 4492800) OR (58924800 <= e.event_end <= 36547200) OR (90374400 <= e.event_end <= 67996800) OR (121824000 <= e.event_end <= 99446400) OR (153273600 <= e.event_end <= 130896000) OR (184723200 <= e.event_end <= 162345600) OR (216777600 <= e.event_end <= 193795200) OR (248227200 <= e.event_end <= 225849600) OR (279676800 <= e.event_end <= 257299200) OR (311126400 <= e.event_end <= 288748800) OR (342576000 <= e.event_end <= 320198400) OR (374025600 <= e.event_end <= 351648000) OR (406080000 <= e.event_end <= 383702400) OR (437529600 <= e.event_end <= 415152000) OR (468979200 <= e.event_end <= 446601600) OR (500428800 <= e.event_end <= 478051200) OR (531878400 <= e.event_end <= 509500800) OR (563328000 <= e.event_end <= 540950400) OR (595382400 <= e.event_end <= 573004800) OR (626832000 <= e.event_end <= 604454400) OR (658281600 <= e.event_end <= 635904000) OR (689731200 <= e.event_end <= 667353600) OR (721180800 <= e.event_end <= 698803200) OR (753235200 <= e.event_end <= 730857600) OR (784684800 <= e.event_end <= 762307200) OR (816134400 <= e.event_end <= 793756800) OR (847584000 <= e.event_end <= 825206400) OR (879033600 <= e.event_end <= 856656000) OR (910483200 <= e.event_end <= 888105600) OR (942537600 <= e.event_end <= 920160000) OR (973987200 <= e.event_end <= 951609600) OR (1005436800 <= e.event_end <= 983059200) OR (1036886400 <= e.event_end <= 1014508800) OR (1068336000 <= e.event_end <= 1045958400) OR (1100390400 <= e.event_end <= 1077408000) OR (1131840000 <= e.event_end <= 1109462400) OR (1163289600 <= e.event_end <= 1140912000) OR (1194739200 <= e.event_end <= 1172361600) OR (1226188800 <= e.event_end <= 1203811200) OR (1257638400 <= e.event_end <= 1235260800) OR (1289692800 <= e.event_end <= 1267315200), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((26870400 <= e.event_start <= 4492800) OR (58924800 <= e.event_start <= 36547200) OR (90374400 <= e.event_start <= 67996800) OR (121824000 <= e.event_start <= 99446400) OR (153273600 <= e.event_start <= 130896000) OR (184723200 <= e.event_start <= 162345600) OR (216777600 <= e.event_start <= 193795200) OR (248227200 <= e.event_start <= 225849600) OR (279676800 <= e.event_start <= 257299200) OR (311126400 <= e.event_start <= 288748800) OR (342576000 <= e.event_start <= 320198400) OR (374025600 <= e.event_start <= 351648000) OR (406080000 <= e.event_start <= 383702400) OR (437529600 <= e.event_start <= 415152000) OR (468979200 <= e.event_start <= 446601600) OR (500428800 <= e.event_start <= 478051200) OR (531878400 <= e.event_start <= 509500800) OR (563328000 <= e.event_start <= 540950400) OR (595382400 <= e.event_start <= 573004800) OR (626832000 <= e.event_start <= 604454400) OR (658281600 <= e.event_start <= 635904000) OR (689731200 <= e.event_start <= 667353600) OR (721180800 <= e.event_start <= 698803200) OR (753235200 <= e.event_start <= 730857600) OR (784684800 <= e.event_start <= 762307200) OR (816134400 <= e.event_start <= 793756800) OR (847584000 <= e.event_start <= 825206400) OR (879033600 <= e.event_start <= 856656000) OR (910483200 <= e.event_start <= 888105600) OR (942537600 <= e.event_start <= 920160000) OR (973987200 <= e.event_start <= 951609600) OR (1005436800 <= e.event_start <= 983059200) OR (1036886400 <= e.event_start <= 1014508800) OR (1068336000 <= e.event_start <= 1045958400) OR (1100390400 <= e.event_start <= 1077408000) OR (1131840000 <= e.event_start <= 1109462400) OR (1163289600 <= e.event_start <= 1140912000) OR (1194739200 <= e.event_start <= 1172361600) OR (1226188800 <= e.event_start <= 1203811200) OR (1257638400 <= e.event_start <= 1235260800) OR (1289692800 <= e.event_start <= 1267315200), 1, 0), IF((26870400 <= e.event_end <= 4492800) OR (58924800 <= e.event_end <= 36547200) OR (90374400 <= e.event_end <= 67996800) OR (121824000 <= e.event_end <= 99446400) OR (153273600 <= e.event_end <= 130896000) OR (184723200 <= e.event_end <= 162345600) OR (216777600 <= e.event_end <= 193795200) OR (248227200 <= e.event_end <= 225849600) OR (279676800 <= e.event_end <= 257299200) OR (311126400 <= e.event_end <= 288748800) OR (342576000 <= e.event_end <= 320198400) OR (374025600 <= e.event_end <= 351648000) OR (406080000 <= e.event_end <= 383702400) OR (437529600 <= e.event_end <= 415152000) OR (468979200 <= e.event_end <= 446601600) OR (500428800 <= e.event_end <= 478051200) OR (531878400 <= e.event_end <= 509500800) OR (563328000 <= e.event_end <= 540950400) OR (595382400 <= e.event_end <= 573004800) OR (626832000 <= e.event_end <= 604454400) OR (658281600 <= e.event_end <= 635904000) OR (689731200 <= e.event_end <= 667353600) OR (721180800 <= e.event_end <= 698803200) OR (753235200 <= e.event_end <= 730857600) OR (784684800 <= e.event_end <= 762307200) OR (816134400 <= e.event_end <= 793756800) OR (847584000 <= e.event_end <= 825206400) OR (879033600 <= e.event_end <= 856656000) OR (910483200 <= e.event_end <= 888105600) OR (942537600 <= e.event_end <= 920160000) OR (973987200 <= e.event_end <= 951609600) OR (1005436800 <= e.event_end <= 983059200) OR (1036886400 <= e.event_end <= 1014508800) OR (1068336000 <= e.event_end <= 1045958400) OR (1100390400 <= e.event_end <= 1077408000) OR (1131840000 <= e.event_end <= 1109462400) OR (1163289600 <= e.event_end <= 1140912000) OR (1194739200 <= e.event_end <= 1172361600) OR (1226188800 <= e.event_end <= 1203811200) OR (1257638400 <= e.event_end <= 1235260800) OR (1289692800 <= e.event_end <= 1267315200), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 17
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((24969600 <= e.event_start <= 6307200) OR (56419200 <= e.event_start <= 38361600) OR (88473600 <= e.event_start <= 69811200) OR (119923200 <= e.event_start <= 101260800) OR (151372800 <= e.event_start <= 132710400) OR (182822400 <= e.event_start <= 164160000) OR (214272000 <= e.event_start <= 196214400) OR (245721600 <= e.event_start <= 227664000) OR (277776000 <= e.event_start <= 259113600) OR (309225600 <= e.event_start <= 290563200) OR (340675200 <= e.event_start <= 322012800) OR (372124800 <= e.event_start <= 353462400) OR (403574400 <= e.event_start <= 385516800) OR (435024000 <= e.event_start <= 416966400) OR (467078400 <= e.event_start <= 448416000) OR (498528000 <= e.event_start <= 479865600) OR (529977600 <= e.event_start <= 511315200) OR (561427200 <= e.event_start <= 542764800) OR (592876800 <= e.event_start <= 574819200) OR (624931200 <= e.event_start <= 606268800) OR (656380800 <= e.event_start <= 637718400) OR (687830400 <= e.event_start <= 669168000) OR (719280000 <= e.event_start <= 700617600) OR (750729600 <= e.event_start <= 732672000) OR (782179200 <= e.event_start <= 764121600) OR (814233600 <= e.event_start <= 795571200) OR (845683200 <= e.event_start <= 827020800) OR (877132800 <= e.event_start <= 858470400) OR (908582400 <= e.event_start <= 889920000) OR (940032000 <= e.event_start <= 921974400) OR (972086400 <= e.event_start <= 953424000) OR (1003536000 <= e.event_start <= 984873600) OR (1034985600 <= e.event_start <= 1016323200) OR (1066435200 <= e.event_start <= 1047772800) OR (1097884800 <= e.event_start <= 1079827200) OR (1129334400 <= e.event_start <= 1111276800) OR (1161388800 <= e.event_start <= 1142726400) OR (1192838400 <= e.event_start <= 1174176000) OR (1224288000 <= e.event_start <= 1205625600) OR (1255737600 <= e.event_start <= 1237075200) OR (1287187200 <= e.event_start <= 1269129600), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((24969600 <= e.event_end <= 6307200) OR (56419200 <= e.event_end <= 38361600) OR (88473600 <= e.event_end <= 69811200) OR (119923200 <= e.event_end <= 101260800) OR (151372800 <= e.event_end <= 132710400) OR (182822400 <= e.event_end <= 164160000) OR (214272000 <= e.event_end <= 196214400) OR (245721600 <= e.event_end <= 227664000) OR (277776000 <= e.event_end <= 259113600) OR (309225600 <= e.event_end <= 290563200) OR (340675200 <= e.event_end <= 322012800) OR (372124800 <= e.event_end <= 353462400) OR (403574400 <= e.event_end <= 385516800) OR (435024000 <= e.event_end <= 416966400) OR (467078400 <= e.event_end <= 448416000) OR (498528000 <= e.event_end <= 479865600) OR (529977600 <= e.event_end <= 511315200) OR (561427200 <= e.event_end <= 542764800) OR (592876800 <= e.event_end <= 574819200) OR (624931200 <= e.event_end <= 606268800) OR (656380800 <= e.event_end <= 637718400) OR (687830400 <= e.event_end <= 669168000) OR (719280000 <= e.event_end <= 700617600) OR (750729600 <= e.event_end <= 732672000) OR (782179200 <= e.event_end <= 764121600) OR (814233600 <= e.event_end <= 795571200) OR (845683200 <= e.event_end <= 827020800) OR (877132800 <= e.event_end <= 858470400) OR (908582400 <= e.event_end <= 889920000) OR (940032000 <= e.event_end <= 921974400) OR (972086400 <= e.event_end <= 953424000) OR (1003536000 <= e.event_end <= 984873600) OR (1034985600 <= e.event_end <= 1016323200) OR (1066435200 <= e.event_end <= 1047772800) OR (1097884800 <= e.event_end <= 1079827200) OR (1129334400 <= e.event_end <= 1111276800) OR (1161388800 <= e.event_end <= 1142726400) OR (1192838400 <= e.event_end <= 1174176000) OR (1224288000 <= e.event_end <= 1205625600) OR (1255737600 <= e.event_end <= 1237075200) OR (1287187200 <= e.event_end <= 1269129600), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((24969600 <= e.event_start <= 6307200) OR (56419200 <= e.event_start <= 38361600) OR (88473600 <= e.event_start <= 69811200) OR (119923200 <= e.event_start <= 101260800) OR (151372800 <= e.event_start <= 132710400) OR (182822400 <= e.event_start <= 164160000) OR (214272000 <= e.event_start <= 196214400) OR (245721600 <= e.event_start <= 227664000) OR (277776000 <= e.event_start <= 259113600) OR (309225600 <= e.event_start <= 290563200) OR (340675200 <= e.event_start <= 322012800) OR (372124800 <= e.event_start <= 353462400) OR (403574400 <= e.event_start <= 385516800) OR (435024000 <= e.event_start <= 416966400) OR (467078400 <= e.event_start <= 448416000) OR (498528000 <= e.event_start <= 479865600) OR (529977600 <= e.event_start <= 511315200) OR (561427200 <= e.event_start <= 542764800) OR (592876800 <= e.event_start <= 574819200) OR (624931200 <= e.event_start <= 606268800) OR (656380800 <= e.event_start <= 637718400) OR (687830400 <= e.event_start <= 669168000) OR (719280000 <= e.event_start <= 700617600) OR (750729600 <= e.event_start <= 732672000) OR (782179200 <= e.event_start <= 764121600) OR (814233600 <= e.event_start <= 795571200) OR (845683200 <= e.event_start <= 827020800) OR (877132800 <= e.event_start <= 858470400) OR (908582400 <= e.event_start <= 889920000) OR (940032000 <= e.event_start <= 921974400) OR (972086400 <= e.event_start <= 953424000) OR (1003536000 <= e.event_start <= 984873600) OR (1034985600 <= e.event_start <= 1016323200) OR (1066435200 <= e.event_start <= 1047772800) OR (1097884800 <= e.event_start <= 1079827200) OR (1129334400 <= e.event_start <= 1111276800) OR (1161388800 <= e.event_start <= 1142726400) OR (1192838400 <= e.event_start <= 1174176000) OR (1224288000 <= e.event_start <= 1205625600) OR (1255737600 <= e.event_start <= 1237075200) OR (1287187200 <= e.event_start <= 1269129600), 1, 0), IF((24969600 <= e.event_end <= 6307200) OR (56419200 <= e.event_end <= 38361600) OR (88473600 <= e.event_end <= 69811200) OR (119923200 <= e.event_end <= 101260800) OR (151372800 <= e.event_end <= 132710400) OR (182822400 <= e.event_end <= 164160000) OR (214272000 <= e.event_end <= 196214400) OR (245721600 <= e.event_end <= 227664000) OR (277776000 <= e.event_end <= 259113600) OR (309225600 <= e.event_end <= 290563200) OR (340675200 <= e.event_end <= 322012800) OR (372124800 <= e.event_end <= 353462400) OR (403574400 <= e.event_end <= 385516800) OR (435024000 <= e.event_end <= 416966400) OR (467078400 <= e.event_end <= 448416000) OR (498528000 <= e.event_end <= 479865600) OR (529977600 <= e.event_end <= 511315200) OR (561427200 <= e.event_end <= 542764800) OR (592876800 <= e.event_end <= 574819200) OR (624931200 <= e.event_end <= 606268800) OR (656380800 <= e.event_end <= 637718400) OR (687830400 <= e.event_end <= 669168000) OR (719280000 <= e.event_end <= 700617600) OR (750729600 <= e.event_end <= 732672000) OR (782179200 <= e.event_end <= 764121600) OR (814233600 <= e.event_end <= 795571200) OR (845683200 <= e.event_end <= 827020800) OR (877132800 <= e.event_end <= 858470400) OR (908582400 <= e.event_end <= 889920000) OR (940032000 <= e.event_end <= 921974400) OR (972086400 <= e.event_end <= 953424000) OR (1003536000 <= e.event_end <= 984873600) OR (1034985600 <= e.event_end <= 1016323200) OR (1066435200 <= e.event_end <= 1047772800) OR (1097884800 <= e.event_end <= 1079827200) OR (1129334400 <= e.event_end <= 1111276800) OR (1161388800 <= e.event_end <= 1142726400) OR (1192838400 <= e.event_end <= 1174176000) OR (1224288000 <= e.event_end <= 1205625600) OR (1255737600 <= e.event_end <= 1237075200) OR (1287187200 <= e.event_end <= 1269129600), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 18
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 134524800) OR (179884800 <= e.event_start <= 165974400) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 323827200) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 481680000) OR (527040000 <= e.event_start <= 513129600) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 670982400) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 828835200) OR (874195200 <= e.event_start <= 860284800) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018137600) OR (1063497600 <= e.event_start <= 1049587200) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1207440000) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 134524800) OR (179884800 <= e.event_end <= 165974400) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 323827200) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 481680000) OR (527040000 <= e.event_end <= 513129600) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 670982400) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 828835200) OR (874195200 <= e.event_end <= 860284800) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018137600) OR (1063497600 <= e.event_end <= 1049587200) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1207440000) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 134524800) OR (179884800 <= e.event_start <= 165974400) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 323827200) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 481680000) OR (527040000 <= e.event_start <= 513129600) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 670982400) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 828835200) OR (874195200 <= e.event_start <= 860284800) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018137600) OR (1063497600 <= e.event_start <= 1049587200) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1207440000) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), 1, 0), IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 134524800) OR (179884800 <= e.event_end <= 165974400) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 323827200) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 481680000) OR (527040000 <= e.event_end <= 513129600) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 670982400) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 828835200) OR (874195200 <= e.event_end <= 860284800) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018137600) OR (1063497600 <= e.event_end <= 1049587200) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1207440000) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 19
• Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 135129600) OR (179884800 <= e.event_start <= 166579200) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 324432000) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 482284800) OR (527040000 <= e.event_start <= 513734400) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 671587200) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 829440000) OR (874195200 <= e.event_start <= 860889600) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018742400) OR (1063497600 <= e.event_start <= 1050192000) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1208044800) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 135129600) OR (179884800 <= e.event_end <= 166579200) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 324432000) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 482284800) OR (527040000 <= e.event_end <= 513734400) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 671587200) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 829440000) OR (874195200 <= e.event_end <= 860889600) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018742400) OR (1063497600 <= e.event_end <= 1050192000) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1208044800) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((22032000 <= e.event_start <= 8726400) OR (53481600 <= e.event_start <= 40176000) OR (84931200 <= e.event_start <= 71625600) OR (116380800 <= e.event_start <= 103075200) OR (147830400 <= e.event_start <= 135129600) OR (179884800 <= e.event_start <= 166579200) OR (211334400 <= e.event_start <= 198028800) OR (242784000 <= e.event_start <= 229478400) OR (274233600 <= e.event_start <= 260928000) OR (305683200 <= e.event_start <= 292377600) OR (337737600 <= e.event_start <= 324432000) OR (369187200 <= e.event_start <= 355881600) OR (400636800 <= e.event_start <= 387331200) OR (432086400 <= e.event_start <= 418780800) OR (463536000 <= e.event_start <= 450230400) OR (494985600 <= e.event_start <= 482284800) OR (527040000 <= e.event_start <= 513734400) OR (558489600 <= e.event_start <= 545184000) OR (589939200 <= e.event_start <= 576633600) OR (621388800 <= e.event_start <= 608083200) OR (652838400 <= e.event_start <= 639532800) OR (684288000 <= e.event_start <= 671587200) OR (716342400 <= e.event_start <= 703036800) OR (747792000 <= e.event_start <= 734486400) OR (779241600 <= e.event_start <= 765936000) OR (810691200 <= e.event_start <= 797385600) OR (842140800 <= e.event_start <= 829440000) OR (874195200 <= e.event_start <= 860889600) OR (905644800 <= e.event_start <= 892339200) OR (937094400 <= e.event_start <= 923788800) OR (968544000 <= e.event_start <= 955238400) OR (999993600 <= e.event_start <= 986688000) OR (1031443200 <= e.event_start <= 1018742400) OR (1063497600 <= e.event_start <= 1050192000) OR (1094947200 <= e.event_start <= 1081641600) OR (1126396800 <= e.event_start <= 1113091200) OR (1157846400 <= e.event_start <= 1144540800) OR (1189296000 <= e.event_start <= 1175990400) OR (1221350400 <= e.event_start <= 1208044800) OR (1252800000 <= e.event_start <= 1239494400) OR (1284249600 <= e.event_start <= 1270944000), 1, 0), IF((22032000 <= e.event_end <= 8726400) OR (53481600 <= e.event_end <= 40176000) OR (84931200 <= e.event_end <= 71625600) OR (116380800 <= e.event_end <= 103075200) OR (147830400 <= e.event_end <= 135129600) OR (179884800 <= e.event_end <= 166579200) OR (211334400 <= e.event_end <= 198028800) OR (242784000 <= e.event_end <= 229478400) OR (274233600 <= e.event_end <= 260928000) OR (305683200 <= e.event_end <= 292377600) OR (337737600 <= e.event_end <= 324432000) OR (369187200 <= e.event_end <= 355881600) OR (400636800 <= e.event_end <= 387331200) OR (432086400 <= e.event_end <= 418780800) OR (463536000 <= e.event_end <= 450230400) OR (494985600 <= e.event_end <= 482284800) OR (527040000 <= e.event_end <= 513734400) OR (558489600 <= e.event_end <= 545184000) OR (589939200 <= e.event_end <= 576633600) OR (621388800 <= e.event_end <= 608083200) OR (652838400 <= e.event_end <= 639532800) OR (684288000 <= e.event_end <= 671587200) OR (716342400 <= e.event_end <= 703036800) OR (747792000 <= e.event_end <= 734486400) OR (779241600 <= e.event_end <= 765936000) OR (810691200 <= e.event_end <= 797385600) OR (842140800 <= e.event_end <= 829440000) OR (874195200 <= e.event_end <= 860889600) OR (905644800 <= e.event_end <= 892339200) OR (937094400 <= e.event_end <= 923788800) OR (968544000 <= e.event_end <= 955238400) OR (999993600 <= e.event_end <= 986688000) OR (1031443200 <= e.event_end <= 1018742400) OR (1063497600 <= e.event_end <= 1050192000) OR (1094947200 <= e.event_end <= 1081641600) OR (1126396800 <= e.event_end <= 1113091200) OR (1157846400 <= e.event_end <= 1144540800) OR (1189296000 <= e.event_end <= 1175990400) OR (1221350400 <= e.event_end <= 1208044800) OR (1252800000 <= e.event_end <= 1239494400) OR (1284249600 <= e.event_end <= 1270944000), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 20
• ALTER TABLE {event} ADD PRIMARY KEY nid (nid)
• ALTER TABLE {event} ADD KEY timezone (timezone)
• ALTER TABLE {users} ADD timezone_id int NOT NULL default '0'

Update #4

• No queries

Update #5

• ALTER TABLE {event_timezones} ADD is_dst int NOT NULL default 0
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 0
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 1
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 2
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 3
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 4
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 5
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 6
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 7
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 8
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 9
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 10
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 11
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 12
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 13
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 14
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 15
• UPDATE {event_timezones} SET is_dst = 1 WHERE dst_region = 16
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 17
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 18
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 19
• UPDATE {event_timezones} SET is_dst = 0 WHERE dst_region = 20

Update #6

• ALTER TABLE {event} ADD KEY event_start (event_start)
• ALTER TABLE {event} ADD KEY event_end (event_end)

Update #7

• ALTER TABLE {event} ADD has_time int NOT NULL default 1
• ALTER TABLE {event} ADD has_end_date int NOT NULL default 1

Update #8

• UPDATE {event} SET has_end_date = 0 WHERE event_start = event_end
• UPDATE {event} SET has_time = 0 WHERE EXTRACT(HOUR_SECOND FROM event_start) = 0 AND EXTRACT(HOUR_SECOND FROM event_end) = 235900

Update #6000

• No queries