O-Checklist YAML Parser

File='OO25B1.yaml'
Event='OO Cup 2025 Stage 1'
Creator='O Checklist v4.3.0', Created='2025-07-27T13:23:25+02:00'
Competitor identification mode: Id / Stage: 1 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (1063 items)

Warnings:

Comment 'late tart, na startno k, 13;25': Id='1984', StartStatus='Late start', Name='Nejc Turk', Org='Orientacijski klub Komenda', ClassName='M21A LONG', StartTime='12:19:00'.

Comment 'na startno 11;59': Id=' 417', StartStatus='Started OK', Name='Nea Eržen', Org='OK Azimut', ClassName='W18', StartTime='13:17:00'.

LateStart '10:32:43': Id=' 36', Name='Lászlo Hermann', Org='Watch Out Cluj', ClassName='M45', StartTime='10:34:00'.

LateStart '10:36:58': Id=' 146', Name='Miguel Reis e Silva', Org='Clube de Montanha do Funchal', ClassName='M21E', StartTime='10:38:00'.

LateStart '10:40:12': Id='1192', Name='Romans Curko', Org='OK Kapa', ClassName='M16', StartTime='10:42:00'.

LateStart '10:43:37': Id=' 152', Name='Eanna Grennan', Org='SEVO', ClassName='M18', StartTime='10:45:00'.

LateStart '10:44:11': Id='1059', Name='Vincent Becker', Org='Søllerød OK', ClassName='M21A SHORT', StartTime='10:46:00'.

LateStart '10:51:13': Id=' 720', Name='Bojan Jevševar', Org='OK Brežice', ClassName='M50 ULTIMATE', StartTime='10:53:00'.

LateStart '11:07:52': Id='1037', Name='Greg Hull', Org='Airienteers', ClassName='M60', StartTime='10:56:00'.

LateStart '11:29:10': Id='2088', Name='Ilmārs Miķelsons', Org='Auseklis IK', ClassName='M45', StartTime='11:22:00'.

LateStart '11:44:33': Id='1099', Name='Roland Fesselhofer', Org='OJE Wappler', ClassName='M35', StartTime='10:03:00'.

LateStart '12:42:27': Id='1029', Name='Pavel Klaška', Org='Oddíl OB Kotlářka, z.s.', ClassName='M55', StartTime='12:43:00'.

LateStart '12:42:31': Id='1081', Name='Ondřej Valenta', Org='OK Jilemnice', ClassName='M21E', StartTime='12:44:00'.

LateStart '12:50:25': Id=' 901', Name='Zinaida Lukianova', Org='RB United', ClassName='W35', StartTime='12:50:00'.

LateStart '12:51:07': Id=' 429', Name='Lucie Rothauer', Org='ASKÖ Henndorf Orienteering', ClassName='W45', StartTime='12:53:00'.

LateStart '12:55:12': Id=' 350', Name='Aleksandr Vompe', Org='Omega-Bratislava', ClassName='M50', StartTime='12:56:00'.

LateStart '13:12:14': Id='1604', Name='Rikke Kofoed', Org='OK Øst, Birkerød', ClassName='W45', StartTime='12:31:00'.

LateStart '13:21:44': Id='1984', Name='Nejc Turk', Org='Orientacijski klub Komenda', ClassName='M21A LONG', StartTime='12:19:00'.

New CardNumber ' 235759': Id='1199', StartStatus='Started OK', Name='Jeanette Downing', Org='Cleveland Orienteering Klub', OldCard='335759'.

New CardNumber ' 406722': Id=' 587', StartStatus='Started OK', Name='Petteri Niskanen', Org='Rasti-Hyry', OldCard=''.

New CardNumber ' 423566': Id=' 544', StartStatus='Started OK', Name='Leon Ricketts', Org='Airienteers', OldCard=''.

New CardNumber ' 831984': Id='1448', StartStatus='Started OK', Name='Christian Christensen', Org='OK Bomteknik', OldCard='841984'.

