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,46,53,65,66,85,87,90,126,128,129,136,140,141,142,147,153,156,158,160,161,171,172,173,176,184,198) THEN 0 ELSE 1 END,a.companyid desc limit 10