অভিধানে ভুক্তি তৈরির সংখ্যা অনুযায়ী ব্যবহারকারীর তালিকা

SQL

SET @ct:=0;
SELECT
CONCAT("{{subst:formatnum:",@ct:=@ct+1,"}}") AS নং,
CONCAT("{{u|",user,"}}") AS ব্যবহারকারী_নাম,
CONCAT("{{subst:formatnum:",cnt,"}}") AS মোট_নিবন্ধ
FROM (
	SELECT
		actor_name AS user,
		COUNT(rev_id) AS cnt
	FROM actor
    JOIN revision
	ON rev_actor = actor_id
	JOIN page
	ON page_id = rev_page
	WHERE rev_parent_id = 0
	AND page_namespace = 0
	AND page_is_redirect = 0
	AND actor_user IS NOT NULL
	AND actor_name NOT RLIKE "(.*)([Bb][Oo][Tt]|বট)"
	GROUP BY actor_name
	ORDER BY cnt DESC
	LIMIT 1000
) d;

SQL

Checking query status...