SELECT a.*, (SELECT GROUP_CONCAT(CONCAT_WS(':',membership_admin,membership_fees,currency_code,membership_days,membership_type)) FROM hc_membership_tbl WHERE club_id = a.club_id AND membership_admin <> '999' GROUP BY club_id) AS membership_list, (SELECT MAX(membership_fees) FROM hc_membership_tbl WHERE membership_type = '30' AND membership_admin <> '999' AND club_id = a.club_id AND membership_fees > 0) AS max_cost, (SELECT MIN(membership_fees) FROM hc_membership_tbl WHERE membership_type = '30' AND membership_admin <> '999' AND club_id = a.club_id AND membership_fees > 0) AS min_cost, (SELECT feature_value FROM hc_feature_tbl WHERE feature_id = 'wtype' AND club_id = a.club_id) AS workout, (SELECT AVG(rate_overall) FROM hc_review_tbl WHERE club_id = a.club_id) AS rate, (SELECT COUNT(*) FROM hc_club_like_tbl WHERE club_id = a.club_id) AS ctlike, z.type_name FROM hc_club_tbl a, hc_types_master_tbl z WHERE a.type_id = z.type_id AND a.club_status = '10' AND club_city LIKE '%Pune%' AND a.club_id IN (SELECT club_id FROM hc_club_tbl WHERE (club_name LIKE '%Hadapsar%' OR club_display_address LIKE '%Hadapsar%' OR club_city LIKE '%Hadapsar%') UNION SELECT club_id FROM hc_feature_tbl WHERE (feature_value LIKE '%Hadapsar%') ) LIMIT 0, 50