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 7:14pm EST | |
| TITLE | Motor racing results extended |
|---|---|
| SPORTS | Motor Racing |
| QUERY | SELECT pe.rank, dn.full_name, p.person_key, mrrs.points, mrrs.laps_completed, mrrs.laps_leading_total, mrrs.money FROM motor_racing_race_stats mrrs JOIN stats s ON mrrs.id = s.stat_repository_id JOIN events e ON s.stat_coverage_id = e.id JOIN participants_events pe ON pe.event_id = e.id JOIN display_names dn ON pe.participant_id = dn.entity_id JOIN persons p ON pe.participant_id = p.id WHERE e.event_key = 'l.nascar.com.nextel-2007-e.687' AND dn.entity_type = 'persons' AND s.stat_repository_type = 'motor_racing_race_stats' AND s.stat_coverage_type = 'events' AND s.stat_holder_id = pe.participant_id ORDER BY pe.rank + 1; |
| DESCRIPTION | Contains post-race stats for a given event key. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |