SQL
AخA
USE fawiki_p;
SELECT concat('[[user:',rev_user_text,']]') as user_name, COUNT(rev_timestamp) AS revisions
FROM revision join page on
page_id=rev_page and page_namespace=0 where
rev_comment LIKE '%[[وپ:اشتباه|اشتباه•یاب]]%' and rev_timestamp > 20160731000000 GROUP BY rev_user_text order by 2 DESC;
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.