Register | Login
Attackpoint - performance and training tools for orienteering athletes

Discussion: Results

in: X8A7; X8A7 > 2017-09-30

Oct 3, 2017 3:30 AM # 
bbrooke:
You are correct!

Date        Event           CourseID      RunnerName    Position
-----------------------------------------------------------------
02/04/2017  DTR SkiO        XL Ski-O      Graham Baird  1 / 1
02/05/2017  SMR SkiO        Long Ski-O    Graham Baird  1 / 3
04/15/2017  Chatfield       Red           Graham Baird  1 / 13
04/29/2017  Cherry Creek    Red           Graham Baird  1 / 12
05/14/2017  BCLP            Red           Graham Baird  1 / 13
06/03/2017  Buena Vista     Red           Graham Baird  1 / 12
06/03/2017  Buena Vista     Night-O Long  Graham Baird  1 / 14
06/17/2017  Observatory     Red           Graham Baird  1 / 16
07/08/2017  Elim/Aspen      Red           Graham Baird  1 / 7
07/29/2017  Manitou         Red           Graham Baird  1 / 19
08/12/2017  Round Mountain  Red           Graham Baird  1 / 12
09/09/2017  Tahosa          Red           Graham Baird  1 / 14
09/30/2017  Corn Maze       Corn Maze     Graham Baird  2 / 20


SELECT e.EventDate, r.EventID, r.CourseID, r.RunnerName, r.RunnerPosition, rr.TtlRunners
FROM rmoc_result r
  JOIN (select EventID, EventDate FROM rmoc_event WHERE EventID LIKE '2017%') e
    ON r.EventID = e.EventID
  JOIN (select EventID, CourseID, COUNT(RunnerName) as TtlRunners FROM rmoc_result GROUP BY EventID, CourseID) rr
    ON r.EventID = rr.EventID AND r.CourseID = rr.CourseID
WHERE r.RunnerName = 'Graham Baird'
ORDER BY e.EventDate;
Advertisement  

Please login to add a message.