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: June 01, 2009 6:34pm EDT | |
| TITLE | Get starting pitchers for game |
|---|---|
| SPORTS | Baseball |
| QUERY | SELECT p.person_key, dn.first_name, dn.last_name, t.team_key FROM person_event_metadata pem JOIN events e ON e.id = pem.event_id JOIN positions pos ON pem.position_id = pos.id JOIN persons p ON p.id = pem.person_id JOIN teams t ON pem.team_id = t.id JOIN display_names dn ON dn.entity_id = pem.person_id WHERE e.event_key = 'l.mlb.com-2009-e.24780' AND pem.status = 'starter' AND pos.abbreviation = '1' AND dn.entity_type = 'persons'; |
| DESCRIPTION | Retrieves starting pitcher names and keys. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |