SQL
AخA
use arwiki_p;
SET @rank=0;
SELECT CONCAT('{{إحصاءات مساهم في مشروع ويكي الصيانة|',@rank:=@rank+1,'|') AS rank, s.*
FROM (
SELECT
rev_user_text,
CONCAT('|',COUNT(*),'}}')
FROM revision_userindex
WHERE rev_comment like "%وب:م و ص%"
AND rev_timestamp BETWEEN 20170301000000 AND 20170331000000
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC) s;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.