SELECT
count(DISTINCT u.userID)

FROM
  `uptimerobot-001.ur.users` u
  LEFT JOIN
    `uptimerobot-001.ur.payments` p

  ON
   u.userID = p.userID

WHERE
  userRegisterDateTime BETWEEN '2022-04-01 00:00:01' AND '2022-09-30 23:59:59'
  AND paymentDateTime BETWEEN '2022-04-01 00:00:01' AND '2022-09-30 23:59:59'
  AND paymentDateTime IS NOT NULL
  AND paymentStatus = 1
  AND paymentNewUpgradeRenewal = 1
  AND paymentPeriod IN (1,12)