Articles with double birth/death category on plwiki

SQL

use etwiki_p;
select page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
from categorylinks
join page on cl_from=page_id
where cl_to rlike "Sündinud_1.*"
AND page_title NOT LIKE "Bonnie_ja_Clyde" 
AND page_title NOT LIKE "Auguste_ja_Louis_Lumière"
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1
LIMIT 10;

use etwiki_p;
select page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
from categorylinks
join page on cl_from=page_id
where cl_to rlike "Surnud_1.*"
AND page_title NOT LIKE "Auguste_ja_Louis_Lumière" 
AND page_title NOT LIKE "Friedrich_von_Haseldorf"
AND page_title NOT LIKE "Dilruba_Sultana"
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1
LIMIT 10;
SQL

Checking query status...
