My edits by day wikidatawiki_p

SQL

Use wikidatawiki_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.Ibrahembot'
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 20;

#use arwiki_p;
Use wikidatawiki_p;  
SELECT /*SLOW OK */
  DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS DAY,
  COUNT(rev_timestamp) AS revisions
FROM revision
WHERE rev_user_text = 'Mr.Ibrahembot'
GROUP BY DAY;
SQL

Checking query status...
