






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