SELECT days.days_name AS day, date, home.team_name AS home, away.team_name AS away, venue.venue_name AS venue FROM football_schedule LEFT JOIN days ON days.days_id = football_schedule.day LEFT JOIN teams AS home ON home.team_id = football_schedule.home_team LEFT JOIN teams AS away ON away.team_id = football_schedule.away_team LEFT JOIN venue ON venue.venue_id = football_schedule.venue WHERE 1 = 1 LIMIT 15, 5;

Football Database Search Results

Football Schedule Search Results

Back to Form

Showing 16 - 16 of 16 result(s).

2024-05-14	Thu	USC Trojans	California Golden Bears	Rose Bowl
2017-09-09	Sat	USC Trojans	Stanford Cardinal	LA Memorial Coliseum

Back to Form