قائمة المستخدمين الأكثر إنشاءً للمقالات في يوم ويكيبيديا العربية العشرين

SQL

SET @rank=0;
SET @start_date = '20221201000000';
SET @end_date = '20230101000000';
SELECT @rank:=@rank+1 AS "المركز", s.*
FROM (
  	SELECT CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS "المستخدم", COUNT(actor_name) AS "عدد المقالات"
	FROM revision
	INNER JOIN page ON rev_page = page_id
	INNER JOIN actor on rev_actor = actor_id
	WHERE page_namespace = 0
	AND rev_parent_id = 0
	AND rev_timestamp between @start_date and @end_date
	AND page.page_is_redirect = 0
	GROUP BY actor_name
	ORDER BY COUNT(actor_name) DESC
	LIMIT 50
) s;

SQL

Checking query status...