This query is marked as a draft This query has been published by Bdijkstra.

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.

Checking query status...