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 mainpage.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='wikibase_item')

LIMIT 50