Untitled query #20075

SQL

#SUM(CASE WHEN DATE(rev_timestamp) > (NOW() - INTERVAL 90 MONTH) THEN 1 ELSE 0 END) AS recent_editcount,
  
use wikidatawiki_p;
SELECT
  rev_user_text, rev_comment,
	DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS day
    ,COUNT(*)
FROM revision_userindex
WHERE rev_comment like "%New item from%"
and rev_user_text = 'Mr.Ibrahembot'
#and rev_comment like "%جديد%"
#WHERE rev_user_text  like "%bot"
#GROUP BY rev_comment
#ORDER BY COUNT(*) DESC
GROUP BY day
ORDER BY day DESC;
SQL

Checking query status...
