SELECT node.nid as nid, node.title as ptitle , min(RR.field_nightly_rate_amount) as NR 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) INNER JOIN term_node newlist_tn ON node.nid = newlist_tn.nid INNER JOIN term_data newlist_td ON newlist_td.tid = newlist_tn.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 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 = 1) AND ((node.title) LIKE ('%Keyword%E2%88%9Derty_class=2%')) AND (tdt.tid = All%E2%88%8Bghtly%5Bmin%5D=All%E2%88%8Bghtly%5Bmax%5D=All) AND (newlist_td.tid = 495) GROUP BY node.nid ORDER BY NR ASC