উইকিপিডিয়ার সর্বশেষ মাসে সর্বাধিক নতুন অবদানকারী

SQL

SET @counter:=0; 
SELECT 
    CONCAT("{{subst:formatnum:",@counter:=@counter+1,"}}") AS নং,
    CONCAT("{{u|",user_name,"}}") AS ব্যবহারকারী_নাম,
    CONCAT("{{subst:formatnum:", COUNT(*) FROM recentchanges,"}}") 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_registration >= '20240801'  -- Added condition for user registration date

ORDER BY COUNT(*) DESC 
LIMIT 10;

SQL

Checking query status...