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

Football Database Search Results

Football Schedule Search Results

Back to Form

Showing 1 - 5 of 16 result(s).

2017-09-30	Sat	UCLA Bruins	Colorado Buffaloes	Rose Bowl
2017-10-07	Sat	Utah Utes	Stanford Cardinal	Rice-Eccles Stadium
2017-10-14	Sat	Stanford Cardinal	Oregon Ducks	Stanford Stadium
2017-10-21	Sat	UCLA Bruins	Oregon Ducks	Rose Bowl
2017-10-26	Thu	Oregon State Beavers	Stanford Cardinal	Reser Stadium
2017-09-09	Sat	USC Trojans	Stanford Cardinal	LA Memorial Coliseum

Back to Form