Untitled query #19175

SQL

USE itwiki_p;

SELECT distinct(user_name)
FROM user u
WHERE u.user_editcount > 300
AND (SELECT SUM(contribs)
     FROM user_daily_contribs udc
     WHERE udc.user_id = u.user_id
     AND udc.day < '20150415' ) > 300
AND (SELECT SUM(contribs)
     FROM user_daily_contribs udc2
     WHERE udc2.user_id = u.user_id
     AND udc2.day BETWEEN '20141015' AND '20150415' ) > 20
AND user_id NOT IN (SELECT ug_user
    FROM user_groups
    WHERE ug_group = 'bot' )
AND user_name NOT LIKE '%Bot%'
AND user_name NOT LIKE '%bot%'
ORDER BY user_editcount DESC;
SQL

Checking query status...
