1064 - 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 '°*pi()/180)) * sin((latitude*pi()/180))+cos((25.2838°*pi()/180)) * cos((la' at line 1

SELECT a1.city_id, a1.city_lable, a1.full_file_name, a1.city_name, a1.disp_city_name, (((acos(sin((25.2838°*pi()/180)) * sin((latitude*pi()/180))+cos((25.2838°*pi()/180)) * cos((latitude*pi()/180)) * cos(((83.1156°- longitude)* pi()/180))))*180/pi())*60*1.1515) as distance FROM state_city as a1, state_city_cnt as b1 where a1.city_id=b1.city_id and a1.city_id NOT IN ('35247', '4389') && a1.city_lable IN ('4','5') && b1.cnt>2 && b1.type='116' group by b1.city_id HAVING distance <10 order by distance ASC limit 0, 10

[TEP STOP]