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 = 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 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