SELECT node.nid as nid, node.title as ptitle , RR.field_nightly_rate_amount as NR FROM node INNER JOIN content_type_property AS cp ON node.nid = cp.nid INNER JOIN term_node AS tn ON cp.nid = tn.nid INNER JOIN term_data AS td ON tn.tid = td.tid INNER JOIN term_node tnd ON node.nid = tnd.nid INNER JOIN term_data tdt ON tdt.tid = tnd.tid LEFT JOIN content_field_r_property RP ON node.nid = RP.field_r_property_nid LEFT JOIN content_type_rental_rate RR ON RP.nid = RR.nid WHERE node.status <> 0 AND node.type = 'property' AND ( tn.tid = 1) AND cp.field_property_region_nid = 5005 GROUP BY node.nid ORDER BY NR DESC