Fork of
My edits by day arwiki
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
AخA
# dalībnieki pēc izveidotajiem rakstiem
use arwiki_p;
SELECT r.rev_user_text, COUNT(*) AS num_articles
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 20010101000000 and 20170501000000
and r.rev_parent_id=0
and ( r.rev_user_text = 'Mr. Ibrahem' or r.rev_user_text = 'Mr.Ibrahembot' )
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 20;
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.