SELECT 
m.matchID, t1.name AS team1, t2.name AS team2, t1.flagpic AS    flagpic1, t2.flagpic AS flagpic2, UNIX_TIMESTAMP(m.date) AS date, l.name AS location, m.team1ID, m.team2ID, r.s_team1 AS rs_team1, r.s_team2 AS rs_team2 
FROM matches AS m 
INNER JOIN teams AS t1 
ON m.team1ID = t1.teamID 
INNER JOIN teams AS t2 
ON m.team2ID = t2.teamID 
INNER JOIN locations AS l 
ON m.locationID = l.locationID 
LEFT OUTER JOIN results AS r 
ON r.matchID = m.matchID 
WHERE EXISTS (
   SELECT matchID FROM results WHERE matchID=m.matchID) 
ORDER BY m.date ASC LIMIT 5 ;

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS ( 
SELECT matchID
FROM results
WHERE matchID = m.matchID