SQL
x
-- See [[Special:Diff/904016069]]
SELECT
COUNT(*)
/*pl_from_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
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.