An Error Was Encountered

Error Number: 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((l.latitude*pi()/180))+cos((*pi()/180)) * cos((l.latitude*pi()' at line 1

select concat('0') as other, (((acos(sin((*pi()/180)) * sin((l.latitude*pi()/180))+cos((*pi()/180)) * cos((l.latitude*pi()/180)) * cos(((- l.longitude)*pi()/180))))*180/pi())*60*1.1515) as distance, p.provider_id, p.provider_type, p.profile_image, f.url_name, f.firm_name, l.location_short,, l.location_short AS City, l.location_short AS City2, p.is_vc,f.description FROM service_infos si INNER JOIN provider2locations p2l ON si.provider_id = p2l.provider_id INNER JOIN provider_locations l ON p2l.location_id = l.location_id INNER JOIN profiles f ON si.provider_id = f.provider_id INNER JOIN providers p ON si.provider_id = p.provider_id WHERE si.cat_id= '1' AND'TR' AND f.profile_state=2 AND p.account_plan>2 AND si.provider_id<>1030447 GROUP BY si.provider_id order by distance asc limit 3