Advertisement
festinko

Untitled

Oct 20th, 2022
839
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.36 KB | None | 0 0
  1. SELECT
  2.   count(DISTINCT u.userID)
  3.  
  4. FROM
  5.   `uptimerobot-001.ur.users` u
  6.   LEFT JOIN
  7.     `uptimerobot-001.ur.monitors` m
  8.  
  9.   ON
  10.    u.userID = m.userID
  11.  
  12. WHERE
  13.   userRegisterDateTime BETWEEN '2022-09-01 00:00:01' AND '2022-09-31 23:59:59'
  14.   AND monitorCreateDateTime BETWEEN '2022-09-01 00:00:01' AND '2022-09-31 23:59:59'
  15.   AND monitorID IS NOT NULL
  16.  
  17.  
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement