cewiki [items to be merged]

SQL

use cewiki_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
where /*page_is_redirect = 0 AND page_namespace = 0 and*/ 
cl_to = "Порхован_областан_Калининскан_кӀоштан_нах_беха_меттигаш"
/*and page_title in (select p1.page_title
from ruwiki_p.page p1
join ruwiki_p.categorylinks c1 on p1.page_id=c1.cl_from
and c1.cl_to = "Населённые_пункты_Порховского_района"#"Страницы_разрешения%"
#and page_is_redirect = 0 AND page_namespace = 0
  )/**/
and pp_value is not NULL
AND ll_title IS NULL
#and ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ru") #group BY page_title
SQL

Checking query status...
