My edits by day arwiki

SQL

USE arwiki_p;
SELECT /*SLOW OK */
  #DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS DAY,
  DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-","01")) AS M,
  COUNT(rev_timestamp) AS edits
FROM revision
WHERE rev_user_text = 'Mr. Ibrahem'
GROUP BY M;

USE arwiki_p;
SELECT /*SLOW OK */
  DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-","01")) AS M,
  COUNT(rev_timestamp) AS bot_edits
FROM revision
WHERE rev_user_text = 'Mr.Ibrahembot'
GROUP BY M;
SQL

Checking query status...
