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
解决方案 »
- 一个SQL语句
- 存储过程,急
- mysql不能正常显示中文 已设置为utf8
- MySQL Replication 同步的疑惑~!
- 我的表名叫a-b,在linux的shell下用(drop table a-b)删除时,报错,请问怎么办
- 请问:shuixin13(犬犬(心帆)) 我要访问局域网内另一台机器的Mysql怎么配置呢。
- 关于mysql的登陆问题?急...小弟先谢了。。。
- 如何建立一个连接MYSQL的用户?
- 请问如何导出mysql中一个表内的几个指定字段的内容(急用!!)
- 新人求助!mysql条件查找某一字段后如何在MFC输出字段值。。。在线等
- 关于Sql update 的问题,请教大神!!!!
- 为什么这条SQL在服务器上能执行,在我本机却失败了呢?
explain select ...
show index from ..
以供分析。
explain
show index