An error occurred while trying to run your query.<br>
Error message: DB Error: syntax error<br>
A more detailed error description: <b>select matches.ID, year, DATE_FORMAT(matches.date,'%m-%d') as date, type, matches.course as theCourse,matches.story,CASE WHEN type<>'Singles' AND g1a.id= THEN CONCAT(g1b.lastname,SUBSTRING(g1b.firstname,1,1)) WHEN type<>'Singles' AND g1b.id= THEN CONCAT(g1a.lastname,SUBSTRING(g1a.firstname,1,1)) WHEN type<>'Singles' AND g2a.id= THEN CONCAT(g2b.lastname,SUBSTRING(g2b.firstname,1,1)) WHEN type<>'Singles' AND g2b.id= THEN CONCAT(g2a.lastname,SUBSTRING(g2a.firstname,1,1)) ELSE ''END AS partner,CASE WHEN g1a.id= OR g1b.id= THEN CONCAT(g2a.lastname,SUBSTRING(g2a.firstname,1,1)) ELSE CONCAT(g1a.lastname,SUBSTRING(g1a.firstname,1,1)) END AS opponentA,CASE WHEN type='Singles' THEN ''WHEN g1a.id= OR g1b.id= THEN CONCAT(g2b.lastname,SUBSTRING(g2b.firstname,1,1)) ELSE CONCAT(g1b.lastname,SUBSTRING(g1b.firstname,1,1)) END AS opponentB,CASE WHEN winner=0 THEN 'Halve'WHEN (g1a.id= OR g1b.id=) AND winner=1 THEN 'Win'WHEN (g2a.id= OR g2b.id=) AND winner=2 THEN 'Win'ELSE 'Loss'END AS result,margin from matches LEFT JOIN golfers as g1a ON matches.team1a=g1a.id LEFT JOIN golfers as g1b ON matches.team1b=g1b.id LEFT JOIN golfers as g2a ON matches.team2a=g2a.id LEFT JOIN golfers as g2b ON matches.team2b=g2b.id WHERE (matches.team1a= OR matches.team1b= OR matches.team2a= OR matches.team2b=) ORDER BY year DESC ,date DESC, matches.ID DESC [nativecode=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 'THEN CONCAT(g1b.lastname,SUBSTRING(g1b.firstname,1,1)) WHEN type<>'Singles' AND ' at line 1]</b><br>