Unlinked categories cs news and cs wiki

SQL

SELECT CONCAT('[[Kategorie:',cswikinews_p.page.page_title,']]') AS cswikinews, CONCAT('[[Kategorie:',cswiki_p.page.page_title,']]') AS cswiki
FROM cswiki_p.page
JOIN cswikinews_p.page
ON cswiki_p.page.page_title = cswikinews_p.page.page_title
LEFT JOIN cswikinews_p.langlinks
ON ll_from = cswikinews_p.page.page_id
LEFT JOIN (SELECT * FROM cswikinews_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = cswikinews_p.page.page_id
LEFT JOIN cswikinews_p.templatelinks
ON tl_from = cswikinews_p.page.page_id
WHERE cswikinews_p.page.page_namespace = 14
AND cswikinews_p.page.page_is_redirect = 0
AND cswiki_p.page.page_namespace = 14
AND cswiki_p.page.page_is_redirect = 0
AND ll_title IS NULL
AND pp_value IS NULL
GROUP BY cswiki_p.page.page_title, cswikinews_p.page.page_title
limit 100;
SQL

Checking query status...
