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(11,23,31,36,54,55,78,79,89,98,124,127,130,133,134,138,145,149,164,167,175,185) THEN 0 ELSE 1 END,a.companyid desc limit 10