timer_live:_X0^o8-#-nHWO9pY@tcp(s160.cyber-folks.pl:3306)/timer_competitions
root:password@tcp(localhost:3306)/timer_competitions

"INSERT INTO participants (
    Ranking,
    RankingMF, 
    Event_ID,
    Contest,
    Chip, 
    DisplayName, 
    Gender,
    YearOfBirth, 
    City,
    Nation,
    StartTime,
    Status,
    StatusName,
    FinishTime,
    SP1Time,
    SP2Time,
    SP3Time,  
    SP4Time,
    SP5Time,
    SP6Time,
    SP7Time,
    SP1Name,
    SP2Name,
    SP3Name,  
    SP4Name,
    SP5Name,
    SP6Name,
    SP7Name,
    SP1Rank,
    SP2Rank,
    SP3Rank,  
    SP4Rank,
    SP5Rank,
    SP6Rank,
    SP7Rank,
    NewArrival
    ) 
VALUES (
    '" & [Rank1] &"',
    '" & [MFRank] &"',
    '" & [Event.ID] &"',
    '" & [Contest] &"',
    '" & [Bib] & "', 
    '" & [DisplayName] &"',
    '" & [Gender] &"',
    '" & [YearOfBirth] &"',
    '" & [City] &"',
    '" & [Nation.Alpha2] &"',
    '" & if([Time3.Decimal]<>"";[Time3.Decimal];0) &"',
    '" & [Status] &"',
    '" & choose([Status]+1;"OK";"a.k.";"DSQ";"DNF";"DNS";"n.a.") &"',
    '" & if([Time1.Decimal]<>"";[Time1.Decimal];0) &"',
    '" & if([Time11.Decimal]<>"";[Time11.Decimal];0) &"',
    '" & if([Time12.Decimal]<>"";[Time12.Decimal];0) &"',
    '" & if([Time13.Decimal]<>"";[Time13.Decimal];0) &"',
    '" & if([Time14.Decimal]<>"";[Time14.Decimal];0) &"',
    '" & if([Time15.Decimal]<>"";[Time15.Decimal];0) &"',
    '" & if([Time16.Decimal]<>"";[Time16.Decimal];0) &"',
    '" & if([Time17.Decimal]<>"";[Time17.Decimal];0) &"',
    '" & if([Time11.Name]<>"0";[Time11.Name];NULL) &"',
    '" & if([Time12.Name]<>"0";[Time12.Name];NULL) &"',
    '" & if([Time13.Name]<>"0";[Time13.Name];NULL) &"',
    '" & if([Time14.Name]<>"0";[Time14.Name];NULL) &"',
    '" & if([Time15.Name]<>"0";[Time15.Name];NULL) &"',
    '" & if([Time16.Name]<>"0";[Time16.Name];NULL) &"',
    '" & if([Time17.Name]<>"0";[Time17.Name];NULL) &"',
    '" & if([Time11.Name]<>"0";[Rank11];NULL) &"',
    '" & if([Time12.Name]<>"0";[Rank12];NULL) &"',
    '" & if([Time13.Name]<>"0";[Rank13];NULL) &"',
    '" & if([Time14.Name]<>"0";[Rank14];NULL) &"',
    '" & if([Time15.Name]<>"0";[Rank15];NULL) &"',
    '" & if([Time16.Name]<>"0";[Rank16];NULL) &"',
    '" & if([Time17.Name]<>"0";[Rank17];NULL) &"',
    '1'
    )
ON DUPLICATE KEY UPDATE 
    Ranking='" & [Rank1] &"', 
    RankingMF='" & [MFRank] &"', 
    Status='" & [Status] &"', 
    StatusName='" & choose([Status]+1;"OK";"a.k.";"DSQ";"DNF";"DNS";"n.a.") &"', 
    StartTime='" & if([Time3.Decimal]<>"";[Time3.Decimal];0) &"',
    FinishTime='" & if([Time1.Decimal]<>"";[Time1.Decimal];0) &"',
    SP1Time='" & if([Time11.Decimal]<>"";[Time11.Decimal];0) &"', 
    SP2Time='" & if([Time12.Decimal]<>"";[Time12.Decimal];0) &"',
    SP3Time='" & if([Time13.Decimal]<>"";[Time13.Decimal];0) &"',
    SP4Time='" & if([Time14.Decimal]<>"";[Time14.Decimal];0) &"',
    SP5Time='" & if([Time15.Decimal]<>"";[Time15.Decimal];0) &"',
    SP6Time='" & if([Time16.Decimal]<>"";[Time16.Decimal];0) &"',
    SP7Time='" & if([Time17.Decimal]<>"";[Time17.Decimal];0) &"',
    SP1Name='" & if([Time11.Name]<>"0";[Time11.Name];NULL) &"', 
    SP2Name='" & if([Time12.Name]<>"0";[Time12.Name];NULL) &"',
    SP3Name='" & if([Time13.Name]<>"0";[Time13.Name];NULL) &"',
    SP4Name='" & if([Time14.Name]<>"0";[Time14.Name];NULL) &"',
    SP5Name='" & if([Time15.Name]<>"0";[Time15.Name];NULL) &"',
    SP6Name='" & if([Time16.Name]<>"0";[Time16.Name];NULL) &"',
    SP7Name='" & if([Time17.Name]<>"0";[Time17.Name];NULL) &"',
    SP1Rank='" & if([Time11.Name]<>"0";[Rank11];NULL) &"', 
    SP2Rank='" & if([Time12.Name]<>"0";[Rank12];NULL) &"',
    SP3Rank='" & if([Time13.Name]<>"0";[Rank13];NULL) &"',
    SP4Rank='" & if([Time14.Name]<>"0";[Rank14];NULL) &"',
    SP5Rank='" & if([Time15.Name]<>"0";[Rank15];NULL) &"',
    SP6Rank='" & if([Time16.Name]<>"0";[Rank16];NULL) &"',
    SP7Rank='" & if([Time17.Name]<>"0";[Rank17];NULL) &"',
    NewArrival='1'"