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

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_registration >= '2024-11-01'  -- Added condition for user registration date
AND EXISTS (  -- Filter revisions made between 1st Nov 2024 and 30th Nov 2030
    SELECT 1
    FROM revision
    WHERE revision.rev_user = user.user_id
    AND revision.rev_timestamp BETWEEN '2024-11-01' AND '2030-11-30'
)
ORDER BY user_editcount DESC 
LIMIT 1000;

SQL

Checking query status...