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