Articles with double birth/death category on plwiki

SQL

use plwiki_p;
select CONCAT("# [[",page_title,"]]") AS page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
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%'
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1;

use plwiki_p;
select CONCAT("# [[",page_title,"]]") AS page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
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%'
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1;

SQL

Checking query status...