SQL
AخA
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 "wikibase_item" NOT IN (SELECT pp_propname FROM page_props WHERE page_props.pp_page = templatelinks.tl_from)
LIMIT 5
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.