SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Casey Trauer submitted this query on: January 30, 2009 6:43pm EST | |
| TITLE | Motor racing qualifying results and pole position |
|---|---|
| SPORTS | Motor Racing |
| QUERY | SELECT mrqs.qualifying_position, dn.full_name, p.person_key, mrqs.qualifying_time FROM motor_racing_qualifying_stats mrqs JOIN stats s ON s.stat_repository_id = mrqs.id JOIN events e ON s.stat_coverage_id = e.id JOIN display_names dn ON s.stat_holder_id = dn.entity_id JOIN persons p ON s.stat_holder_id = p.id WHERE e.event_key = 'l.nascar.com.nextel-2007-e.687' AND s.stat_repository_type = 'motor_racing_qualifying_stats' AND s.stat_coverage_type = 'events' AND dn.entity_type = 'persons' ORDER BY mrqs.qualifying_position + 1; |
| DESCRIPTION | Qualifying results for a NASCAR event. Requires event key. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |