Untitled query #84361

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])(.*)"
    AND user_name IN ('MdsShakil', 'Mizan Ahmed')
ORDER BY 
    user_editcount DESC 
LIMIT 1000;
SQL

Checking query status...
