أكثر المستخدمين إنشاء للمقالات ضمن مشروع الجزائر

SQL

SELECT CONCAT('#[[مستخدم:', actor_name, ']]') AS formatted_actor_name, COUNT(actor_name)
FROM revision
INNER JOIN page ON rev_page = page_id
LEFT JOIN actor ON rev_actor = actor_id
WHERE page_namespace = 0
AND rev_parent_id = 0
AND rev_timestamp BETWEEN 20190101000000 AND 20240203595959
AND page.page_is_redirect = 0
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_from = page.page_id AND cl_to = "بوابة_الجزائر/مقالات_متعلقة")
GROUP BY actor_name
ORDER BY COUNT(actor_name) DESC;-

SQL

Checking query status...