Untitled query #37342

SQL

USE skwiki_p;

SELECT 
    user_name, user_registration, user_editcount 
  FROM 
    user u 
  WHERE 
    user_registration < DATE_FORMAT(DATE_SUB("2019-07-01 00:00:00", INTERVAL 2 MONTH), '%Y%m%d%H%i%s') AND
    user_editcount >= 200 AND  -- rough filter to reduce number of rows to be filtered by correlated subqueries
    (select count(*) from revision r, page p where p.page_id = r.rev_page AND r.rev_actor = u.user_id AND p.page_namespace = 0 AND r.rev_timestamp < DATE_FORMAT("2019-07-01 00:00:00", '%Y%m%d%H%i%s')) >= 200 AND
    (select count(*) from revision r where r.rev_actor = u.user_id AND r.rev_timestamp >= DATE_FORMAT(DATE_SUB("2019-07-01 00:00:00", INTERVAL 2 MONTH), '%Y%m%d%H%i%s')) >= 50
  ORDER BY
    u.user_name
  ;
SQL

Checking query status...
