Categories with intitle a given word on plwiki

SQL

USE plwiki_p;

SET @start_date = '20140101000000';
SET @end_date = '20140631000000';

SELECT user_name, user_editcount

FROM user INNER JOIN logging

WHERE user_id NOT IN
      (SELECT ug_user
       FROM user_groups
       WHERE ug_group="bot")
    AND user_name NOT IN
      (SELECT gu_name
       FROM centralauth_p.globaluser JOIN centralauth_p.localuser ON lu_name=gu_name AND lu_wiki="plwiki"
       JOIN centralauth_p.global_user_groups ON gug_user=gu_id
       WHERE gug_group="global-bot")

WHERE 'log_timestamp' BETWEEN @start_date AND @end_date;

ORDER BY user_editcount DESC LIMIT 500;

SQL

Checking query status...