ESP-geo ceb.wiki articles to connect in WD

SQL

USE cebwiki_p;
SELECT REPLACE(page_title, '_', ' ')#page_title, GROUP_CONCAT(ll_lang)
	FROM page
join categorylinks c1 on cl_from=page_id
join categorylinks c2 on page_id=c2.cl_from
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
	LEFT JOIN langlinks
    	ON ll_from = page_id
WHERE c1.cl_to = "Espanya_paghimo_ni_bot"  and c2.cl_to like "Mga_lungsod_sa%"#"Mga_subdibisyon_sa%" 
and page_namespace=0 and page_is_redirect = 0 
and pp_value is not NULL
and page_title like "%(munisipyo)"
and REPLACE(page_title, '_', ' ') in (SELECT ips_site_page#, ips_item_id#CONCAT('\\ [[Q',ips_item_id,']]')
FROM wikidatawiki_p.wb_items_per_site
JOIN (SELECT * FROM wikidatawiki_p.pagelinks JOIN wb_entity_per_page ON epp_page_id = pl_from
		WHERE pl_namespace = 0 and pl_title = "Q2074737") as pl 
        ON ips_item_id = pl.epp_entity_id
where ips_site_id = "eswiki" )
group by page_title
ORDER BY page_title;
SQL

Checking query status...