New CardNumber '1210580': Id='1126', StartStatus='Started OK', Name='Bruno Haberkorn', Org='ADOC', OldCard='503272'.

New CardNumber '1408132': Id=' 121', StartStatus='Started OK', Name='Barbara Kmetec', Org='Kamniški orientacijski klub', OldCard='3333'.

New CardNumber '1411602': Id='1059', StartStatus='Late start', Name='Vincent Becker', Org='Søllerød OK', OldCard='8510300'.

New CardNumber '1417530': Id='1097', StartStatus='Started OK', Name='Ilze Bara', Org='Briksnis - Latvia', OldCard=''.

New CardNumber '1420295': Id=' 305', StartStatus='Started OK', Name='András Balogh', Org='Alpokalja Szabadidősport és Környezetvédő Egyesület', OldCard='2111520'.

New CardNumber '2037285': Id='1331', StartStatus='Started OK', Name='Esa Holappa', Org='Espoon Suunta', OldCard=''.

New CardNumber '2041027': Id=' 148', StartStatus='Started OK', Name='Patrick Kronberg', Org='IF Femman', OldCard=''.

New CardNumber '2077612': Id=' 397', StartStatus='Started OK', Name='Matti Ylitalo', Org='Loimaan Jankko', OldCard=''.

New CardNumber '2077619': Id=' 149', StartStatus='Started OK', Name='Christian Kronberg', Org='IF Femman', OldCard=''.

New CardNumber '2106952': Id='1334', StartStatus='Started OK', Name='Hanna-Riikka Koskinen', Org='Espoon Suunta', OldCard=''.

New CardNumber '2106956': Id=' 569', StartStatus='Started OK', Name='Aatu Niskanen', Org='Vehkalahden Veikot', OldCard=''.

New CardNumber '2106983': Id='2022', StartStatus='Started OK', Name='Tsutomu Yoshida', Org='michinokai', OldCard=''.

New CardNumber '2106985': Id='1359', StartStatus='Started OK', Name='Jussi Koskinen', Org='Espoon Suunta', OldCard=''.

New CardNumber '2220137': Id=' 501', StartStatus='Started OK', Name='Niklas Wernersson', Org='Järfälla OK', OldCard='30507'.

New CardNumber '2232226': Id='1185', StartStatus='Started OK', Name='Toms Rozkalns', Org='OK Kapa', OldCard='1403573'.

New CardNumber '7083170': Id='1655', StartStatus='Started OK', Name='Jeanne Evrard', Org='ASUB Orientation', OldCard='240598'.

New CardNumber '7500933': Id='1648', StartStatus='Started OK', Name='Pascal Moreau', Org='ASUB Orientation', OldCard='12345'.

New CardNumber '7771119': Id='1654', StartStatus='Started OK', Name='Christian Gillet', Org='ASUB Orientation', OldCard='7211891'.

New CardNumber '7991224': Id=' 398', StartStatus='Started OK', Name='Levente Szalay', Org='Alpokalja Szabadidősport és Környezetvédő Egyesület', OldCard='8122499'.

New CardNumber '8003157': Id='1938', StartStatus='Started OK', Name='Quentin Gillet', Org='C.O.Liège', OldCard='8031075'.

New CardNumber '8003949': Id=' 164', StartStatus='Started OK', Name='Mika Asenbauer', Org='Naturfreunde Wien - Orienteering-Team', OldCard='8003940'.

New CardNumber '8006139': Id='1790', StartStatus='Started OK', Name='Joke Zoons', Org='hamok', OldCard=''.

New CardNumber '8016313': Id='1325', StartStatus='Started OK', Name='Hana Veljacikova', Org='OK Sparta Praha', OldCard=''.

New CardNumber '8016646': Id=' 99', StartStatus='Started OK', Name='Lasse Falck Weber', Org='FarumTisvilde OK', OldCard='8646100'.

New CardNumber '8020204': Id='1859', StartStatus='Started OK', Name='Magdalena Kurfurstova', Org='VSK CVUT FS Praha', OldCard='207837'.

