User:Dominic/Chile politics

SELECT
  page_title
FROM langlinks
RIGHT JOIN (SELECT
  page_namespace,
  page_title,
  page_id
FROM page AS pgtmp
JOIN (SELECT
  pl_namespace,
  pl_title
FROM pagelinks
JOIN page
ON pl_from = page_id
WHERE page_title = "MZMcBride"
AND page_namespace = 2) AS pgltmp
ON pgltmp.pl_namespace = pgtmp.page_namespace
AND pgltmp.pl_title = pgtmp.page_title) AS pgtmp2
ON pgtmp2.page_id = ll_from
WHERE NOT EXISTS (SELECT
                    1
                  FROM langlinks
                  WHERE ll_from = pgtmp2.page_id
                  AND ll_lang = "en")
AND page_namespace = 0;