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=8774 --- 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)"

2023 NC5, Tysvær

K-1 500m

12 Gutter

Forsøk

Rekord 500m senior herrer: 
/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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 500m senior herrer:
Rekord 500m G12:
Banerekord 500m G12:
Verdensrekord 500m herrer: Szeged 2019 - Tom Liebscher (ROM) 01:35.04

Plass Navn
Klubb
 Tid/Status
1 Neo Meyer
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:38.86
1 Matteus Lønning
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:47.00
1 Eirik Tingvatn-losnegaard
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:51.83
2 Ulrik Karlsen
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:43.35
2 Jonathan Gathe Mo
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:50.00
2 Mika Andersen-Østberg
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:52.17
3 Njord Schønberg
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:46.27
3 Vegard Langø Slogvik
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:54.00
3 Danylo Shvedai
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:57.91
4 Ailo Andersen-Østberg
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:55.00
4 Severin Vatland
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
02:58.32
4 Felix Lønning-Odland
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:04.24
5 William Tegnander Haneberg
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:05.97
5 Iver Oskar Iversen
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:14.06
5 Johannes Øvretveit Rød
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:18.00
6 Markus Standal Søvik
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:10.98
6 Heine Schønberg
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:19.92
6 Olander Pedersen
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8774 --- 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 = 500
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)"
03:44.00
7 Odin Sverdrup
Laksevåg

DNS
Forrige løp
Neste løp