Untitled query #25826

SQL

USE cswiki_p;
SELECT COUNT(*), COUNT(DISTINCT log_user)
/*FROM page
JOIN revision ON rev_page = page_id
JOIN logging ON log_user = rev_user
WHERE page_namespace % 2 = 1
AND log_type = "newusers"
AND log_action = "create"
AND log_timestamp >= 20170000000000;
*/
FROM (
  SELECT DISTINCT log_user FROM logging WHERE log_type = "newusers" AND log_action = "create" AND log_timestamp >= 20170000000000
) AS users
JOIN revision ON rev_user = log_user
JOIN page ON page_id = rev_page
WHERE page_namespace % 2 = 1 # AND rev_timestamp >= 20170000000000
;
SQL

Checking query status...
