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 'AND m.published = 1 ORDER BY r.ordering, r.roundcode' at line 19 SQL=SELECT DISTINCT(m.id), r.name AS roundname, r.id AS roundid, r.roundcode, m.show_report, m.cancel, m.cancel_reason, m.projectteam1_id, m.projectteam2_id, m.team1_result as e1, m.team2_result as e2, m.match_result_type as rtype, m.alt_decision as decision, m.team1_result_decision AS v1, m.team2_result_decision AS v2, m.new_match_id, m.old_match_id, tt1.division_id AS division_id FROM drzv1_joomleague_match AS m INNER JOIN drzv1_joomleague_round AS r ON r.id=m.round_id LEFT JOIN drzv1_joomleague_project_team AS tt1 ON m.projectteam1_id = tt1.team_id LEFT JOIN drzv1_joomleague_project_team AS tt2 ON m.projectteam2_id = tt2.team_id WHERE r.project_id = AND m.published = 1 ORDER BY r.ordering, r.roundcode