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 user_name="Pranayraj1985" and page_title="గేల్_అన్నే_హర్డ్" and 
  WHERE page_namespace=0 and page_is_redirect=0 and rc_deleted=0
  GROUP BY user_name, page_title)
  #ORDER BY rc_this_oldid DESC)

SELECT user_name, COUNT(DISTINCT(page_title)) as article_count, edit_len
FROM criteria_filter
WHERE edit_len>=2048
LIMIT 5

SQL

Checking query status...