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 revision

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 'rev_timestamp' BETWEEN @start_date AND @end_date;*/

WHERE 'rev_timestamp' BETWEEN @start_date AND @end_date;

WHERE 'rev_user_text' < 20140631000000;

ORDER BY user_editcount DESC LIMIT 500;
SQL

Checking query status...
