All pastes #737608 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-10-15 15:29 UTC
rendered paste body
-- official scoring (right?)SELECT rushing.*FROM `stats` s   LEFT JOIN `american_football_rushing_stats` rushing      ON afs.id = s.stat_repository_idWHERE s.stat_holder_type = "persons"       AND s.stat_holder_id = 6632 -- L. Tomlinson      AND s.stat_coverage_type = "events"       AND s.stat_coverage_id = 6183 -- Raiders-Chargers 2007 Week 6      AND s.context = "event"      AND s.stat_repository_type =  "american_football_rushing_stats"\G