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=8687 --- 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

Senior Herrer

Forsøk

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

Plass Navn
Klubb
 Tid/Status
1 Gunnar Eide
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:44.08
1 Amund Vold
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:44.37
1 Elias Hollingsæter
Bærum
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:46.78
2 Nicolai Lønning
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:45.52
2 Harald Ivarsen
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:46.56
2 Ivar Buch
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:47.40
3 Syver Saksvik
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:46.65
3 Lars Magne Ullvang
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:47.66
3 Mikkel Sjursen
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:52.37
4 Lucas Røsten
Strand
 

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

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:48.40
4 Børge Ivarsen
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:52.87
5 Felix Svanberg
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:47.88
5 Magnus Ivarsen
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:50.23
5 Gudmund Staupe
Tysvær
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:53.16
6 Håkon Hafstad
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:48.71
6 Lasse Lotsberg
Njørd
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:52.84
6 Even Sevaldsen
Strand
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:57.63
7 Niclas Karlsen
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:55.61
7 Kristjan Moi
Flekkefjord
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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.65
7 Øystein Andreassen
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:00.18
8 Nikolai Pedersen
Laksevåg
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:00.94
8 Jens-Ulrik Ruus Qvale
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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:03.93
8 Aleksander Otterstad
Fana
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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.16
9 Tobias Feght
Oslo
 

/var/www/html/padling.juul.no/public_html/devs/include/nc_functions.php : 1427 ---- call:/devs/results.phpraceid=8687 --- 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.68
9 Vemund Jensen
Bærum

DNS
Forrige løp
Neste løp