categorii ceb war singure în itemii wikidata

SQL

USE cebwiki_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 page_namespace = 14 and page_title in (select page_title
from svwiki_p.page where page_namespace = 14 )
#AND ll_title IS NULL
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...
