Active admin count in recent 28 days

Fork of User edits for users in a registration period by Arjunaraoc

This query is marked as a draft This query has been published by Arjunaraoc.

SQL

SELECT DISTINCT
  LEFT(rev_timestamp,8) as date,
  COUNT(DISTINCT user_name) as active_admin_count
FROM revision
JOIN page ON revision.rev_page = page.page_id 
JOIN actor
     ON rev_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 28 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
      AND page_namespace  NOT IN (0,6)
      AND REPLACE(user_name," ","_") in (
			Select page_title
			FROM page
			join categorylinks ON cl_from=page_id AND cl_type="page"
        	WHERE   cl_to ="వికీపీడియా_నిర్వాహకులు")
GROUP BY LEFT(rev_timestamp,8)
ORDER BY date DESC
LIMIT 2000;

SQL

Checking query status...