editors & articles_count with contributions >= 2048 bytes

SQL

WITH
criteria_filter AS (
  SELECT user_name, page_title, rc_this_oldid, SUM(rc_new_len)-SUM(rc_old_len) AS edit_len, rc_deleted
  FROM page
  INNER JOIN revision on rev_id=page_latest
  INNER JOIN actor on rev_actor=actor_id
  INNER JOIN user on user_id=actor_user
  INNER JOIN recentchanges on rc_cur_id=page_id
  WHERE page_namespace=0 and page_is_redirect=0 and rc_deleted=0
  GROUP BY user_name, page_title),
article_filter AS (
  SELECT user_name, COUNT(DISTINCT(page_title)) as article_count, edit_len
  FROM criteria_filter
  WHERE edit_len>=2048
  GROUP BY user_name)
  
SELECT user_name, article_count
FROM article_filter
WHERE article_count>1 AND user_name NOT LIKE '%Bot%' AND user_name NOT LIKE '%bot%'  
ORDER BY article_count DESC

SQL

Checking query status...