Deletion discussions linked from User namespace 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
AND NOT EXISTS
(SELECT * FROM plwiki_p.page_props AS disambig1
WHERE disambig1.pp_propname LIKE 'disambiguation'
AND disambig1.pp_page = plwiki_p.page.page_id)
AND NOT EXISTS
(SELECT * FROM enwiki_p.page_props AS disambig2
WHERE disambig2.pp_propname LIKE 'disambiguation'
AND disambig2.pp_page = enwiki_p.page.page_id)
SQL

Checking query status...
