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

SQL

use arwiki_p;
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...