select magazine_id,companyname,companytitle,c.image,companyid,designation,management_name,management_name2,m.cat_id,companydesc from companies c,magazine_details m where c.magazine_id=m.sno and m.cat_id=27 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=27 and a.web_id = 20 and b.web_id = 20) and c.vendorview_status=0 and char_length(companydesc)>408 and c.web_id = 20 and m.web_id = 20 order by dateadded