750000 users only!

SQL

use arwiki_p;
SET @rank=0;
SELECT CONCAT('{{إحصاءات مساهم في مشروع 750 ألف مقالة|',@rank:=@rank+1,'|') AS rank, s.*
FROM (
  SELECT
  rev_user_text,
  CONCAT('|',COUNT(*),'}}')
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and p.page_is_redirect=0 and r.rev_timestamp between 20190306014000 and 20190701000000
	and r.rev_parent_id=0 and r.rev_user != 0 AND r.rev_user_text not like ucase ("%BOT") collate utf8_general_ci
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC) s;
SQL

Checking query status...
