Multiple birth year categories (lvwiki)

SQL

use lvwiki_p;
select page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
from categorylinks
join page on cl_from=page_id
where cl_to like "%._gadā_mirušie"
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1;

use lvwiki_p;
select page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
from categorylinks
join page on cl_from=page_id
where cl_to like "%._gadā_dzimušie"
#where cl_to like "%dzimušie" and cl_to not like "%._gadā_dzimušie"
group by cl_from
having count(cl_to)>1;

use lvwiki_p;
select page_title, GROUP_CONCAT(cl_to SEPARATOR ',')
from categorylinks
join page on cl_from=page_id
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...
