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(5,11,23,24,31,36,54,55,74,76,77,78,79,80,89,95,98,115,124,127,130,133,134,137,138,145,149,164,167,175,185,190,192,194,195) THEN 0 ELSE 1 END,a.companyid desc limit 10