Commons categories with no Wikidata sitelink but with de-interwiki with sitelink

Commons categories with no Wikidata sitelink but with en-interwiki with sitelink.  Thanks to Matěj Suchánek at wikidata Project Chat, 
https://www.wikidata.org/w/index.php?title=Wikidata%3AProject_chat&type=revision&diff=708005197&oldid=707998591

SQL

USE commonswiki_p;
SELECT p.page_title AS cat_name, ll.ll_title AS de_interwiki, pp1.pp_value AS item, wbt.term_text AS en_label, p2.page_namespace AS ns, p2.page_title AS page
#SELECT p.page_title AS cat_name, ll.ll_title AS de_interwiki, pp1.pp_value AS item, p2.page_namespace AS ns, p2.page_title AS page
FROM page AS p
JOIN langlinks AS ll ON ll.ll_from = p.page_id AND ll.ll_lang = 'de' 
LEFT JOIN page_props AS pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
LEFT JOIN dewiki_p.page AS p1 ON p1.page_title = ll.ll_title AND p1.page_namespace = 0
LEFT JOIN dewiki_p.page_props AS pp1 ON pp1.pp_page = p1.page_id AND pp1.pp_propname = 'wikibase_item'

WHERE p.page_namespace=14 AND pp.pp_value IS NULL AND pp1.pp_value IS NOT NULL
ORDER BY cat_name
LIMIT 10

SQL

Checking query status...