New CardNumber '8044448': Id='1011', StartStatus='Started OK', Name='Antoine Mattart', Org='OK GJALL', OldCard=''.

New CardNumber '8044535': Id=' 401', StartStatus='Started OK', Name='Eero Martomaa', Org='Espoon Suunta', OldCard='8044528'.

New CardNumber '8062201': Id=' 336', StartStatus='Started OK', Name='Nelli Hajdu', Org='Tipo Orienteering Club', OldCard='307751'.

New CardNumber '8063832': Id='1416', StartStatus='Started OK', Name='Rie McGrail', Org='OK Bomteknik', OldCard='800529'.

New CardNumber '8068908': Id='1881', StartStatus='Started OK', Name='Xander Berger', Org='Der Berger-Clan', OldCard='2011000'.

New CardNumber '8080696': Id=' 107', StartStatus='Started OK', Name='Victor Apostol', Org='Nature Orientation Saint Etienne', OldCard='1420170'.

New CardNumber '8081980': Id='1210', StartStatus='Started OK', Name='Fionne Austin', Org='Lagan Valley Orienteers', OldCard='11926'.

New CardNumber '8089043': Id=' 146', StartStatus='Late start', Name='Miguel Reis e Silva', Org='Clube de Montanha do Funchal', OldCard='131914'.

New CardNumber '8122499': Id=' 384', StartStatus='Started OK', Name='Fülöp Jacsev', Org='Alpokalja Szabadidősport és Környezetvédő Egyesület', OldCard='233643'.

New CardNumber '8122703': Id='1491', StartStatus='Started OK', Name='Tobias Micko', Org='Gruppe Orientierungs-Sport Harzberg', OldCard='8120327'.

New CardNumber '8141081': Id=' 895', StartStatus='Started OK', Name='Guillaume Gastineau', Org='Balise 77 Fontainebleau Avon', OldCard=''.

New CardNumber '8214206': Id='1912', StartStatus='Started OK', Name='Romane Sence', Org='Villeneuve d'Ascq Lille Métropole Orientation', OldCard='8059009'.

New CardNumber '8217852': Id=' 139', StartStatus='Started OK', Name='Fionn Buckley', Org='Kerry Orienteers', OldCard='8217705'.

New CardNumber '8220576': Id=' 95', StartStatus='Started OK', Name='Hannes Wenzel', Org='OLC Union Viktring', OldCard='9900001'.

New CardNumber '8230140': Id='1151', StartStatus='Started OK', Name='Jan Erne', Org='Cordoba OLC', OldCard=''.

New CardNumber '8237747': Id=' 470', StartStatus='Started OK', Name='Aurimas Murenas', Org='Medeina OK', OldCard='8651329'.

New CardNumber '8238328': Id=' 304', StartStatus='Started OK', Name='Bálint Szele', Org='Alpokalja Szabadidősport és Környezetvédő Egyesület', OldCard='2092466'.

New CardNumber '8300205': Id=' 69', StartStatus='Started OK', Name='Vilma Svantesson', Org='OK Pan-Kristianstad', OldCard=''.

New CardNumber '8330752': Id=' 321', StartStatus='Started OK', Name='Kasparas Murenas', Org='Medeina OK', OldCard='8667558'.

New CardNumber '8454554': Id=' 840', StartStatus='Started OK', Name='Tanja Grmovšek', Org='MOK Pohorje', OldCard='1399954'.

New CardNumber '8506682': Id='1494', StartStatus='Started OK', Name='Alberte Kaae-nielsen', Org='Søllerød OK', OldCard='8645451'.

New CardNumber '8517410': Id=' 901', StartStatus='Late start', Name='Zinaida Lukianova', Org='RB United', OldCard='7203775'.

New CardNumber '8522991': Id='1559', StartStatus='Started OK', Name='Luca Németh', Org='SPA Budapest', OldCard='8416640'.

New CardNumber '8526735': Id='1168', StartStatus='Started OK', Name='Johan Brandstrup Fegar', Org='OK Bomteknik', OldCard='8656917'.

