172.31.13.245=53.339964=-6.2466117
Commercial Listing
Commercial Listing
SELECT SQL_CALC_FOUND_ROWS uqsbx_posts.ID FROM uqsbx_posts LEFT JOIN uqsbx_term_relationships ON (uqsbx_posts.ID = uqsbx_term_relationships.object_id) WHERE 1=1 AND (
uqsbx_term_relationships.term_taxonomy_id IN (2,834,835,836,837,838,839,840)
AND
uqsbx_posts.ID NOT IN (
SELECT object_id
FROM uqsbx_term_relationships
WHERE term_taxonomy_id IN (35)
)
) AND uqsbx_posts.post_type = 'property' AND ((uqsbx_posts.post_status = 'publish')) GROUP BY uqsbx_posts.ID ORDER BY (SELECT (6371 * acos(cos(radians(53.339964)) * cos(radians( city_latitude.meta_value)) * cos(radians(city_longitude.meta_value) - radians(-6.2466117)) + sin( radians(53.339964)) * sin(radians(city_latitude.meta_value)))) AS distance FROM
uqsbx_postmeta AS city_latitude
LEFT JOIN uqsbx_postmeta as city_longitude ON city_latitude.post_id = city_longitude.post_id
WHERE city_latitude.post_id=uqsbx_posts.ID AND city_latitude.meta_key = 'property_latitude' AND city_longitude.meta_key = 'property_longitude') LIMIT 0, 12
Warehouse/Light Industrial Unit, Unit 6 Watergrasshill Business Park, Watergrasshill, Cork
35 Merrion Square, South City Centre, Dublin 2, D02 KH30
12 Brunswick Place, Dublin 2 D02 PA09
10 Harmony Court, South City Centre, Dublin 2, D02 VY52
11a Baggot Street Lower, Dublin 2
Ground Floor and Basement, 12 Baggot Street Lower, Dublin 2
26 Pembroke Street Upper, Dublin 2
16 St Stephens Green, Dublin 2
3 Kingram Place, Dublin 2