select a.companyid,a.companytitle,a.management_name,a.image,a.management_name2,a.magazine_id,a.image2,b.cat_id,a.visited_company,a.company_name_url,companyname from companies a, magazine_details b where a.magazine_id=b.sno and b.cat_id =47 and a.image2!='' and a.web_id=63 and b.web_id=63 and a.vendorview_status!=1 order by a.companyid desc limit 10