O-Checklist YAML Parser

File='skof.yaml'
Event='Orientacija GZ Škofljica Stage 1'
Creator='O Checklist v4.2.1', Created='2025-05-31T10:08:25+02:00'
Competitor identification mode: Id / Stage: 1 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (82 items)

Warnings:

New CardNumber ' 308919': Id=' 21', StartStatus='Started OK', Name='LARA, LARA, JULIJA ŽELIMLJE', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 308920': Id=' 17', StartStatus='Started OK', Name='PIA, NEJA, EVA PIJAVA GORICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 406738': Id=' 12', StartStatus='Started OK', Name='VERONIKA, TADEJ, NIK IŠKA VAS 3', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber ' 435106': Id=' 19', StartStatus='Started OK', Name='BLAŽ, NIK, REBEKA ŠKOFLJICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 445696': Id=' 16', StartStatus='Started OK', Name='LANA , PIKA, JULIJA VRH NAD ŽELIMLJAMI', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 445701': Id=' 40', StartStatus='Started OK', Name='TEA , ŠPELA, KATARINA PIJAVA GORICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 445704': Id=' 38', StartStatus='Started OK', Name='VID, ALJAŽ, MATIC ŽELIMLJE', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 445706': Id=' 8', StartStatus='Started OK', Name='ELA, LARA LEYA, NEŽA TOMIŠELJ 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber ' 445708': Id=' 42', StartStatus='Started OK', Name='EMA, PATRIK, ANDRAŽ ORLE 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber ' 445709': Id=' 61', StartStatus='Started OK', Name='GAJA , ALJA , MERI RAŠCA 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber ' 445710': Id=' 6', StartStatus='Started OK', Name='MARK, NASTJA, LAN BREST 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '1401531': Id=' 29', StartStatus='Started OK', Name='JAKA, VID, JAKOB PIJAVA GORICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2008678': Id=' 69', StartStatus='Started OK', Name='JAKOB , TADEJ , DAVID VELIKI OSOLNIK 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2041027': Id=' 36', StartStatus='Started OK', Name='MILAN, MATIC, VID LAVRICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2041028': Id=' 82', StartStatus='Started OK', Name='MATIC , URH , JAN DVORSKA VAS 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2077612': Id=' 90', StartStatus='Started OK', Name='LIANA , TIMOTEJ , JAŠA DVORSKA VAS 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2077619': Id=' 2', StartStatus='Started OK', Name='ANA, NIKA, ALINA VRBLJENE - STRAHOMER', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099762': Id=' 39', StartStatus='Started OK', Name='VIKTORIJA, NIKA, TIMOTEJ ŽELIMLJE 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2099765': Id=' 48', StartStatus='Started OK', Name='ŽIGA, TILEN, ENEJ KARLOVICA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099766': Id=' 86', StartStatus='', Name='JAN , URBAN , LEON ROB', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099769': Id=' 70', StartStatus='Started OK', Name='KAJA , JOŠT , JERNEJ VELIKE LAŠČE 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099770': Id=' 53', StartStatus='Started OK', Name='DAVID, LOVRENC, JURE ROB 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099773': Id=' 71', StartStatus='Started OK', Name='ŽAN , VAL , GAL ROB 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099774': Id=' 80', StartStatus='Started OK', Name='BENJAMIN , SVIT , TONI VELIKI OSOLNIK', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099778': Id=' 59', StartStatus='Started OK', Name='TOMAŽ , VAL , OŽBEJ RAŠCA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099781': Id=' 76', StartStatus='Started OK', Name='IVA , NATAŠA , IZABEL RAŠCA 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099785': Id=' 81', StartStatus='Started OK', Name='JON , JAKOB , AŽBE RAŠCA 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099786': Id=' 47', StartStatus='Started OK', Name='JAKA, ANEJ, ALEKSANDER ŽELIMLJE', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2099787': Id=' 55', StartStatus='Started OK', Name='LORI , AJDA, ANASTAZIJA RAŠCA 4', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099790': Id=' 67', StartStatus='Started OK', Name='LINA , LARISA , BLAŽ KARLOVICA 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106952': Id=' 5', StartStatus='Started OK', Name='ANASTAZIJA, ASJA, NELA BREST', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106953': Id=' 31', StartStatus='Started OK', Name='ENJA, MILA, OTA ŠKOFLJICA 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106955': Id=' 66', StartStatus='Started OK', Name='ZOJA , BORUT JANI , GAŠPER KARLOVICA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106957': Id=' 58', StartStatus='Started OK', Name='JOŠKO , LENART , ANA VELIKI OSOLNIK', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106959': Id=' 27', StartStatus='Started OK', Name='EVA, LEA, MARCEL PIJAVA GORICA 2', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106960': Id=' 7', StartStatus='Started OK', Name='OMAR, HANA, OŽBEJ BREST', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106965': Id=' 65', StartStatus='Started OK', Name='TINKARA , MANCA , EMA ROB', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106966': Id=' 68', StartStatus='Started OK', Name='MAJA , KRISTJAN , JERNEJ DVORSKA VAS 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106971': Id=' 30', StartStatus='Started OK', Name='HANA, SOFIJA, KLARA PIJAVA GORICA 2', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106973': Id=' 74', StartStatus='Started OK', Name='HANA , TIA , TRINA VELIKE LAŠČE', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106975': Id=' 24', StartStatus='Started OK', Name='ŽIGA, GABER, ALEKS PIJAVA GORICA 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106977': Id=' 1', StartStatus='Started OK', Name='JAKOB , GAŠPER , VID ŠKOFLJICA 2', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106978': Id=' 37', StartStatus='Started OK', Name='LOVRO, IAN , NACE ŠKOFLJICA 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106980': Id=' 18', StartStatus='Started OK', Name='SARA, ELA, SIMON VRBLJENE - STRAHOMER', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106982': Id=' 9', StartStatus='Started OK', Name='ŠTEFAN, ENEJ, OSKAR RAŠCA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106983': Id=' 10', StartStatus='Started OK', Name='LEA, VITA, MAŠA BREST', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106984': Id=' 22', StartStatus='Started OK', Name='LUNA, MINA, KAJA RAŠCA 3', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106985': Id=' 28', StartStatus='Started OK', Name='JERA , LEONI, SOFI ŠKOFLJICA 3', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106986': Id=' 43', StartStatus='Started OK', Name='MATIC, GAŠPER , VITO LAVRICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2106987': Id=' 44', StartStatus='Started OK', Name='GAL, JAKOB, SVIT TURJAK 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106990': Id=' 15', StartStatus='Started OK', Name='TIM, NACE, VID IŠKA LOKA 2', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106991': Id=' 84', StartStatus='Started OK', Name='TEJA , ZALA , ELA LUCIJA RAŠCA 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2106993': Id=' 14', StartStatus='Started OK', Name='MATEVŽ, ANŽE, GAŠPER PIJAVA GORICA', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2107909': Id=' 52', StartStatus='Started OK', Name='MAŠA, JAKOB, ALENKA KARLOVICA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2107911': Id=' 63', StartStatus='Started OK', Name='KLEMEN , MATEJ , NUŠA VELIKE LAŠČE 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2107913': Id=' 85', StartStatus='Started OK', Name='SOFIJA , DANAJA , LOTI TURJAK', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2107918': Id=' 49', StartStatus='Started OK', Name='TJAŠ, ALINA, AJDA TURJAK', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2107919': Id=' 26', StartStatus='Started OK', Name='LUKA, TRISTAN, TIT VRH NAD ŽELIMLJAMI', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2107921': Id=' 3', StartStatus='Started OK', Name='NIK, NIK, VAL BREST', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107922': Id=' 33', StartStatus='Started OK', Name='LINA, KLARA, LUČKA ŽELIMLJE', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2107923': Id=' 11', StartStatus='Started OK', Name='GAŠPER, JON, GAJA BREST', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107924': Id=' 13', StartStatus='Started OK', Name='LOVRO, KATARINA, SARA IŠKA LOKA', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2132389': Id=' 51', StartStatus='Started OK', Name='ŽIGA, ROK, LARA VELIKI OSOLNIK 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214891': Id=' 64', StartStatus='Started OK', Name='ANA , ANJA , MAŠA VELIKE LAŠČE 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214894': Id=' 34', StartStatus='Started OK', Name='KLARA, LUCIJA, MATIC ORLE 2', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2214897': Id=' 60', StartStatus='Started OK', Name='NEŽA , JANINA , KLARA RAŠCA', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214900': Id=' 46', StartStatus='Started OK', Name='EMIL, ANA, NEŽA TURJAK', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214902': Id=' 78', StartStatus='Started OK', Name='FLORIJAN , MATEVŽ , JAN VELIKE LAŠČE', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214904': Id=' 62', StartStatus='Started OK', Name='TJAŠ , VID , SARA KARLOVICA 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214907': Id=' 87', StartStatus='Started OK', Name='LEJLA ISABELA , LENART, LIAM TURJAK 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214908': Id=' 23', StartStatus='Started OK', Name='BRIN, LUKA, LUKA VRH NAD ŽELIMLJAMI', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2214909': Id=' 57', StartStatus='Started OK', Name='NIK , GAŠPER , KRISTJAN VELIKE LAŠČE 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214911': Id=' 45', StartStatus='Started OK', Name='EVA, LINA, IZA PIJAVA GORICA 1', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2214914': Id=' 56', StartStatus='Started OK', Name='VIDA, URŠKA, LARA RAŠCA 1', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2214917': Id=' 41', StartStatus='Started OK', Name='ROK, MARK, LEON ŠKOFLJICA 3', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2214918': Id=' 35', StartStatus='Started OK', Name='ŽAN, NEMANJA, NEJC PIJAVA GORICA 2', Org='ŠKOFLJICA ', OldCard=''.

