Prediction Archives And Past Football Matches Results

SELECT matches.id, 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, stadium.name, country.country, city.city FROM `matches` inner join tournaments on matches.tournament_id = tournaments.id inner join tournament_type on tournaments.tournament_type_id = tournament_type.id inner join stadium on matches.stadium_id = stadium.id inner join country on stadium.country_id = country.id inner join city on stadium.city_id = city.id where matches.status = '1' and matches.end_date < '2019-07-20' order by matches.id DESC LIMIT 16 offset 0