SQL
AخA
SELECT
REPLACE(a.page_title,'_',' ') AS title,
a.page_is_redirect AS redir,
cl_sortkey_prefix AS sortkey,
LENGTH(cl_sortkey_prefix) AS 'length',
a.page_id AS 'a.page_id',
c.page_id AS 'c.page_id',
a.page_latest,
cat_pages AS '#cat'
FROM
page a
INNER JOIN page c ON a.page_title=c.page_title
INNER JOIN category ON c.page_title=cat_title
LEFT JOIN categorylinks ON (a.page_id=cl_from AND c.page_title=cl_to)
WHERE
a.page_namespace=0 AND
c.page_namespace=14 AND
(LENGTH(cl_sortkey_prefix)=0 OR LEFT(cl_sortkey_prefix, 1) NOT IN (' ', '*')) AND
cat_pages>2
ORDER BY a.page_latest DESC
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.