Most active users by edits on plwiki in last 6 months

SQL

USE plwiki_p;
SELECT DISTINCT CONCAT('# [[Dyskusja:',page_title,']]') AS page_title
FROM page, templatelinks
WHERE tl_from_namespace = 0
AND tl_namespace = 10
AND page_id = tl_from
AND tl_title LIKE '%infobox%'
AND page_title NOT IN (
'Chleba_naszego_powszedniego', 'Letnie_wakacje', 'Miejsce_urodzenia_(film)', 'Milionowy_spadkobierca', 'Nasza_klątwa'
)
AND page_title IN (
	SELECT page_title
	FROM page, templatelinks
	WHERE tl_from_namespace = 1
	AND tl_namespace = 10
	AND page_id = tl_from
	AND tl_title LIKE 'Bez_infoboksu'
)
LIMIT 10

SQL

Checking query status...