SELECT link_id, a.lat, a.lon, a.map_name, townsearch, sitemap_small,st_distance_sphere(st_srid(point('-115.167604','36.1341269'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(36.1341269 - a.lat) < 2 AND ABS(-115.167604 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(-115.167604, 36.1341269),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('-115.167604','36.1341269'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(36.1341269 - a.lat) < 2 AND ABS(-115.167604 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(-115.167604, 36.1341269),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('-115.167604','36.1341269'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(36.1341269 - a.lat) < 2 AND ABS(-115.167604 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(-115.167604, 36.1341269),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('-115.167604','36.1341269'),4326),st_srid(point(a.lon,a.lat),4326)) / 1000 AS distance
FROM
-- sb.search_lat_lon a
locales a
WHERE
-- ABS(36.1341269 - a.lat) < 2 AND ABS(-115.167604 - a.lon) < 3
ST_Intersects(a.latlon, ST_BUFFER(st_srid(POINT(-115.167604, 36.1341269),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