Untitled query #78622

SQL

SELECT YEAR(creation_date) AS creation_year, COUNT(*) AS category_count
FROM (
    SELECT page_id, MIN(rev_timestamp) AS creation_date
    FROM page
    JOIN revision ON page_id = rev_page
  	INNER JOIN actor on rev_actor = actor_id
    WHERE page_namespace = 14 -- Category namespace
  	and (
     ucase(actor_name) like ucase("%BOT") COLLATE utf8_general_ci
      or actor_name like "%بوت%" collate utf8_general_ci
      or actor_name  IN (SELECT user_name
                             FROM user_groups
                                      INNER JOIN user ON user_id = ug_user
                             WHERE ug_group = "bot")

	)
    GROUP BY page_id
) AS first_revisions
GROUP BY creation_year
ORDER BY creation_year;
SQL

Checking query status...
