SELECT node.created as pcreated, node.nid as nid, node.title as ptitle , min(content_type_property.field_sale_min_amount) as NR , min(content_type_property.field_sale_max_amount) as NR_max FROM node INNER JOIN term_node tnd ON node.nid = tnd.nid INNER JOIN term_data tdt ON tdt.tid = tnd.tid inner join term_node tn on (tn.nid=node.nid) inner join term_data td on (tn.tid=td.tid) LEFT JOIN content_field_r_property RP ON node.nid = RP.field_r_property_nid LEFT JOIN content_type_property ON node.vid = content_type_property.vid WHERE node.status <> 0 AND content_type_property.field_property_frontend_display_value=1 AND node.type = 'property' and (td.vid=1) and (td.tid = 3) AND (content_type_property.field_property_status_value = 'For Sale') AND (tdt.tid = 84) GROUP BY node.nid ORDER BY NR ASC propertySearchSales
20 Properties found.

Can’t find a specific Property?