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

2017 NC3, Gravdalsvannet

K-1 500m

Ungdom Herrer

Finale

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

Plass Navn
Klubb
 Tid/Status
1 Martin Schmidt
Njørd
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:04.36
2 Kristoffer Mjelstad
Njørd
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:05.12
3 Sander Askeland
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:05.78
4 Christoffer Juul
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:06.48
5 Aslak Jensen
Bærum
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:09.44
6 Eirik Usland-Gade
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:10.85
7 Gard Frengstad
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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.10
8 August Gislerud Rolfsen
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:13.83
9 Tobias F. Lægreid
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:18.52
10 Leander Helgesen
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:14.71
11 Karl Kristian Kyvik
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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.44
12 Andreas Lysne
Bærum
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:24.51
13 Holger Stinessen
Njørd
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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.40
14 Mats Tønnesland
Kristiansand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:30.10
15 Mads Johannesen Helgeland
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:36.34
16 Christoffer Opsahl Kolgrov
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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:38.73
17 Sigurd Worren
Kristiansand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=830 --- 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)"
03:00.31
Forrige løp