All editors on Telugu Wikipedia with 200+ edits, 50+ edits in last 12 months

SQL

USE tewiki_p;
SELECT
  user_name,
  user_editcount,
  edits_after
FROM user
INNER JOIN (SELECT
             rev_user_text AS edit_username,
             COUNT(rev_id) AS edits_after
            FROM revision_compat
            WHERE rev_timestamp > "20000707000000"
            GROUP BY edit_username
           ) AS last_edits
           ON user_name = edit_username
WHERE user_editcount >= 200
AND edits_after >= "50"
ORDER BY edits_after DESC

AخA
 
USE tewiki_p;SELECT  user_name,  user_editcount,  edits_afterFROM userINNER JOIN (SELECT             rev_user_text AS edit_username,             COUNT(rev_id) AS edits_after            FROM revision_compat            WHERE rev_timestamp > "20000707000000"            GROUP BY edit_username           ) AS last_edits           ON user_name = edit_usernameWHERE user_editcount >= 200AND edits_after >= "50"ORDER BY edits_after DESC

SQL

Checking query status...