football: view_matches

Custom SQL query returning 100 rows (hide)

SELECT m.match_id, t1.name AS home, t2.name AS away, m.home_score || ' - ' || m.away_score AS score, m.date, s.season_name, c.name AS competition FROM match m JOIN team t1 ON m.home_team_id = t1.team_id JOIN team t2 ON m.away_team_id = t2.team_id JOIN season s ON m.season_id = s.season_id JOIN competition c ON s.competition_id = c.competition_id ORDER BY m.date DESC LIMIT 100

Edit SQL