SELECT DISTINCT(rlt.wpr_relation_property_id), MIN(rlt.wpr_weekly_min_rate) AS lowest_price,plt.wpt_property_id as wpt_property_id,plt.wpt_old_prop_id,plt.wpt_tour_operator,plt.wpt_property_name,plt.wpt_state,plt.wpt_country,plt.wpt_desc,plt.wpt_property_type,plt.wpt_bedrooms as wpt_bedrooms,plt.wpt_property_pool,plt.wpt_property_family,plt.wpt_property_couple,plt.wpt_status,plt.wpt_state_id,plt.wpt_site_allowed_prefix,plt.wpt_add_admin,sft.wsfp_featured,sft.wsfp_sub_site_prefix,sft.wsfp_property_id,rlt.wpr_property_id,rlt.wpr_admin_property_id,rlt.wpr_tour_operator,rlt.wpr_start_date,rlt.wpr_end_date,rlt.wpr_weekly_min_rate,rlt.wpr_weekly_max_rate FROM wp_property_table AS plt, wp_subsite_feature_property AS sft, wp_property_rate as rlt WHERE sft.wsfp_sub_site_prefix='154' AND plt.wpt_status='1' AND plt.wpt_property_id=sft.wsfp_property_id and rlt.wpr_relation_property_id = plt.wpt_property_id AND rlt.wpr_tour_operator= plt.wpt_tour_operator and FIND_IN_SET(48, plt.wpt_property_type) GROUP BY plt.wpt_property_id order by wpt_property_id ASC
