select IFNULL(i.ismanager, -1),u.myIntoID,u.topRecommend,u.isManages,i.commissionPoints , i.money as imoney, i.id as iid, i.status as istatus, o.payStatus,o.endDate,o.ordernum,o.accountMoney,o.yly,o.investTime,o.investType,o.payTime,ud.position_type,u.realName,u.userName,u.userid,u.jgid,u1.realName as mzfrealName ,u1.userid as u1userid
from order_data.data_orders as o
left join billstable_data.data_inexpenses as i on i.ordernum=o.ordernum
left join members_data.data_users as u on u.userid=o.userid
left join members_data.data_users as u1 on (o.importid=u1.userid or u.topRecommend = u1.userid)
left join members_data.data_user_detail AS ud ON u.userid = ud.userid
where o.payTime >= 849369600 and o.payTime <= 1451577599
and ((u1.isManages = 1 AND o.inDate > u1.becomeManageTime) or (u.isManages = 1 AND o.inDate > u.becomeManageTime))
and o.payStatus=2 and IFNULL(i.ismanager, -1)<>'0'
group by o.ordernum
ORDER by o.id desc limit 90000
from order_data.data_orders as o
left join billstable_data.data_inexpenses as i on i.ordernum=o.ordernum
left join members_data.data_users as u on u.userid=o.userid
left join members_data.data_users as u1 on (o.importid=u1.userid or u.topRecommend = u1.userid)
left join members_data.data_user_detail AS ud ON u.userid = ud.userid
where o.payTime >= 849369600 and o.payTime <= 1451577599
and ((u1.isManages = 1 AND o.inDate > u1.becomeManageTime) or (u.isManages = 1 AND o.inDate > u.becomeManageTime))
and o.payStatus=2 and IFNULL(i.ismanager, -1)<>'0'
group by o.ordernum
ORDER by o.id desc limit 90000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货