template items to be merged

SQL

/*temp*//*
use ukwiki_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 in ("Багатозначні_топоніми", "Багатозначні_терміни")
and page_title not like "%(значення)"
and page_title in (select pu.page_title
from ruwiki_p.page pu
join ruwiki_p.categorylinks c1 on pu.page_id=c1.cl_from and pu.page_title not like "%(значения)"
and c1.cl_to in ("Страницы_разрешения_неоднозначностей:_населённые_пункты", "Страницы_разрешения_неоднозначностей_по_алфавиту")
and page_is_redirect = 0 AND page_namespace = 0
)

and pp_value is not NULL
AND ll_title IS NULL*/
/**/
USE ruwiki_p;
SELECT page_title, pp_value
	FROM page
	LEFT JOIN langlinks
    	ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE pp_value is not NULL
AND page_namespace = 10 AND page_is_redirect = 0
AND #ll_title IS NULL 
ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
#ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
and page_title in (select page_title
from enwiki_p.page where page_namespace = 10 AND page_is_redirect = 0  )
group BY page_title
ORDER BY page_title;/**/
/*
use ruwiki_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 in ("Страницы_разрешения_неоднозначностей:_населённые_пункты", "Страницы_разрешения_неоднозначностей_по_алфавиту")
and page_title not like "%(значения)"
and REPLACE(page_title, '_(значения)', '') in (
select REPLACE(page_title, '_(вишезначна_одредница)', '')
#from bgwiki_p.page
#join bgwiki_p.categorylinks c1 on page_id=c1.cl_from and page_title like "%(пояснение)"
from srwiki_p.page
join srwiki_p.categorylinks c1 on page_id=c1.cl_from and page_title not like "%(вишезначна_одредница)"
and c1.cl_to = "Вишезначна_одредница"
and page_is_redirect = 0 AND page_namespace = 0
  )
and pp_value is not NULL
AND ll_title IS NULL
*/
SQL

Checking query status...
