Error in /agencysearch/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 DISTINCT desJobRole, PostCode, DATE_FORMAT(SignUpDate, '%D %M %Y') as dayStr, (SQRT((GREATEST(,Easting)-LEAST(,Easting))*(GREATEST(,Easting)-LEAST(,Easting))+(GREATEST(,Northing)-LEAST(,Northing))*(GREATEST(,Northing)-LEAST(,Northing)))*0.621371192)/100 as Distance FROM VCImport WHERE (SQRT((GREATEST(,Easting)-LEAST(,Easting))*(GREATEST(,Easting)-LEAST(,Easting))+(GREATEST(,Northing)-LEAST(,Northing))*(GREATEST(,Northing)-LEAST(,Northing)))*0.621371192)/100 < TravelDist ORDER BY DATE_FORMAT(SignUpDate, '%Y%j') DESC, Distance ASC LIMIT 25
