-- See [[Special:Diff/904016069]]

SELECT

  pl_from,

  -- pl_from_namespace does not appear to be consistently reliable;

  -- it might be better to select from the page table and join the pagelinks table to it.

  pl_from_namespace AS 'NS (from pl)',

  page_namespace AS 'NS',

  page_title,

  pl_namespace AS 'Link NS',

  pl_title

FROM pagelinks

LEFT JOIN page ON page_id = pl_from

WHERE

  pl_from_namespace = 0

  AND pl_namespace = 2

  -- AND pl_namespace != 0

ORDER BY page_title