select magazine_id,companyname,companytitle,a.image,companyid,designation,management_name,management_name2,b.cat_id,companydesc from companies a ,magazine_details b,company_magazine_desc_for_edit c where a.web_id = 6 and b.web_id = 6 and c.web_id = 6 and a.magazine_id=b.sno and a.companyid=c.comp_id and CHAR_LENGTH(companydesc)>408 order by c.box_layout,b.year desc