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 published=1 AND alt_decision=0 AND t1.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t1.id= ORDER BY (matchpart1_result-matchpart2_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t1.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t1.id= ORDER BY (matchpart1_result-matchpart2_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t1.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t1.id= ORDER BY (matchpart2_result-matchpart1_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t1.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t1.id= ORDER BY (matchpart2_result-matchpart1_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t2.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t2.id= ORDER BY (matchpart1_result-matchpart2_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t2.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t2.id= ORDER BY (matchpart1_result-matchpart2_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t2.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t2.id= ORDER BY (matchpart2_result-matchpart1_result) DESC LIMIT 0,1You 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 published=1 AND alt_decision=0 AND t2.id= ' at line 9 SQL=SELECT t1.name AS hometeam, t2.name AS awayteam, matchpart1_result AS homegoals, matchpart2_result AS awaygoals FROM jos_joomleague_matches as matches LEFT JOIN jos_joomleague_teams t1 ON t1.id = matches.matchpart1 LEFT JOIN jos_joomleague_teams t2 ON t2.id = matches.matchpart2 WHERE project_id = AND published=1 AND alt_decision=0 AND t2.id= ORDER BY (matchpart2_result-matchpart1_result) DESC LIMIT 0,1