SQL
AخA
SELECT
page_title AS "Page"
FROM page
JOIN pagelinks
ON pl_from = page_id
AND page_is_redirect = 1
AND pl_namespace = 0
AND page_namespace = 0
AND page_len < 58
AND (NOT EXISTS(
SELECT
*
FROM page
WHERE page_title = pl_title
AND page_namespace = 0))
order by page_title
;
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.