QUERY: SELECT furnaceCreekEntrant2008.*,
furnaceCreekDivision.*, ageGroup.ageGroupName,
eventDivisionTime.startTime AS wave_time,
stateProv.stateProv_name,
c.country_name AS c_name, n.country_name AS n_name
FROM (furnaceCreekEntrant2008, furnaceCreekDivision, ageGroup, eventDivisionTime)
LEFT JOIN country AS c ON
furnaceCreekEntrant2008.country_code_stamp = c.country_code
LEFT JOIN country AS n ON
furnaceCreekEntrant2008.nationality_stamp = n.country_code
LEFT OUTER JOIN stateProv ON
furnaceCreekEntrant2008.stateProv_id_stamp = stateProv.stateProv_id
WHERE furnaceCreekEntrant2008.bib='Blue Footed Booby' AND furnaceCreekEntrant2008.status < 5
AND furnaceCreekEntrant2008.division_id=furnaceCreekDivision.division_id
AND furnaceCreekEntrant2008.ageGroup_id=ageGroup.ageGroup_id
AND furnaceCreekDivision.division_id=eventDivisionTime.division_id
AND eventDivisionTime.event_id='24'
Start Time: 09:00Category: Four Woman Fixed Gear |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Megan DeanGender: FemaleAge: 24City: Los AngelesState: CaliforniaCountry: United StatesNationality: United StatesVeteran: YesAge Group: 20+Rider Order:Charity: Sea Shepherd Conservation Society.Website: http://mothattackbikes.blogspot.com/ |
Jennifer GreenbergGender: FemaleAge: 23City: Los AngelesState: CaliforniaCountry: United StatesNationality: United StatesVeteran: NoAge Group: 20+Rider Order:Charity: Sea Shepherd Conservation Society.Website: http://www.specializedriders.com/profile/view/21583 |
Jay NadeauGender: FemaleAge: 37City: Los AngelesState: CaliforniaCountry: United StatesNationality: CanadaVeteran: NoAge Group: 20+Rider Order:Charity: Sea Shepherd Conservation Society. |
Beatriz RodriguezGender: FemaleAge: 21City: Los AngelesState: CaliforniaCountry: United StatesNationality: United StatesVeteran: NoAge Group: 20+Rider Order:Charity: Sea Shepherd Conservation Society. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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/04 | 13:54 | 04:54:00 | 17.06 | 04:54:00 | 17.06 | |
| Trona | 153.8 | 10/04 | 17:25 | 08:25:00 | 18.27 | 03:31:00 | 19.96 | |
| Furnace Creek | 252.9 | 10/04 | 23:53 | 14:53:00 | 16.99 | 06:28:00 | 15.33 | |
| Shoshone | 326.4 | 10/05 | 05:31 | 20:31:00 | 15.91 | 05:38:00 | 13.05 | |
| Baker | 382.6 | 10/05 | 09:17 | 24:17:00 | 15.76 | 03:46:00 | 14.93 | |
| Kelso | 417.6 | 10/05 | 11:38 | 26:38:00 | 15.68 | 02:21:00 | 14.86 | |
| Almost Amboy | 451.3 | 10/05 | 13:39 | 28:39:00 | 15.75 | 02:01:00 | 16.74 | |
| Finish | 509.6 | 10/05 | 17:28 | 32:28:05 | 15.69 | 03:49:05 | 15.26 |