ceb to merge - Quarry

SQL

use cebwiki_p;
select page_title#, pp_value
from page
#LEFT JOIN langlinks ON ll_from = page_id
#JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id
join categorylinks on page_id=cl_from
#JOIN templatelinks ON tl_from = page_id and tl_namespace = 10
where cl_to = "Mga_lungsod_sa_Rheinland-Pfalz"#like "Civil_parishes_in%"#cl_to = "Lakes_of_Finland"#in ("Lakes_of_Saskatchewan")#"Naseljena_mjesta_u_Federaciji_Bosne_i_Hercegovine"
#AND tl_title = "Lang-bg"
#and REPLACE(page_title, ',_Chile', '') in (select REPLACE(page_title, '_(kommun_i_Chile)', '')
and REPLACE(page_title, "_(munisipyo)", "") in (select p.page_title
from enwiki_p.page p
#join svwiki_p.categorylinks c1 on page_id=c1.cl_from
join enwiki_p.categorylinks c2 on p.page_id=c2.cl_from
#where c1.cl_to like "Orter_i%"
where /**/c2.cl_to = "Municipalities_in_Rhineland-Palatinate")
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="en")
SQL

Checking query status...
