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