Latvijas ciemi vairāku pagastu kategorijās

SQL

USE lvwiki_p;
select p.page_title, GROUP_CONCAT(cl.cl_to SEPARATOR ', ')
from categorylinks cl
join page p on p.page_id=cl.cl_from
join page p3 on cl.cl_to=p3.page_title and p3.page_namespace=0
where cl.cl_from in (select cl2.cl_from
						from categorylinks cl2
						join page p2 on p2.page_id=cl2.cl_from
						where cl2.cl_to="Latvijas_ciemi" and cl2.cl_type='page'
						and p2.page_is_redirect=0 and p2.page_namespace=0)
    and cl.cl_type='page' and cl.cl_to like "%pagasts"
    group by p.page_title
    having count(cl.cl_to)>1
      #  limit 200;

SQL

Checking query status...