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=8701 --- 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=360' (OS errno 28 - No space left on device)"

2023 NC5, Tysvær

K-1 500m

14 Gutter

Finale

Rekord 500m senior herrer: 
/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"

Banerekord 500m senior herrer:
Rekord 500m G14: 01:51.00
Banerekord 500m G14: 01:56.90
Verdensrekord 500m herrer: Szeged 2019 - Tom Liebscher (ROM) 01:35.04

Plass Navn
Klubb
 Tid/Status
1 Fredrik Wigaard
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
01:56.90
2 Leon Lilledrange
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:12.32
3 Olav Nikolai Linnes-Hirsti
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:15.84
4 Endre Vatnar
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:17.14
5 Jørgen Osen
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:21.81
6 Aksel Sending
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:21.96
7 Oliver Pottmeyer Sneddon
Bærum
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:22.04
8 Noah Dyrhol
Kristiansand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:22.54
9 David Raa
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:27.92
10 Conrad Østtorp
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:29.50
11 Zacharias Fostad
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:34.07
12 Leonard Sørli
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:34.19
13 Adrian Karlsen Supphellen
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:46.16
14 Sverre Vatland
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:51.04
15 Daniel Bjørkheim Erland
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8701 --- 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=360' (OS errno 28 - No space left on device)"
02:52.91
Forrige løp
Neste løp