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