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
  LEFT(rev_timestamp,8) as date,
  user_name,
  COUNT(*) as edits
FROM revision
JOIN page ON revision.rev_page = page.page_id 
JOIN revision_actor_temp
     ON  revactor_rev=rev_id
JOIN actor
     ON revactor_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 30 day,'-','') 
      AND page_namespace  NOT IN (0,6)
#      AND user_name in (
#			Select REPLACE(page_title,"_","") as pagetitle
#			FROM page
#			join categorylinks ON cl_from=page_id AND cl_type="page"
#        	WHERE   cl_to ="వికీపీడియా_నిర్వాహకులు")
GROUP BY LEFT(rev_timestamp,8)
ORDER BY LEFT(rev_timestamp,8) ,user_name DESC LIMIT 2000;

SQL

Checking query status...