Advertisement
festinko

Untitled

Nov 25th, 2022
493
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. SELECT
  2. userID,
  3. MIN(paymentDateTime) firstPaymentDateTime
  4.  
  5. FROM
  6.   `uptimerobot-001.ur.payments`
  7.  
  8. WHERE
  9. paymentType = 2
  10. AND paymentStatus = 1
  11.  
  12. GROUP BY
  13.   userID
  14.  
  15. ORDER BY
  16.   firstPaymentDateTime DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement