SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Alan Karben submitted this query on: March 23, 2008 11:19am EDT | |
| TITLE | Get official post-game stats for one player for one particular game |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT persons.person_key, display_names.full_name, american_football_passing_stats.passes_attempts, american_football_passing_stats.passes_completions, american_football_passing_stats.passes_percentage, american_football_passing_stats.passes_yards_gross, american_football_passing_stats.passes_longest, american_football_passing_stats.passes_touchdowns, american_football_passing_stats.passes_interceptions FROM stats, persons, american_football_passing_stats, display_names, events WHERE persons.person_key = 'l.nfl.com-p.400' AND events.event_key = 'l.nfl.com-2007-e.2154' AND stats.stat_repository_type = 'american_football_passing_stats' AND stats.stat_repository_id = american_football_passing_stats.id AND stats.stat_holder_type = 'persons' AND stats.stat_holder_id = persons.id AND stats.stat_coverage_type = 'events' AND stats.stat_coverage_id = events.id AND stats.context = 'event' AND display_names.entity_type = 'persons' AND display_names.entity_id = persons.id ; |
| DESCRIPTION | Using this value instead of the above: (AND stats.context = 'event-play') should get you Manning's unofficial mid-game stats |
| DBs TESTED | MS SQL |
| ADDITIONAL NOTES | |