16
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 5, 5;
Football Database Search Results

Football Schedule Search Results

Back to Form
Showing 6 - 10 of 16 result(s).
2017-10-28 Sat California Golden Bears Colorado Buffaloes California Memorial Stadium
2017-11-04 Fri Utah Utes UCLA Bruins Rice-Eccles Stadium
2017-11-04 Fri California Golden Bears Oregon State Beavers California Memorial Stadium
2017-11-18 Sat USC Trojans UCLA Bruins LA Memorial Coliseum
2001-01-01 Thu USC Trojans USC Trojans LA Memorial Coliseum
2017-09-09 Sat USC Trojans Stanford Cardinal LA Memorial Coliseum
Back to Form