Yellow Pages

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((*pi()/180)) * cos((latitude*pi()/180' at line 1

SELECT slno, state_name, url, (((acos(sin((*pi()/180)) * sin((latitude*pi()/180))+cos((*pi()/180)) * cos((latitude*pi()/180)) * cos(((- longitude)* pi()/180))))*180/pi())*60*1.1515) as distance FROM state where city_level = 2 || territories_status = 'Y' ORDER BY distance ASC LIMIT 6

[TEP STOP]