select IC.inst_id, IC.inst_cid, IC.cid, IP.name, IP.inst_slug, IP.address, IP.address2, IP.city, IP.location,IP.about, IP.amenities from institute_courses As IC, institute_profile AS IP where IC.status = 'Y' AND IC.admin_status = 'A' AND IC.inst_id = IP.inst_id And IC.del ='N'    AND IC.cid IN ('52,')     And IP.city ='41'    And IP.location ='549'    AND IP.featured= '0' GROUP BY IC.inst_id ORDER BY IC.inst_id