SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Chris Hartjes submitted this query on: March 31, 2008 4:06pm EDT | |
| TITLE | Get an itemized list of mid-game reports of field goal attempts |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT events.event_key, start_date_time, period_value, period_time_remaining, play_type, points, comment, display_names.full_name, american_football_action_participants.participant_role, american_football_action_participants.yardage, american_football_action_participants.score_credit from american_football_event_states, american_football_action_plays, american_football_action_participants, events, display_names where events.event_key like 'l.nfl.com-2007%' AND american_football_action_plays.play_type = 'field-goal' AND american_football_event_states.context = 'event-play' AND american_football_event_states.event_id = events.id AND american_football_action_plays.american_football_event_state_id = american_football_event_states.id AND american_football_action_participants.american_football_action_play_id = american_football_action_plays.id AND display_names.entity_type = 'persons' AND display_names.entity_id = american_football_action_participants.person_id |
| DESCRIPTION | Query creates a join between the american_football tables, events and display_names, otherwise you just get the player keys instead of the names |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |