SELECT COUNT(customer.cusid) as counter FROM customer WHERE cust_show_web='' and advcls in ('A','B','C','D') and ( ( cuscname like N'%a04336%' or cuscname_noneUTF8 like N'%a04336%' or cuscaddr like N'%a04336%' or cusmpdt like N'%a04336%' or cusintro like N'%a04336%' or cusboard like N'%a04336%' ) ) asdasd