SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('12.4540954','41.9074804'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(41.9074804 - a.lat) < 2 AND ABS(12.4540954 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(12.4540954, 41.9074804),4326),100*1000)) /* distance 100*/
HAVING sitemap_small =1 AND distance < 15
OR townsearch =1 AND sitemap_small = 0
ORDER BY sitemap_small DESC, townsearch DESC, distance ASC
LIMIT 1