New CardNumber '8533457': Id='1029', StartStatus='Late start', Name='Pavel Klaška', Org='Oddíl OB Kotlářka, z.s.', OldCard='9889'.

New CardNumber '8533518': Id='1005', StartStatus='Started OK', Name='Annissa Rauw', Org='OLV Eifel', OldCard='7092007'.

New CardNumber '8534487': Id='1117', StartStatus='Started OK', Name='Silvio Ambrosio', Org='ASD-AŠZ GAJA Orienteering', OldCard='2132923'.

New CardNumber '8535847': Id='1499', StartStatus='Started OK', Name='Emil Fredberg', Org='OK Bomteknik', OldCard='8440002'.

New CardNumber '8536412': Id=' 417', StartStatus='Started OK', Name='Nea Eržen', Org='OK Azimut', OldCard='8044534'.

New CardNumber '8643977': Id='1731', StartStatus='Started OK', Name='Tatsiana Voveriene', Org='Devyni OSK', OldCard='8622488'.

New CardNumber '8653040': Id='1829', StartStatus='Started OK', Name='Mirjam Hellmüller', Org='OLC Winterthur', OldCard='7200253'.

New CardNumber '8655046': Id=' 946', StartStatus='Started OK', Name='Matleena Boström', Org='IFK Lidingö SOK', OldCard=''.

New CardNumber '8682020': Id=' 49', StartStatus='Started OK', Name='Benjámin Simon', Org='Watch Out Cluj', OldCard='8006657'.

New CardNumber '9070961': Id=' 355', StartStatus='Started OK', Name='Roald von Schoultz', Org='DT Pargas IF', OldCard='9070691'.

New CardNumber '9101116': Id='1134', StartStatus='Started OK', Name='Jan Porkert', Org='OK Slavia Hradec Kralove', OldCard='8663181'.

New CardNumber '9101280': Id=' 868', StartStatus='Started OK', Name='Andreas Wibmer', Org='Haunold Orienteering Team', OldCard='7101280'.

New CardNumber '9102804': Id=' 987', StartStatus='Started OK', Name='Jeremy Donner', Org='OK77', OldCard='2091869'.

New CardNumber '9150102': Id='1048', StartStatus='Started OK', Name='Isabelle Gisler', Org='OLG KTV Altdorf', OldCard='8130115'.

OK (1009):

