Untitled query #57776

SQL

use arwiki_p;
    select substring(rev_timestamp,1,8) as the_date, count(*) from (
    SELECT page_id, rev_id, comment_text, page_title, rev_timestamp
    FROM revision_userindex
    INNER JOIN page ON rev_page = page_id
    INNER JOIN actor ON rev_actor = actor.actor_id
    INNER JOIN comment ON comment_id = rev_comment_id
    WHERE rev_timestamp between 20210101000000 and 20211231000000
	AND page_namespace = 0
    AND page.page_is_redirect = 0
    AND actor_name = 'JarBot'
      AND comment_text like _utf8"%إضافة_صورة_مقترحة%" collate utf8_general_ci) a
      group by substring(rev_timestamp,1,8) order by substring(rev_timestamp,1,8);
SQL

Checking query status...
