categorii fără IW, de interconectat

SQL

SELECT CONCAT("Category:",wp.page_title)
	FROM warwiki_p.page wp/*
	LEFT JOIN warwiki_p.langlinks wl
    	ON wl.ll_from = wp.page_id*/
join warwiki_p.categorylinks wc on wc.cl_from = wp.page_id
	LEFT JOIN (SELECT * FROM warwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS wpp
		ON wpp.pp_page = wp.page_id
JOIN (SELECT * FROM cebwiki_p.page cp LEFT JOIN (SELECT * FROM cebwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS cpp
ON cpp.pp_page = cp.page_id
join cebwiki_p.categorylinks cc on cp.page_id=cc.cl_from WHERE cp.page_namespace = 14 and cp.page_is_redirect = 0 and cpp.pp_value is NULL) AS ceb
		ON ceb.page_title = wp.page_title
WHERE wpp.pp_value is NULL and ceb.cl_to=wc.cl_to
#AND wl.ll_title IS NULL
AND wp.page_namespace = 14 and wp.page_is_redirect = 0
ORDER BY wp.page_title;
SQL

Checking query status...
