Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- users.*,
- sum(payments.amount) as `summ`
- FROM `users`
- LEFT OUTER JOIN `payments` ON `users`.`id` = `payments`.`user_id`
- WHERE payments.created_at BETWEEN '$yesterday' and '$today' AND `status` = '2'
- GROUP BY user_id
Add Comment
Please, Sign In to add comment