cewiki [items to be merged]

SQL

use cewiki_p;
select page_title, pp_value#concat("https://www.wikidata.org/w/index.php?title=",pp_value,"&action=history")
#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 page_title
from ruwiki_p.page
join ruwiki_p.categorylinks c1 on page_id=c1.cl_from
and c1.cl_to like "Страницы_разрешения%"
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...
