Untitled query #7961

SQL

USE arwiki_p;
select p.page_title, 'P131', (SELECT  wb.eu_entity_id
					from wbc_entity_usage wb
                    where p3.page_id=wb.eu_page_id
					GROUP BY wb.eu_page_id)
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'
                     cl2.cl_to="قرى_مديرية_يريم" and cl2.cl_type='page'
						and p2.page_is_redirect=0 and p2.page_namespace=0)
and p.page_title in (SELECT enp.page_title
					FROM page enp, page_props, wikidatawiki_p.page wdp
					LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P131'
                     	AND wdpl.pl_namespace = 120
					WHERE enp.page_namespace = 0
						AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
						AND wdp.page_title = pp_value AND wdp.page_namespace = 0
						AND wdpl.pl_from IS NULL)
    and cl.cl_type='page' and cl.cl_to like "قرى%"#"%pagasts_(%novads)"
      #  limit 200;
      /*
      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
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'
                     cl2.cl_to like "%ciemi" and cl2.cl_type='page'
						and p2.page_is_redirect=0 and p2.page_namespace=0)
and 
p.page_title in (SELECT enp.page_title
					FROM page enp, page_props, wikidatawiki_p.page wdp
					LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P131'
                     	AND wdpl.pl_namespace = 120
					WHERE enp.page_namespace = 0
						AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
						AND wdp.page_title = pp_value AND wdp.page_namespace = 0
						AND wdpl.pl_from IS NULL)
                        and p.page_title not like "%uzskaitījums"
group by cl.cl_from*/
SQL

Checking query status...
