select magazine_id,companyname,companytitle,c.image,companyid,designation,management_name,management_name2,m.cat_id,column1 from companies c,magazine_details m where c.magazine_id=m.sno and m.cat_id=9 and c.rank_id in(select distinct rnkid from ranking a,magazine_details b where app_status=0 and a.mag_id=b.sno and b.cat_id=9 and a.web_id = 27 and b.web_id = 27) and c.web_id = 27 and m.web_id = 27

Top