WP Croatia BLP + citation needed by year

SQL

use enwiki_p;

select pa.page_title, min(cl.cl_to) 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"
) 
#and pa.page_id in (select cl_from from categorylinks where cl_to = "Living_people")
group by pa.page_title
order by cat
SQL

Checking query status...
