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 '%Bengaluru%' AND a.club_id IN (SELECT club_id FROM hc_club_tbl WHERE (club_name LIKE '%Electronic%' OR club_display_address LIKE '%Electronic%' OR club_city LIKE '%Electronic%') AND(club_name LIKE '%City%' OR club_display_address LIKE '%City%' OR club_city LIKE '%City%') UNION SELECT club_id FROM hc_feature_tbl WHERE (feature_value LIKE '%Electronic%') AND(feature_value LIKE '%City%') ) LIMIT 0, 50