Main pl.wiki query 1

SQL

#RESULTSET_13
USE plwiki_p;
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 "Urodzeni_w_1.*"
AND page_title NOT LIKE '%_i_%'
AND page_title NOT LIKE 'Bracia%'
AND page_title NOT LIKE 'Honor_Blackman'
AND page_title NOT LIKE 'Samuel_Shelley'
AND page_title NOT LIKE 'Joyce_Redman'
AND page_title NOT LIKE 'Zhu_Da'
AND page_title NOT LIKE 'Thomas_Morley'
AND page_title NOT LIKE 'Rojda_Felat'
AND page_title NOT LIKE 'Jan_Horodeński'
AND page_title NOT LIKE 'Jason_Derek_Brown'
GROUP BY cl_from
HAVING COUNT(cl_to)>1;
SQL

Checking query status...
