Resultater

Velg konkurranse og løp direkte eller filtrer blant alle registrerte løp

 

/var/www/html/padling.juul.no/public_html/devs/include/class_competitor.php : 2339 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(601) "SQL: SELECT c.CompetitorId as cid, CONCAT(FirstName, ' ', LastName) as name, CONCAT(IF (LOCATE(' ', FirstName), CONCAT(SUBSTRING(FirstName, 1, LOCATE(' ', FirstName) + 1), '.'), FirstName), ' ', LastName, ', ', Clubs.ClubName, ' (', Birth, ' - ', YEAR(CURDATE()) - Birth, 'år)') as longname, cc.ClubId as Club, c.Gender as gender
FROM Competitors c
  LEFT JOIN CompetitorClubs cc
    ON cc.CompetitorId=c.CompetitorId AND cc.EndDate IS NULL
  JOIN Clubs
    ON cc.ClubId=Clubs.ClubId
ORDER BY name; having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"

2012 NC1, Tysvær

K-1 200m

Ungdom Herrer

Forsøk

Rekord 200m senior herrer: 
/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"

Banerekord 200m senior herrer: 35.22
Rekord 200m UH: 35.62
Banerekord 200m UH: 38.27
Olympisk rekord 200m herrer: London 2012 - Ed McKeever (GBR) 35.09
Verdensrekord 200m herrer: Plovdiv 2017 - Liam Heath (GBR) 33.38

Plass Navn
Klubb
 Tid/Status
1 Eigil Solvang
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
49.92
2 Hakeem Teland
Kristiansand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
49.96
3 Ingve Larsen
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
50.80
4 Stian Kallekodt
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
52.24
5 Tor Ernst Hofman
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
53.04
6 Sturla H. Christiansen
Kristiansand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
56.88
7 Ernst Chr. Leinum
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
56.92
8 Thor Gudmund Weisz
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=6657 --- referer:  : string(2919) "SQL: SELECT x.cid, x.firstname, x.lastname, x.club, x.gender as gender, x.racetype, x.class as class, x.length as length, x.place AS track, x.comp, x.compname, x.year, x.raceid, x.sid, x.no, x.hours, x.minutes, x.seconds, x.subseconds
FROM
(
SELECT sl.Startid, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM StartList sl
 LEFT JOIN Races
   ON sl.Race=Races.RaceId
 LEFT JOIN Results
   ON sl.StartId=Results.StartId
 LEFT JOIN StartingCompetitors sc
   ON sl.StartId=sc.StartId
 LEFT JOIN Competitors c
   ON c.CompetitorId=sc.Competitor
 LEFT JOIN Competitions
   ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL AND Results.SubSeconds IS NOT NULL AND Results.Seconds IS NOT NULL AND Results.Minutes IS NOT NULL AND Results.Hours IS NOT NULL   AND Races.Gender = 'Male' AND Races.Length = 200
ORDER BY time
limit 1
) t
INNER JOIN
(
SELECT c.CompetitorId AS cid, c.FirstName AS firstname, c.LastName AS lastname, cc.ClubId AS club, c.Gender AS gender, RaceType.RaceType AS racetype, Races.Class AS class, Races.Competition AS comp, Races.RaceId AS raceid, Place AS place, Competitions.CompetitionName AS compname, YEAR(Competitions.StartDate) as year, Results.StartId AS sid, Races.length as length, sl.No as no, Results.Hours AS hours, Results.Minutes AS minutes, Results.Seconds AS seconds, Results.SubSeconds AS subseconds, CONCAT(LPAD(Results.Hours, 1, '0'), LPAD(Results.Minutes, 2, '0'), LPAD(Results.Seconds, 2, '0'), LPAD(Results.SubSeconds, 2, '0')) as time
FROM Competitors c
LEFT JOIN CompetitorClubs cc
  ON cc.CompetitorId = c.CompetitorId AND cc.EndDate IS NULL
LEFT JOIN StartingCompetitors sc
  ON sc.Competitor = c.CompetitorId
LEFT JOIN Results
  ON Results.StartId = sc.StartId
JOIN StartList sl
  ON Results.StartId = sl.StartId
LEFT JOIN Races
  ON sl.Race = Races.RaceId
LEFT JOIN RaceType
  ON Races.RaceType=RaceType.Id
LEFT JOIN Competitions
  ON Races.Competition = Competitions.CompetitionId
WHERE Races.Competition >= 2 AND Races.NumPadlers = 1 AND dns = 0 AND dnf = 0 AND disqualified = 0 AND Races.DisregardPR = 0 AND length <= 1000 AND c.Country = 1 AND
  IF(length = 200, Competitions.disregardPR200=0,1) AND
  IF(length = 500, Competitions.disregardPR500=0,1) AND
  IF(length = 1000, Competitions.disregardPR1000=0,1) AND
  c.Gender IS NOT NULL
) as x
ON x.sid = t.StartId
ORDER BY hours, minutes, seconds, subseconds, raceid having problems
Call was:  Error writing file '/tmp/MYfd=317' (OS errno 28 - No space left on device)"
01:01.76
9 Herman Sørfang
Strand

DNS
Forrige løp
Neste løp