SELECT * FROM light JOIN header ON light.pageId = header.pageId WHERE header.hdType != 'm' AND light.ltLat > -23.009849333333 AND light.ltLat < -22.993182666667 AND light.ltLng > -0.0083333333333333 AND light.ltLng < 0.0083333333333333 ORDER BY ((light.ltLat - -23.001516) * (light.ltLat - -23.001516) + (light.ltLng - ) * (light.ltLng - )) ; - 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 ') * (light.ltLng - ))' at line 1