Guest User

Untitled

a guest
Oct 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. SELECT `users`.`id` AS `user_id`,
  2. `users`.`name` AS `user_name`,
  3. `users`.`email` AS `email`,
  4. `users`.`point` AS `user_point`,
  5. FROM_UNIXTIME(SUBSTRING_INDEX(
  6. GROUP_CONCAT(
  7. DISTINCT user_point_logs.expire_date
  8. ORDER BY user_point_logs.expire_date
  9. ASC SEPARATOR ','),',',1), '%Y-%m-%d'
  10. )
  11. AS user_expire_date,
  12. SUBSTRING_INDEX(
  13. GROUP_CONCAT(
  14. DISTINCT user_point_logs.point
  15. ORDER BY user_point_logs.expire_date
  16. ASC SEPARATOR ','),',',1
  17. )
  18. AS user_point_next_expire
  19.  
  20. FROM `user_point_logs`
  21.  
  22. LEFT JOIN `users` ON
  23. (`users`.`id` = `user_point_logs`.`user_id`)
  24.  
  25. WHERE `user_point_logs`.`point` > 0
  26. AND `user_point_logs`.`expire_date` > 1539770111
  27. AND `users`.`disable` = 0 AND `users`.`point` > 0
  28. AND `users`.`point` IS NOT null
  29. AND `users`.`is_ml_bounced` = 0
  30. AND (`user_point_logs`.`return_id` = 0
  31. OR `user_point_logs`.`return_id` IS null)
  32. AND `user_point_logs`.`user_id`
  33. BETWEEN 16077 AND 16083
  34. GROUP BY `user_point_logs`.`user_id`
Add Comment
Please, Sign In to add comment