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 (867)
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
CAST(
IF( (SELECT
COUNT(ord_ot.term_id)
FROM uqsbx_terms as ord_ot JOIN uqsbx_term_relationships as ord_otr ON ord_otr.term_taxonomy_id = ord_ot.term_id
JOIN uqsbx_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_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999999
, IF(
(SELECT COUNT(ot.term_id) FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_posts.ID AND ott.taxonomy='property-location' LIMIT 1)>0,
(SELECT
CASE
WHEN ot.slug='cork' THEN 2
WHEN ot.slug='northern-ireland' THEN 3
WHEN ot.slug IS NULL THEN 4
WHEN ot.slug='' THEN 4
ELSE 1
END AS order_by_name
FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_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_postmeta as property_ordering WHERE property_ordering.meta_key='property_ordering_category_867' AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT property_ordering.meta_value FROM uqsbx_postmeta as property_ordering WHERE property_ordering.meta_key='property_ordering_category_867' AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 1
Residential Listing
Residential 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 (867)
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
CAST(
IF( (SELECT
COUNT(ord_ot.term_id)
FROM uqsbx_terms as ord_ot JOIN uqsbx_term_relationships as ord_otr ON ord_otr.term_taxonomy_id = ord_ot.term_id
JOIN uqsbx_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_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999999
, IF(
(SELECT COUNT(ot.term_id) FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_posts.ID AND ott.taxonomy='property-location' LIMIT 1)>0,
(SELECT
CASE
WHEN ot.slug='cork' THEN 2
WHEN ot.slug='northern-ireland' THEN 3
WHEN ot.slug IS NULL THEN 4
WHEN ot.slug='' THEN 4
ELSE 1
END AS order_by_name
FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_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_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_867') AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT property_ordering.meta_value FROM uqsbx_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_867') AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 12
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 (867)
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
CAST(
IF( (SELECT
COUNT(ord_ot.term_id)
FROM uqsbx_terms as ord_ot JOIN uqsbx_term_relationships as ord_otr ON ord_otr.term_taxonomy_id = ord_ot.term_id
JOIN uqsbx_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_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999999
, IF(
(SELECT COUNT(ot.term_id) FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_posts.ID AND ott.taxonomy='property-location' LIMIT 1)>0,
(SELECT
CASE
WHEN ot.slug='cork' THEN 2
WHEN ot.slug='northern-ireland' THEN 3
WHEN ot.slug IS NULL THEN 4
WHEN ot.slug='' THEN 4
ELSE 1
END AS order_by_name
FROM uqsbx_terms as ot JOIN uqsbx_term_relationships as otr ON otr.term_taxonomy_id = ot.term_id
JOIN uqsbx_term_taxonomy as ott ON ott.term_id=ot.term_id
WHERE otr.object_id=uqsbx_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_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_867') AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT property_ordering.meta_value FROM uqsbx_postmeta as property_ordering WHERE (property_ordering.meta_key='property_ordering_category_867') AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 12
Apt 2 Burleigh Court Burlington Road, Ballsbridge, Dublin 4, D04 WD50
3 Orwell Lodge
77 Orwell Road
Rathgar
Dublin 6
6 Turnstone
Thornwood
Booterstown
14 Dunluce
Anglesea Road
Dublin 4
26 The Linden Riversdale, Dundrum, Dublin 16, D16 NX44
25 The Linden Riversdale, Dundrum, Dublin 16, D16 T2R6
84 Leeson Street Upper
Ballsbridge
Dublin 4
Apt.388 The Oaks Trimbleston, Goatstown, Dublin 14, D14 K236
11 Eastmoreland Court
Ballsbridge
Dublin 4
Apt.10 House 8, Linden Square, Blackrock, Co. Dublin, A94 E373
Apt.11 Wingfield Cruagh Manor, Stepaside, Dublin 18, D18 T297
49 The Dickens
The Gasworks
Dublin 4