QUERY: SELECT furnaceCreekEntrant2007.*,
furnaceCreekDivision.*, ageGroup.ageGroupName,
eventDivisionTime.startTime AS wave_time,
stateProv.stateProv_name,
c.country_name AS c_name, n.country_name AS n_name
FROM (furnaceCreekEntrant2007, furnaceCreekDivision, ageGroup, eventDivisionTime)
LEFT JOIN country AS c ON
furnaceCreekEntrant2007.country_code_stamp = c.country_code
LEFT JOIN country AS n ON
furnaceCreekEntrant2007.nationality_stamp = n.country_code
LEFT OUTER JOIN stateProv ON
furnaceCreekEntrant2007.stateProv_id_stamp = stateProv.stateProv_id
WHERE furnaceCreekEntrant2007.bib='Kites' AND furnaceCreekEntrant2007.status < 5
AND furnaceCreekEntrant2007.division_id=furnaceCreekDivision.division_id
AND furnaceCreekEntrant2007.ageGroup_id=ageGroup.ageGroup_id
AND furnaceCreekDivision.division_id=eventDivisionTime.division_id
AND eventDivisionTime.event_id='2'
Start Time: 09:00Category: Four Mixed |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Joan GrantGender: FemaleAge: 27City: SunnyvaleState: CaliforniaCountry: United StatesNationality: CanadaVeteran: NoAge Group: 40+Rider Order: C |
Robert KraenckeGender: MaleAge: 51City: San JoseState: CaliforniaCountry: United StatesNationality: United StatesVeteran: NoAge Group: 40+Rider Order: A |
Leslie MackenzieGender: FemaleAge: 43City: Santa ClaraState: CaliforniaCountry: United StatesNationality: United StatesVeteran: NoAge Group: 40+Rider Order: B |
Dan SauersGender: MaleAge: 56City: SunnyvaleState: CaliforniaCountry: United StatesNationality: United StatesVeteran: NoAge Group: 40+Rider Order: D |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Time Station | Miles into the Race |
Arrival Date |
Arrival Time |
Elapsed Time |
Avg Speed | Time from Last Station |
Avg Speed From Last Station (mph) |
Note |
|---|---|---|---|---|---|---|---|---|
| California City | 83.6 | 10/06 | 14:22 | 05:22:00 | 15.58 | 05:22:00 | 15.58 | |
| Trona | 153.9 | 10/06 | 18:36 | 09:36:00 | 16.03 | 04:14:00 | 16.60 | |
| Furnace Creek | 253.2 | 10/07 | 02:12 | 17:12:00 | 14.72 | 07:36:00 | 13.06 | |
| Shoshone | 326.7 | 10/07 | 06:40 | 21:40:00 | 15.08 | 04:28:00 | 16.46 | |
| Baker | 382.9 | 10/07 | 09:18 | 24:18:00 | 15.76 | 02:38:00 | 21.37 | |
| Kelso | 416.5 | 10/07 | 11:41 | 26:41:00 | 15.61 | 02:23:00 | 14.08 | |
| Almost Amboy | 451.6 | 10/07 | 13:35 | 28:35:00 | 15.80 | 01:54:00 | 18.50 | |
| Finish | 508.5 | 10/07 | 17:21 | 32:21:06 | 15.72 | 03:46:06 | 15.09 |