enwiki: Translated pages with no language links

SQL

SET STATEMENT max_statement_time = 300 FOR
SELECT page.page_title, page_props.pp_propname, page_props.pp_value
FROM templatelinks
INNER JOIN page ON page.page_id = templatelinks.tl_from
INNER JOIN page_props ON page_props.pp_page = templatelinks.tl_from
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 "wikibase_item" NOT IN (SELECT pp_propname FROM page_props WHERE page_props.pp_page = templatelinks.tl_from)
LIMIT 50

SQL

Checking query status...