Prediction Archives And Past Football Matches Results

100% FREE access to expert's advice, predictions & betting tips on every football game!

SELECT, matches.start_date, matches.team1, matches.team2, matches.permalink, tournament_type.tournament, tournaments.year, matches.title, matches.introduction, matches.match_preview_img, matches.match_start_time,,, FROM `matches` inner join tournaments on matches.tournament_id = inner join tournament_type on tournaments.tournament_type_id = inner join stadium on matches.stadium_id = inner join country on stadium.country_id = inner join city on stadium.city_id = where matches.status = '1' and matches.end_date < '2019-11-13' order by DESC LIMIT 16 offset 0