Error: Incorrect arguments to st_distance_sphere.
Код: Выделить всё
SELECT patch, x.id, type, geo_address, place_name, x(coordinates) as lat, y(coordinates) as lng, x.updated_at, x.created_at, x.distance FROM
(SELECT * ,(ST_Distance_Sphere(ST_GeomFromText('POINT(42 103.68)') , coordinates, 6373)) AS distance FROM geo ) x
LEFT JOIN images i ON (x.id = i.geo_id)