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 '-1600,1600' at line 1SELECT * , (replace(LEFT(price,INSTR(price,',')-1),".","")+0) AS Prijs FROM vmobjects WHERE openhuis='1' and status='zichtbaar' ORDER BY Prijs ASC LIMIT -1600,1600