WP Croatia BLP + citation needed by year

SQL

use enwiki_p;

select pa.page_title, min(substr(cl_cn.cl_to, -4, 4)) as cat
from page pa 
inner join categorylinks cl_cn on cl_cn.cl_from = pa.page_id and cl_cn.cl_to like "Articles_with_unsourced_statements_from_%"
inner join categorylinks cl_blp on cl_blp.cl_from = pa.page_id and cl_blp.cl_to = "Living_people"
where pa.page_namespace = 0 and pa.page_is_redirect = 0 and
pa.page_title in 
(
select pt.page_title
from page pt
inner join categorylinks cl on cl.cl_from = pt.page_id
where pt.page_namespace = 1 and cl.cl_to = "WikiProject_Croatia_articles"
) 
group by pa.page_title
order by cat

SQL

Checking query status...