172.31.37.173=39.04372=-77.48749
Commercial Listing
Commercial Listing
SELECT SQL_CALC_FOUND_ROWS uqsbx_2_posts.ID FROM uqsbx_2_posts LEFT JOIN uqsbx_2_term_relationships ON (uqsbx_2_posts.ID = uqsbx_2_term_relationships.object_id) LEFT JOIN uqsbx_2_term_relationships AS tt1 ON (uqsbx_2_posts.ID = tt1.object_id) WHERE 1=1 AND (
uqsbx_2_term_relationships.term_taxonomy_id IN (35)
AND
tt1.term_taxonomy_id IN (57)
AND
uqsbx_2_posts.ID NOT IN (
SELECT object_id
FROM uqsbx_2_term_relationships
WHERE term_taxonomy_id IN (59)
)
) AND uqsbx_2_posts.post_type = 'property' AND ((uqsbx_2_posts.post_status = 'publish')) GROUP BY uqsbx_2_posts.ID ORDER BY
CAST(
IF( (SELECT
COUNT(ord_ot.term_id)
FROM uqsbx_2_terms as ord_ot JOIN uqsbx_2_term_relationships as ord_otr ON ord_otr.term_taxonomy_id = ord_ot.term_id
JOIN uqsbx_2_term_taxonomy as ord_ott ON ord_ott.term_id=ord_ot.term_id
WHERE ord_ot.slug IN('sale-agreed','under-offer') AND ord_otr.object_id=uqsbx_2_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999999
, IF(
(SELECT COUNT(ot.term_id) FROM uqsbx_2_terms as ot JOIN uqsbx_2_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_2_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_2_posts.ID AND ott.taxonomy='property-location' LIMIT 1)>0,
(SELECT
CASE
WHEN ot.slug='cork' THEN 3
WHEN ot.slug='northern-ireland' THEN 1
WHEN ot.slug IS NULL THEN 4
WHEN ot.slug='' THEN 4
ELSE 2
END AS order_by_name
FROM uqsbx_2_terms as ot JOIN uqsbx_2_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_2_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_2_posts.ID AND ott.taxonomy='property-location'
GROUP BY otr.object_id
ORDER BY order_by_name LIMIT 1
), 5)
) AS SIGNED)
ASC , CAST( IF((SELECT COUNT(property_ordering.post_id) FROM uqsbx_2_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_35') AND property_ordering.post_id=uqsbx_2_posts.ID LIMIT 1)>0, (SELECT property_ordering.meta_value FROM uqsbx_2_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_35') AND property_ordering.post_id=uqsbx_2_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 12
Fairhill Shopping Centre, Ballymena, Co. Antrim, BT43 6UF
Bloomfield Shopping Centre & Retail Park, Bangor, Co. Down, BT19 7HB
Erneside Shopping Centre, Enniskillen, Co. Fermanagh, BT74 6JQ
ODYSSEY, Belfast, BT3 9QQ
Richmond Shopping Centre, Londonderry, Derry/Londonderry, BT48 6PE
67 High Street, Holywood, Co. Antrim, BT18 9AQ
Crescent Link Retail Park, Londonderry, Derry/Londonderry, BT47 6SA
52 Hill Street, Belfast, BT1 2LB
66 Main Street, Bangor, Co. Down, BT20 5AG
The Gateway, Co. Down, BT32 4LF
1st Floor 26 Newry Street, Co. Down, BT32 3HB
3B & 3C Dobbin Street, Armagh, Co. Armagh, BT61 7QN