enwiki: Translated pages with no language links

SQL

SET max_statement_time = 300;

SELECT mainpage.page_title, page_props.pp_propname, page_props.pp_value
FROM templatelinks
INNER JOIN page talkpage ON talkpage.page_id = templatelinks.tl_from
INNER JOIN page mainpage ON talkpage.page_title = mainpage.page_title
INNER JOIN page_props ON page_props.pp_page = mainpage.page_id
WHERE templatelinks.tl_title = "Translated_page"
AND templatelinks.tl_namespace = 10
AND templatelinks.tl_from_namespace = 1
AND page_props.pp_propname = "wikibase_item"
AND mainpage.page_namespace = 0
# AND "wikibase_item" NOT IN (SELECT pp_propname FROM page_props WHERE page_props.pp_page = mainpage.page_id)
LIMIT 50

SQL

Checking query status...