Disambiguation articles not connected to Wikidata but similar to enwiki articles on plwiki

SQL

SELECT CONCAT('[[',plwiki_p.page.page_title,']]') AS pl, CONCAT('[[:en:',enwiki_p.page.page_title,'|',enwiki_p.page.page_title,']]') AS en
FROM enwiki_p.page
JOIN plwiki_p.page
ON enwiki_p.page.page_title = plwiki_p.page.page_title
LEFT JOIN plwiki_p.langlinks
ON ll_from = plwiki_p.page.page_id
LEFT JOIN (SELECT * FROM plwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = plwiki_p.page.page_id
LEFT JOIN plwiki_p.templatelinks
ON tl_from = plwiki_p.page.page_id
WHERE plwiki_p.page.page_namespace = 0
AND plwiki_p.page.page_is_redirect = 0
AND enwiki_p.page.page_namespace = 0
AND enwiki_p.page.page_is_redirect = 0
AND ll_title IS NULL
AND pp_value IS NULL
GROUP BY enwiki_p.page.page_title, plwiki_p.page.page_title;

SQL

Checking query status...