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