articole IT-geo in ceb de conectat 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 = "Italya_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 NULL
and page_title like "%(kapital_sa_munisipyo)"
/*and REPLACE(page_title, '_(munisipyo)', '') in (select page_title
from rowiki_p.page p
join rowiki_p.categorylinks c3 on p.page_id=c3.cl_from
where c3.cl_to like "Comune_din_provincia%"
                   AND p.page_namespace = 0 AND p.page_is_redirect = 0
and p.page_id not in (select m.ll_from from langlinks m where m.ll_lang="ceb"))*/

/*and page_id not in (select l.ll_from from langlinks l where l.ll_lang="sv")*//*
and page_title in (select page_title
from enwiki_p.page p3
join enwiki_p.categorylinks c3 on p3.page_id=c3.cl_from
where c3.cl_to ...
                   AND p3.page_namespace = 0 AND p3.page_is_redirect = 0)*/
                   
#and page_id not in (select m.ll_from from langlinks m where m.ll_lang="en")
group by page_title
ORDER BY page_title;
SQL

Checking query status...
