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 (840)
) AND uqsbx_posts.post_type = 'property' AND ((uqsbx_posts.post_status = 'publish')) AND (uqsbx_posts.ID IN (SELECT otr.object_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 ott.taxonomy IN('property-status') AND (ot.slug NOT IN('sold')) AND otr.object_id NOT IN(SELECT otr2.object_id FROM uqsbx_terms as ot2 JOIN uqsbx_term_relationships as otr2 ON otr2.term_taxonomy_id = ot2.term_id JOIN uqsbx_term_taxonomy as ott2 ON ott2.term_id=ot2.term_id WHERE ott2.taxonomy IN('property-status') AND (ot2.slug IN('sold')) AND otr2.object_id NOT IN(SELECT psold.post_id FROM uqsbx_postmeta as psold WHERE psold.meta_key='show_this_property' AND psold.meta_value='1')) ) OR uqsbx_posts.ID IN (SELECT otr.object_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 ott.taxonomy IN('property-status') AND (ot.slug IN('sold')) AND otr.object_id IN(SELECT psold.post_id FROM uqsbx_postmeta as psold WHERE psold.meta_key='show_this_property' AND psold.meta_value='1') ) ) 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(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('sold') AND ord_otr.object_id=uqsbx_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999998
, 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_840' 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_840' AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 1
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 (840)
) AND uqsbx_posts.post_type = 'property' AND ((uqsbx_posts.post_status = 'publish')) AND (uqsbx_posts.ID IN (SELECT otr.object_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 ott.taxonomy IN('property-status') AND (ot.slug NOT IN('sold')) AND otr.object_id NOT IN(SELECT otr2.object_id FROM uqsbx_terms as ot2 JOIN uqsbx_term_relationships as otr2 ON otr2.term_taxonomy_id = ot2.term_id JOIN uqsbx_term_taxonomy as ott2 ON ott2.term_id=ot2.term_id WHERE ott2.taxonomy IN('property-status') AND (ot2.slug IN('sold')) AND otr2.object_id NOT IN(SELECT psold.post_id FROM uqsbx_postmeta as psold WHERE psold.meta_key='show_this_property' AND psold.meta_value='1')) ) OR uqsbx_posts.ID IN (SELECT otr.object_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 ott.taxonomy IN('property-status') AND (ot.slug IN('sold')) AND otr.object_id IN(SELECT psold.post_id FROM uqsbx_postmeta as psold WHERE psold.meta_key='show_this_property' AND psold.meta_value='1') ) ) 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(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('sold') AND ord_otr.object_id=uqsbx_posts.ID AND ord_ott.taxonomy='property-status'
)>0, 999999999998
, 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_840') 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_840') AND property_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC LIMIT 0, 12
Beaulieu Village FPP Nursing Home, Termonfeckin Rd, Co. Louth, A92AODK
North Dublin Corporate Park, Swords, Co. Dublin, K67 W5P7
FPP for 72 Bed Nursing Home Loughaleen House and Lands, Murgasty Road, Co. Tipperary, E34 NW25
0.58 Hectares of Land at Johnstown Village, Co. Meath, C15 C9W6
Knockboyne House, Dublin Road, Co. Meath, C15 AE0
10·79 Acres at Knockumber, Co. Meath, C15 T8P6
Residential Development Land at Castlepark, Mallow, Co. Cork
Ringport Business Park, Ringaskiddy, Co. Cork, P43 RD32
17 Corrig Road, Sandyford Business Park, Dublin 18,, Sandyford, Dublin 18, D18 N6K8
Silchester View Upper Glenageary Road, Glenageary, Co. Dublin, A96 V4Y2
32 Francis Street, South City Centre, Dublin 8, D08 EK08
Unit 2 & 3 Richmond Road Industrial Estate, Richmond Road,, Fairview, Dublin 3, D03 RH98