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
  CONCAT("[[User:",user_name,"|",user_name,"]]") as Username,
  LEFT(rev_timestamp,8) as DATE,
  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
join categorylinks ON cl_from=user_id AND cl_type="user"
WHERE LEFT(rev_timestamp,8)  >= REPLACE(LEFT (CURDATE() - interval 30 day,30),'/','') 
      AND (page_namespace !=0 || page_namespace !=6)
      AND cl_to ="వికీపీడియా_నిర్వాహకులు"
GROUP BY LEFT(rev_timestamp,8)
ORDER BY Username DESC LIMIT 2000;

SQL

Checking query status...