Junior Camp Aldershot Sprint

Tue 30 Nov 1999

Event Type - State Schools/Junior

Show: [Leg Times] [Cumulative] [Both]

Back to summary

Sprint 1 2.30 km 8 C

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1172 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1172 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1039 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1039 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1036 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1036 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1816 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1816 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=396 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=396 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=682 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=682 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1168 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1168 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1174 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1174 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1064 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1064 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Query failed - SELECT st.time, sc.controlNumber FROM tim_Split_Controls sc LEFT JOIN tim_Split_Times st ON sc.controlNumber=st.controlNumber AND sc.courseID=st.courseID AND sc.controlOrder=st.controlOrder AND st.competitorID=1170 WHERE sc.courseID=6441 ORDER BY sc.controlOrder

Failed - SELECT time, controlNumber FROM tim_Split_Times WHERE competitorID=1170 AND courseID=6441 AND controlOrder >= 0 ORDER BY controlOrder

Pl	Name	Class	Time	Rate	1 (31)	2 (32)	3 (33)	4 (34)	5 (40)	6 (35)	7 (36)	8 (37)	Fin
1	Max Neumann	S1	11.34	5.03
2	Chris Firman	S1	12.38	5.49
3	Aaron Breed	S1	13.36	5.91
4	Andrew Warwick	S1	17.00	7.39
5	David Tay	S1	17.55	7.79
6	Su Yan Tay	S1	21.12	9.22
7	Simeon Burrill	S1	21.59	9.56
	Mitchell Neumann	S1	----	----
	David Firman	S1	----	----
	Jack Neumann	S1	----	----

Sprint 2 2.30 km 8 C

Query failed - SELECT controlNumber FROM tim_Split_Controls WHERE courseID=6442 ORDER BY controlOrder

Query failed - SELECT sr.competitorID, co.givennames, co.surname, sr.time, sr.classifier, sr.class FROM tim_Split_Results sr, tim_Competitors co WHERE sr.competitorID=co.competitorID AND sr.courseID=6442 ORDER BY sr.classifier ASC, sr.time ASC

Sprint 3 2.30 km 8 C

Query failed - SELECT controlNumber FROM tim_Split_Controls WHERE courseID=6443 ORDER BY controlOrder

Query failed - SELECT sr.competitorID, co.givennames, co.surname, sr.time, sr.classifier, sr.class FROM tim_Split_Results sr, tim_Competitors co WHERE sr.competitorID=co.competitorID AND sr.courseID=6443 ORDER BY sr.classifier ASC, sr.time ASC

Sprint 4 2.30 km 8 C

Query failed - SELECT controlNumber FROM tim_Split_Controls WHERE courseID=6444 ORDER BY controlOrder

Query failed - SELECT sr.competitorID, co.givennames, co.surname, sr.time, sr.classifier, sr.class FROM tim_Split_Results sr, tim_Competitors co WHERE sr.competitorID=co.competitorID AND sr.courseID=6444 ORDER BY sr.classifier ASC, sr.time ASC