People on Commons with interwikis but no Wikidata

SQL

SELECT DISTINCT page.page_title, langlinks.ll_lang, langlinks.ll_title
FROM page
INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id
INNER JOIN langlinks ON langlinks.ll_from = page.page_id
WHERE categorylinks.cl_to = "People_by_name"
AND page.page_namespace = 14
AND page.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")
AND page.page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 0)

AخA
 
SELECT DISTINCT page.page_title, langlinks.ll_lang, langlinks.ll_titleFROM pageINNER JOIN categorylinks ON categorylinks.cl_from = page.page_idINNER JOIN langlinks ON langlinks.ll_from = page.page_idWHERE categorylinks.cl_to = "People_by_name"AND page.page_namespace = 14AND page.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")AND page.page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 0)

SQL

Checking query status...