categorii ceb war singure în itemii wikidata

SQL

USE idwiki_p;
SELECT CONCAT("Templat:",page_title), pp_value#CONCAT("Category:",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/*14*/ and page_title in (select page_title
from enwiki_p.page where page_namespace = 10 )
AND #ll_title IS NULL 
ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
group BY page_title
ORDER BY page_title;
/*
USE warwiki_p;
SELECT CONCAT("Category:",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 ll_title IS NULL
AND page_namespace = 14
ORDER BY page_title;*/
SQL

Checking query status...
