Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- userSMSRefill,
- ROUND(SUM(paymentAmount)) revenue
- FROM
- payments p
- LEFT JOIN users u
- on p.userID = u.userID
- WHERE
- paymentDateTime > '2022-07-13 00:00:01'
- AND p.userID IN (
- SELECT
- userID
- FROM
- alertcontacts
- WHERE
- alertContactType IN (8,14)
- AND alertContactStatus = 2
- GROUP BY
- userID
- ORDER BY
- userID)
- AND paymentType = 1
- GROUP BY
- userSMSRefill
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement