Untitled query #84787

SQL

SET @counter := 0;

SELECT 
  CONCAT("{{subst:formatnum:", @counter := @counter + 1, "}}") AS নং,
  CONCAT("{{u|", user_name, "}}") AS ব্যবহারকারী_নাম,
  CONCAT("{{subst:formatnum:", user_editcount, "}}") AS সম্পাদনার_সংখ্যা
FROM user
LEFT JOIN (
  SELECT rc_user, COUNT(*) AS recent_edits
  FROM recentchanges
  WHERE rc_timestamp >= DATE_SUB(CURDATE(), INTERVAL 3 YEAR)
  GROUP BY rc_user
) AS recent_edits ON user.user_id = recent_edits.rc_user
LEFT JOIN (
  SELECT ipb_user
  FROM ipblocks
  WHERE ipb_user IS NOT NULL
) AS blocked_users ON user.user_id = blocked_users.ipb_user
WHERE user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
  AND user_name NOT RLIKE "(.*)([Bb][Oo][Tt])(.*)"
  AND user_registration <= '20231231'
  AND recent_edits.recent_edits >= 100
  AND blocked_users.ipb_user IS NULL
ORDER BY user_editcount DESC
LIMIT 1000;
SQL

Checking query status...