Unknown StartStatus '': Id=' 86', Name='JAN , URBAN , LEON ROB', Org='VELIKE LAŠČE', ClassName='PIONIRJI', StartTime='10:48:00'.

OK (75):

Late (0):

DNS (6):

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 (4, 20, 25, 32, 50, 54));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber1= 308919 WHERE (Id=  21) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 308920 WHERE (Id=  17) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 406738 WHERE (Id=  12) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 435106 WHERE (Id=  19) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445696 WHERE (Id=  16) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445701 WHERE (Id=  40) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445704 WHERE (Id=  38) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445706 WHERE (Id=   8) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445708 WHERE (Id=  42) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445709 WHERE (Id=  61) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1= 445710 WHERE (Id=   6) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=1401531 WHERE (Id=  29) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2008678 WHERE (Id=  69) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2041027 WHERE (Id=  36) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2041028 WHERE (Id=  82) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2077612 WHERE (Id=  90) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2077619 WHERE (Id=   2) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099762 WHERE (Id=  39) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099765 WHERE (Id=  48) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099766 WHERE (Id=  86) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099769 WHERE (Id=  70) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099770 WHERE (Id=  53) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099773 WHERE (Id=  71) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099774 WHERE (Id=  80) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099778 WHERE (Id=  59) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099781 WHERE (Id=  76) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099785 WHERE (Id=  81) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099786 WHERE (Id=  47) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099787 WHERE (Id=  55) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099790 WHERE (Id=  67) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106952 WHERE (Id=   5) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106953 WHERE (Id=  31) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106955 WHERE (Id=  66) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106957 WHERE (Id=  58) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106959 WHERE (Id=  27) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106960 WHERE (Id=   7) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106965 WHERE (Id=  65) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106966 WHERE (Id=  68) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106971 WHERE (Id=  30) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106973 WHERE (Id=  74) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106975 WHERE (Id=  24) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106977 WHERE (Id=   1) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106978 WHERE (Id=  37) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106980 WHERE (Id=  18) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106982 WHERE (Id=   9) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106983 WHERE (Id=  10) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106984 WHERE (Id=  22) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106985 WHERE (Id=  28) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106986 WHERE (Id=  43) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106987 WHERE (Id=  44) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106990 WHERE (Id=  15) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106991 WHERE (Id=  84) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106993 WHERE (Id=  14) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107909 WHERE (Id=  52) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107911 WHERE (Id=  63) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107913 WHERE (Id=  85) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107918 WHERE (Id=  49) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107919 WHERE (Id=  26) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107921 WHERE (Id=   3) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107922 WHERE (Id=  33) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107923 WHERE (Id=  11) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107924 WHERE (Id=  13) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2132389 WHERE (Id=  51) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214891 WHERE (Id=  64) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214894 WHERE (Id=  34) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214897 WHERE (Id=  60) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214900 WHERE (Id=  46) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214902 WHERE (Id=  78) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214904 WHERE (Id=  62) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214907 WHERE (Id=  87) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214908 WHERE (Id=  23) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214909 WHERE (Id=  57) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214911 WHERE (Id=  45) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214914 WHERE (Id=  56) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214917 WHERE (Id=  41) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214918 WHERE (Id=  35) AND (FinishType1=0) AND (ChipNumber1 IS NULL);

-- 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);