-- official scoring (right?)
SELECT rushing.*
FROM `stats` s
   LEFT JOIN `american_football_rushing_stats` rushing
      ON afs.id = s.stat_repository_id
WHERE 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