SELECT 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, content_type_property.field_sale_price_amount as POR 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 node.type = 'property' and (td.vid=1) and (td.tid = 3) AND ( CASE WHEN content_type_property.field_property_bedrooms_min_value = '' OR content_type_property.field_property_bedrooms_min_value = 0 OR content_type_property.field_property_bedrooms_min_value is NULL THEN content_type_property.field_property_bedrooms_max_value >= all AND content_type_property.field_property_bedrooms_max_value <= all WHEN content_type_property.field_property_bedrooms_max_value = '' OR content_type_property.field_property_bedrooms_max_value = 0 OR content_type_property.field_property_bedrooms_max_value is NULL THEN content_type_property.field_property_bedrooms_min_value >= all AND content_type_property.field_property_bedrooms_min_value <= all ELSE (content_type_property.field_property_bedrooms_min_value <= all AND content_type_property.field_property_bedrooms_max_value >= all ) OR (content_type_property.field_property_bedrooms_min_value <= all AND content_type_property.field_property_bedrooms_max_value >= all ) OR (content_type_property.field_property_bedrooms_min_value >= all AND content_type_property.field_property_bedrooms_max_value <= all ) END ) AND (tdt.tid = 73) GROUP BY node.nid ORDER BY content_type_property.field_property_bedrooms_min_value ASC