SQL
AخA
USE fawiki_p;
SELECT MID(rev_timestamp,1,8),rev_user_text,LCASE(rev_user_text) #, COUNT(MID(rev_timestamp,1,8))
FROM revision
WHERE rev_comment LIKE '%با_استفاده_از_[[Project:AutoWikiBrowser|AWB]]%'
#AND LCASE(rev_user_text) NOT LIKE '%Bot%'
AND MID(rev_timestamp,1,8)='20170205'
#GROUP BY MID(rev_timestamp,1,8)
#ORDER BY COUNT(MID(rev_timestamp,1,8)) DESC;
#ORDER BY rev_timestamp 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.