Userspace links in articles

SQL

-- 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.
  CASE
    WHEN pl_from_namespace != page_namespace THEN CONCAT(pl_from_namespace, ' / ', page_namespace)
    ELSE page_namespace
  END AS 'NS'
  page_title,
  pl_namespace AS 'Link NS',
  pl_title
FROM pagelinks
LEFT JOIN page ON page_id = pl_from
LEFT JOIN templatelinks ON tl_from = page_id
WHERE
  pl_from_namespace = 0
  AND pl_namespace = 2
  -- AND pl_namespace != 0
GROUP BY pl_from -- An unfortunate necessity to avoid excessive templatelinks rows
ORDER BY page_title
SQL

Checking query status...
