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
Your log.directory config setting does not point to a writable directory.