sddaaa的博客

查询指定账号的下级账号的订单和下下级账号的订单SELECT SUM(oi.recharge_number) as rechareg,SUM(oi.actual_number) as actualFROM order_info oi LEFT JOIN sys_user su ON oi.user_id = su.id left JOIN sys_user ss ON ss.id =

表数据结果SELECT DATE_FORMAT(a.update_time,'%Y-%m-%d %h:%i:%s') daty,a.id,a.game_id,a.platform_id,a.client_id, a.update_time AS startDate ,b.update_time AS endDateFROM apc_upd