Untitled query #63243

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
WHERE user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
AND user_name NOT RLIKE "(.*)([Bb][Oo][Tt])(.*)"
JOIN page ON page_id = rev_page
Where page_namespace = 4
ORDER BY user_editcount DESC LIMIT 1000;
SQL

Checking query status...
