where b.regtype in ('新注冊','已續期','試用') and a.end_date>=getdate() and (a.pub_pugong_ol is null or a.pub_pugong_ol=0) and a.pub_tag=1 and a.del_tag=0 and isnull(a.adusername,a.username)=b.username and b.username=c.username and ( 1=0 or a._PositionClass_no = '13011' )