select magazine_id,companyname,companytitle,c.image,companyid,designation,management_name,management_name2,m.cat_id,companydesc,logo from companies c,magazine_details m where c.magazine_id=m.sno and m.cat_id=8 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=8 and a.web_id = 38 and b.web_id = 38) and char_length(companydesc)>408 and c.web_id = 38 and m.web_id = 38