1
   2
   5
   8
  20
  27
  29
  30
  42
  43
  44
  47
  49
  50
  57
  62
  69
  70
  71
  72
  73
  75
  78
  80
  81
  82
  83
  84
  85
  86
  87
  92
  93
  94
  95
  96
  99
 101
 107
 113
 115
 121
 123
 124
 125
 129
 130
 131
 132
 133
 134
 138
 139
 140
 142
 143
 148
 149
 150
 151
 159
 161
 162
 164
 168
 169
 175
 179
 180
 182
 184
 187
 188
 192
 193
 194
 196
 197
 198
 201
 202
 204
 206
 207
 208
 209
 210
 211
 213
 216
 217
 218
 220
 221
 227
 228
 229
 230
 233
 234
 236
 237
 238
 239
 241
 245
 246
 253
 256
 257
 259
 260
 262
 263
 264
 265
 269
 270
 273
 274
 285
 286
 287
 290
 291
 296
 303
 304
 305
 306
 308
 314
 315
 316
 319
 320
 321
 322
 325
 331
 333
 334
 336
 338
 339
 340
 341
 342
 343
 344
 345
 346
 347
 348
 351
 355
 359
 369
 371
 372
 375
 377
 380
 381
 382
 383
 384
 392
 395
 396
 397
 398
 399
 400
 401
 402
 403
 404
 405
 408
 412
 414
 415
 417
 418
 421
 422
 423
 424
 426
 427
 437
 441
 443
 449
 450
 451
 455
 456
 457
 458
 459
 460
 461
 462
 464
 465
 466
 470
 471
 472
 474
 477
 478
 479
 480
 487
 489
 492
 497
 500
 501
 506
 507
 508
 509
 511
 512
 514
 515
 520
 521
 522
 524
 527
 529
 530
 531
 532
 533
 534
 538
 539
 540
 541
 542
 544
 548
 549
 550
 551
 552
 554
 557
 559
 561
 562
 566
 569
 570
 573
 578
 579
 580
 587
 594
 595
 601
 602
 603
 605
 610
 612
 613
 617
 618
 619
 620
 623
 624
 626
 627
 628
 629
 630
 637
 639
 647
 648
 651
 654
 656
 658
 660
 661
 662
 663
 665
 669
 671
 674
 676
 677
 678
 683
 688
 689
 692
 696
 697
 700
 701
 703
 713
 715
 716
 717
 718
 724
 727
 729
 732
 737
 738
 742
 748
 749
 751
 752
 756
 758
 759
 760
 761
 762
 763
 769
 771
 775
 776
 777
 783
 786
 796
 797
 801
 802
 804
 806
 807
 811
 813
 814
 815
 816
 817
 820
 825
 827
 828
 829
 831
 833
 837
 840
 842
 843
 846
 847
 849
 850
 851
 852
 853
 854
 855
 861
 862
 863
 864
 868
 870
 873
 875
 878
 879
 880
 885
 886
 889
 890
 891
 895
 897
 899
 900
 904
 905
 906
 907
 909
 911
 912
 913
 915
 916
 917
 918
 920
 921
 922
 923
 926
 927
 932
 933
 946
 948
 953
 954
 955
 956
 957
 959
 960
 963
 965
 966
 969
 970
 975
 976
 977
 980
 981
 983
 984
 986
 987
 988
 989
 990
 991
 993
 995
 997
 999
1000
1002
1004
1005
1008
1009
1011
1012
1014
1018
1020
1022
1025
1030
1031
1033
1034
1035
1038
1039
1041
1042
1043
1044
1045
1046
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1060
1061
1063
1064
1065
1066
1067
1068
1069
1072
1073
1074
1077
1078
1080
1082
1083
1085
1086
1092
1096
1097
1098
1101
1102
1103
1105
1106
1108
1111
1112
1113
1114
1115
1117
1121
1124
1126
1129
1130
1131
1132
1133
1134
1135
1138
1140
1143
1144
1145
1146
1147
1151
1155
1156
1159
1163
1167
1168
1176
1177
1179
1180
1181
1185
1186
1187
1188
1193
1195
1199
1200
1201
1202
1203
1204
1205
1206
1208
1210
1211
1217
1219
1220
1221
1222
1223
1225
1226
1230
1233
1234
1235
1236
1241
1247
1249
1251
1252
1256
1257
1259
1260
1264
1265
1266
1273
1275
1276
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1296
1300
1303
1304
1309
1311
1312
1313
1315
1316
1319
1321
1322
1324
1325
1327
1331
1334
1337
1340
1341
1342
1345
1346
1349
1351
1353
1358
1359
1362
1363
1368
1369
1371
1378
1379
1383
1385
1388
1389
1390
1391
1392
1394
1395
1397
1398
1400
1401
1402
1404
1406
1408
1409
1410
1411
1412
1415
1416
1417
1418
1421
1422
1427
1428
1429
1430
1434
1435
1436
1437
1439
1440
1441
1444
1448
1449
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1463
1464
1465
1468
1470
1471
1472
1481
1483
1485
1486
1490
1491
1493
1494
1498
1499
1500
1501
1504
1506
1508
1510
1511
1512
1513
1514
1518
1519
1525
1527
1528
1531
1532
1535
1536
1537
1538
1540
1541
1543
1544
1547
1553
1554
1555
1556
1557
1559
1561
1563
1564
1568
1571
1573
1574
1575
1577
1579
1580
1582
1586
1587
1588
1591
1592
1593
1594
1595
1598
1599
1600
1605
1606
1607
1608
1609
1611
1613
1618
1623
1627
1629
1631
1634
1638
1647
1648
1652
1653
1654
1655
1658
1659
1660
1663
1665
1666
1667
1670
1672
1673
1680
1683
1685
1688
1689
1691
1692
1693
1695
1696
1698
1703
1704
1706
1711
1712
1713
1714
1715
1718
1719
1721
1722
1723
1724
1725
1726
1730
1731
1732
1733
1734
1735
1737
1741
1744
1746
1749
1750
1752
1755
1756
1761
1765
1766
1767
1768
1770
1772
1774
1776
1778
1780
1781
1783
1784
1787
1788
1790
1794
1796
1798
1800
1801
1804
1805
1806
1808
1809
1813
1815
1816
1819
1820
1821
1822
1826
1827
1828
1829
1831
1832
1833
1835
1840
1842
1843
1845
1846
1849
1850
1852
1859
1860
1864
1868
1871
1881
1882
1885
1888
1889
1890
1893
1894
1895
1896
1897
1901
1902
1904
1905
1906
1908
1909
1910
1912
1914
1916
1917
1919
1920
1922
1927
1929
1930
1932
1935
1937
1938
1939
1940
1944
1948
1949
1950
1953
1955
1956
1957
1959
1961
1963
1964
1966
1970
1973
1975
1978
1980
1981
1983
1985
1986
1990
1992
1993
1994
1995
1997
2000
2003
2007
2010
2014
2015
2016
2018
2019
2021
2022
2023
2025
2027
2029
2030
2033
2035
2036
2040
2043
2044
2045
2046
2050
2053
2054
2055
2056
2057
2063
2064
2066
2068
2069
2072
2074
2075
2077
2081
2082
2085
2086
2087
2090
2091
2092
2093
2095
2101
2102
2103
2116

