Most active users by edits on commonswiki

SQL

#RESULTSET_8
SELECT CONCAT("# [[",page_title,"]]") AS page_title, GROUP_CONCAT(cl_to SEPARATOR ',') AS cl_to
FROM categorylinks
JOIN page ON cl_from=page_id
WHERE cl_to rlike "Zmarli_w_1.*"
AND page_title NOT LIKE '%_i_%'
AND page_title NOT LIKE 'Bracia%'
AND page_title NOT LIKE 'Spytko_IV_z_Melsztyna'
AND page_title NOT LIKE 'Damy_z_Llangollen'
AND page_title NOT LIKE 'Jorge_de_Meneses'
AND page_title NOT LIKE 'Józef_Dworzaczek'
GROUP BY cl_from
HAVING COUNT(cl_to)>1;
#RESULTSET_9
SELECT CONCAT('# [[:Kategoria:',cat_title,']]') AS cat_title, cat_pages
FROM page, category
WHERE page_title = cat_title
AND page_namespace = 14
AND page_is_redirect = 1;
SQL

Checking query status...
