categorii fără IW, de interconectat

SQL

SELECT CONCAT("Category:",sp.page_title),wpp.pp_value
	FROM svwiki_p.page sp/*
	LEFT JOIN warwiki_p.langlinks wl
    	ON wl.ll_from = wp.page_id*/
join svwiki_p.categorylinks sc on sc.cl_from = sp.page_id
	LEFT JOIN (SELECT * FROM svwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS spp
		ON spp.pp_page = sp.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 = sp.page_title
JOIN (SELECT * FROM warwiki_p.page wp 
      LEFT JOIN (SELECT * FROM warwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS wpp
ON wpp.pp_page = wp.page_id
join warwiki_p.categorylinks wc on wp.page_id=wc.cl_from 
      WHERE wp.page_namespace = 14 and wp.page_is_redirect = 0 and wpp.pp_value is NULL) AS war
		ON war.page_title = sp.page_title
WHERE /*wpp.pp_value is NULL and*/ ceb.cl_to=sc.cl_to and war.cl_to=sc.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...
