Authors of articles by category [CEE Spring 2021]

Fork of Authors of articles by category [CEE Spring 2021] by AntonProtsiuk (WMUA)

This query is marked as a draft This query has been published by Jeeputer.

SQL

SELECT DISTINCT A.actor_name, CONCAT('{{subst:formatnum:',COUNT(1),'}}') as articles
FROM fawiki_p.revision R
 JOIN fawiki_p.page P1 ON R.rev_page = P1.page_id
 JOIN fawiki_p.page P2 ON P1.page_title = P2.page_title
 JOIN fawiki_p.categorylinks CL ON P2.page_id = CL.cl_from
 JOIN fawiki_p.actor A ON R.rev_actor = A.actor_id
WHERE R.rev_parent_id = 0
 AND P1.page_namespace = 0
 AND P2.page_namespace = 1
 AND P1.page_is_redirect = 0
 AND CL.cl_to LIKE "افراد_زنده"
 AND R.rev_timestamp >= 20210101000000
 AND R.rev_timestamp < 20211001000000
GROUP BY A.actor_name
ORDER BY articles DESC

SQL

Checking query status...