Error in /jobsearch/bytown/channelisles-jersey.htm(): (err #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 'Easting)-LEAST(,Easting))*(GREATEST(,Easting)-LEAST(,Easting))+(GREATEST(,Northi' at line 1
SELECT SQL_CALC_FOUND_ROWS ID, CompanyID, Live, DATE_FORMAT(Posted, '%d/%m/%Y') as PostedString, Title, Salary, LocationInfo, CONCAT('http://www.vacancycentral.co.uk/jobdetails.php?jobid=',ID) as JobURL FROM VCJobs vj LEFT JOIN PostcodeCoordsOutward pco ON vj.LocationPostCode = pco.PostCode WHERE Live = 1 AND MATCH(PostCodes)AGAINST(',JE1,JE2,JE3,JE4,') AND Posted < NOW() GROUP BY vj.ID ORDER BY ACLocationID = 'channelisles-jersey' DESC, ((SQRT((GREATEST(,Easting)-LEAST(,Easting))*(GREATEST(,Easting)-LEAST(,Easting))+(GREATEST(,Northing)-LEAST(,Northing))*(GREATEST(,Northing)-LEAST(,Northing)))*0.621371192)/100)*(LocationPostCode=''*1000000) ASC, Posted DESC LIMIT 0, 40
