SELECT DISTINCT refdyn_player.player_key, stats_american_football_passing.passes_touchdowns,stats_american_football_passing.passes_interceptions,stats_american_football_passing.passes_yards_gross
FROM refdyn_player, stats_american_football_passing, map_stats_player, events
WHERE refdyn_player.player_key = map_stats_player.player_key
AND map_stats_player.stat_key = stats_american_football_passing.stat_key
AND map_stats_player.date_coverage_type = 'event'
AND events.event_key LIKE '%l.nfl.com%'
AND map_stats_player.date_coverage_value = events.event_key
AND events.start_date_time > '2007-12-05'
AND events.start_date_time < '2007-12-12'
ORDER BY refdyn_player.player_key";