SELECT prud.* FROM prud WHERE prud.cmid Like '%,31,%' and ( prud.pruname LIKE '%%' or prud.barcode LIKE '%%' ) and prud.okw='1' and prud.status='1' and pin!=1 ORDER BY `prud`.`this_total` DESC Limit 0, 36