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 10, 5;

Football Database Search Results

Football Schedule Search Results

Back to Form

Showing 11 - 15 of 16 result(s).

2001-01-01	Thu	USC Trojans	USC Trojans	LA Memorial Coliseum
2001-01-01	Thu	USC Trojans	USC Trojans	LA Memorial Coliseum
2001-01-01	Thu	USC Trojans	USC Trojans	LA Memorial Coliseum
0002-01-01	Thu	USC Trojans	USC Trojans	LA Memorial Coliseum
1978-01-29	Thu	California Golden Bears	Stanford Cardinal	California Memorial Stadium
2017-09-09	Sat	USC Trojans	Stanford Cardinal	LA Memorial Coliseum

Back to Form