管理业务数据

select * from wangxuninfo where logname='8' or parentlogname='8' or parentlogname='6' or logname='6'

create table goosw (select u.id,w.logname,w.nick,w.parentlogname,w.parentnick,w.parentteam,w.allpoint,w.createtime,u.created

 from wangxuninfo as w,user as u where w.logname=u.logname)

create table goose (select w.id as userid,w.logname,w.nick,u.id as parentid,w.parentlogname,w.parentnick,w.parentteam,w.allpoint,w.createtime,u.created

 from goosw as w,user as u where w.parentlogname=u.logname)

create table soose (select w.userid,w.logname,w.nick,w.parentid,w.parentlogname,w.parentnick,w.parentteam,w.allpoint,w.createtime,w.created,

a.money,a.rpmoney

 from  goose as w,accounts as a where w.userid=a.userid)

create table sooeq (select w.userid,w.logname,w.nick,longs.passwd,w.parentid,w.parentlogname,w.parentnick,w.parentteam,w.allpoint,w.createtime,w.created,

w.money,w.rpmoney

 from  soose as w,longze_expand as longs where w.userid=longs.userid)

create table oos (select w.userid,w.logname,w.nick,w.passwd,w.parentid,w.parentlogname,w.parentnick,w.parentteam,w.allpoint,w.createtime,w.created,

w.money,w.rpmoney,cal.apoint,cal.bpoint,cal.cpoint,cal.dpoint,cal.epoint

from sooeq as w left join calpoint as cal on w.userid=cal.userid)

select count(*) from oos where logname='daben'

or logname='wjzhou7803'

or logname='0006'

or logname='2018'

or logname='lilixiang'

or logname='longfei998'

or logname='253089990'

or logname='253089999'

or logname='kaikai_2009'

or logname='66666666'

or logname='qinzuokai'

or logname='wulongshiye'