Late (16):

DNS (38):

LateStart, DNS and ChipChange SQL-query:

-- Execute this query (F4) and then don't forget to
-- commit the changes to the database after executing (F5).

-- DNS: Set FinishType to 4=DNS, but only for people without another post-readout FinishType
UPDATE OEvCompetitor SET FinishType1 = 4 WHERE (FinishType1 = 0)
AND (Id IN (11, 45, 135, 163, 203, 205, 225, 226, 240, 445, 495, 571, 598, 808, 898, 924, 944, 947, 994, 1432, 1484, 1524, 1558,
    1560, 1736, 1738, 1791, 1824, 1925, 1967, 1971, 2059, 2110, 2111, 2112, 2113, 2114, 2117));

-- LateStart: Reset FinishType to 0=NotSet, but only for people previously marked as 4=DNS
UPDATE OEvCompetitor SET FinishType1 = 0 WHERE (FinishType1 = 4)
AND (Id IN (36, 146, 152, 350, 429, 720, 901, 1029, 1037, 1059, 1081, 1099, 1192, 1604, 1984, 2088));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber1= 235759 WHERE (Id=1199) AND (FinishType1=0) AND (ChipNumber1= 335759);
UPDATE OEvCompetitor SET ChipNumber1= 406722 WHERE (Id= 587) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 423566 WHERE (Id= 544) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 831984 WHERE (Id=1448) AND (FinishType1=0) AND (ChipNumber1= 841984);
UPDATE OEvCompetitor SET ChipNumber1=1210580 WHERE (Id=1126) AND (FinishType1=0) AND (ChipNumber1= 503272);
UPDATE OEvCompetitor SET ChipNumber1=1408132 WHERE (Id= 121) AND (FinishType1=0) AND (ChipNumber1=   3333);
UPDATE OEvCompetitor SET ChipNumber1=1411602 WHERE (Id=1059) AND (FinishType1=0) AND (ChipNumber1=8510300);
UPDATE OEvCompetitor SET ChipNumber1=1417530 WHERE (Id=1097) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=1420295 WHERE (Id= 305) AND (FinishType1=0) AND (ChipNumber1=2111520);
UPDATE OEvCompetitor SET ChipNumber1=2037285 WHERE (Id=1331) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2041027 WHERE (Id= 148) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2077612 WHERE (Id= 397) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2077619 WHERE (Id= 149) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106952 WHERE (Id=1334) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106956 WHERE (Id= 569) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106983 WHERE (Id=2022) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106985 WHERE (Id=1359) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2220137 WHERE (Id= 501) AND (FinishType1=0) AND (ChipNumber1=  30507);
UPDATE OEvCompetitor SET ChipNumber1=2232226 WHERE (Id=1185) AND (FinishType1=0) AND (ChipNumber1=1403573);
UPDATE OEvCompetitor SET ChipNumber1=7083170 WHERE (Id=1655) AND (FinishType1=0) AND (ChipNumber1= 240598);
UPDATE OEvCompetitor SET ChipNumber1=7500933 WHERE (Id=1648) AND (FinishType1=0) AND (ChipNumber1=  12345);
UPDATE OEvCompetitor SET ChipNumber1=7771119 WHERE (Id=1654) AND (FinishType1=0) AND (ChipNumber1=7211891);
UPDATE OEvCompetitor SET ChipNumber1=7991224 WHERE (Id= 398) AND (FinishType1=0) AND (ChipNumber1=8122499);
UPDATE OEvCompetitor SET ChipNumber1=8003157 WHERE (Id=1938) AND (FinishType1=0) AND (ChipNumber1=8031075);
UPDATE OEvCompetitor SET ChipNumber1=8003949 WHERE (Id= 164) AND (FinishType1=0) AND (ChipNumber1=8003940);
UPDATE OEvCompetitor SET ChipNumber1=8006139 WHERE (Id=1790) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8016313 WHERE (Id=1325) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8016646 WHERE (Id=  99) AND (FinishType1=0) AND (ChipNumber1=8646100);
UPDATE OEvCompetitor SET ChipNumber1=8020204 WHERE (Id=1859) AND (FinishType1=0) AND (ChipNumber1= 207837);
UPDATE OEvCompetitor SET ChipNumber1=8044448 WHERE (Id=1011) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8044535 WHERE (Id= 401) AND (FinishType1=0) AND (ChipNumber1=8044528);
UPDATE OEvCompetitor SET ChipNumber1=8062201 WHERE (Id= 336) AND (FinishType1=0) AND (ChipNumber1= 307751);
UPDATE OEvCompetitor SET ChipNumber1=8063832 WHERE (Id=1416) AND (FinishType1=0) AND (ChipNumber1= 800529);
UPDATE OEvCompetitor SET ChipNumber1=8068908 WHERE (Id=1881) AND (FinishType1=0) AND (ChipNumber1=2011000);
UPDATE OEvCompetitor SET ChipNumber1=8080696 WHERE (Id= 107) AND (FinishType1=0) AND (ChipNumber1=1420170);
UPDATE OEvCompetitor SET ChipNumber1=8081980 WHERE (Id=1210) AND (FinishType1=0) AND (ChipNumber1=  11926);
UPDATE OEvCompetitor SET ChipNumber1=8089043 WHERE (Id= 146) AND (FinishType1=0) AND (ChipNumber1= 131914);
UPDATE OEvCompetitor SET ChipNumber1=8122499 WHERE (Id= 384) AND (FinishType1=0) AND (ChipNumber1= 233643);
UPDATE OEvCompetitor SET ChipNumber1=8122703 WHERE (Id=1491) AND (FinishType1=0) AND (ChipNumber1=8120327);
UPDATE OEvCompetitor SET ChipNumber1=8141081 WHERE (Id= 895) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8214206 WHERE (Id=1912) AND (FinishType1=0) AND (ChipNumber1=8059009);
UPDATE OEvCompetitor SET ChipNumber1=8217852 WHERE (Id= 139) AND (FinishType1=0) AND (ChipNumber1=8217705);
UPDATE OEvCompetitor SET ChipNumber1=8220576 WHERE (Id=  95) AND (FinishType1=0) AND (ChipNumber1=9900001);
UPDATE OEvCompetitor SET ChipNumber1=8230140 WHERE (Id=1151) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8237747 WHERE (Id= 470) AND (FinishType1=0) AND (ChipNumber1=8651329);
UPDATE OEvCompetitor SET ChipNumber1=8238328 WHERE (Id= 304) AND (FinishType1=0) AND (ChipNumber1=2092466);
UPDATE OEvCompetitor SET ChipNumber1=8300205 WHERE (Id=  69) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8330752 WHERE (Id= 321) AND (FinishType1=0) AND (ChipNumber1=8667558);
UPDATE OEvCompetitor SET ChipNumber1=8454554 WHERE (Id= 840) AND (FinishType1=0) AND (ChipNumber1=1399954);
UPDATE OEvCompetitor SET ChipNumber1=8506682 WHERE (Id=1494) AND (FinishType1=0) AND (ChipNumber1=8645451);
UPDATE OEvCompetitor SET ChipNumber1=8517410 WHERE (Id= 901) AND (FinishType1=0) AND (ChipNumber1=7203775);
UPDATE OEvCompetitor SET ChipNumber1=8522991 WHERE (Id=1559) AND (FinishType1=0) AND (ChipNumber1=8416640);
UPDATE OEvCompetitor SET ChipNumber1=8526735 WHERE (Id=1168) AND (FinishType1=0) AND (ChipNumber1=8656917);
UPDATE OEvCompetitor SET ChipNumber1=8533457 WHERE (Id=1029) AND (FinishType1=0) AND (ChipNumber1=   9889);
UPDATE OEvCompetitor SET ChipNumber1=8533518 WHERE (Id=1005) AND (FinishType1=0) AND (ChipNumber1=7092007);
UPDATE OEvCompetitor SET ChipNumber1=8534487 WHERE (Id=1117) AND (FinishType1=0) AND (ChipNumber1=2132923);
UPDATE OEvCompetitor SET ChipNumber1=8535847 WHERE (Id=1499) AND (FinishType1=0) AND (ChipNumber1=8440002);
UPDATE OEvCompetitor SET ChipNumber1=8536412 WHERE (Id= 417) AND (FinishType1=0) AND (ChipNumber1=8044534);
UPDATE OEvCompetitor SET ChipNumber1=8643977 WHERE (Id=1731) AND (FinishType1=0) AND (ChipNumber1=8622488);
UPDATE OEvCompetitor SET ChipNumber1=8653040 WHERE (Id=1829) AND (FinishType1=0) AND (ChipNumber1=7200253);
UPDATE OEvCompetitor SET ChipNumber1=8655046 WHERE (Id= 946) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=8682020 WHERE (Id=  49) AND (FinishType1=0) AND (ChipNumber1=8006657);
UPDATE OEvCompetitor SET ChipNumber1=9070961 WHERE (Id= 355) AND (FinishType1=0) AND (ChipNumber1=9070691);
UPDATE OEvCompetitor SET ChipNumber1=9101116 WHERE (Id=1134) AND (FinishType1=0) AND (ChipNumber1=8663181);
UPDATE OEvCompetitor SET ChipNumber1=9101280 WHERE (Id= 868) AND (FinishType1=0) AND (ChipNumber1=7101280);
UPDATE OEvCompetitor SET ChipNumber1=9102804 WHERE (Id= 987) AND (FinishType1=0) AND (ChipNumber1=2091869);
UPDATE OEvCompetitor SET ChipNumber1=9150102 WHERE (Id=1048) AND (FinishType1=0) AND (ChipNumber1=8130115);

-- ChipCopy: If chip for any next stage is unknown or different from today, set it from today
UPDATE OEvCompetitor SET ChipNumber2 = ChipNumber1 WHERE (FinishType2 = 0)
    AND (ChipNumber1 IS NOT NULL) AND (COALESCE(ChipNumber2, 0) <> ChipNumber1);
UPDATE OEvCompetitor SET ChipNumber3 = ChipNumber1 WHERE (FinishType3 = 0)
    AND (ChipNumber1 IS NOT NULL) AND (COALESCE(ChipNumber3, 0) <> ChipNumber1);