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 c.cat_id != '-1' and a.image2!='' and a.web_id=63 and c.web_id=63 and c.status != 0 and a.vendorview_status!=1 order by CASE WHEN c.cat_id in(19,25,30,66,85,87,128,136,140,141,142,153,158,160,161,176) THEN 0 ELSE 1 END,a.companyid desc limit 10