alswiki displaytitle

SQL

USE cswiki_p;
SELECT page_namespace, page_title#, cl_sortkey_prefix
FROM categorylinks JOIN page ON cl_from = page_id
JOIN page_props ON page_id = pp_page AND pp_propname = 'defaultsort'
WHERE page_title = cl_to AND page_namespace = 0 AND page_is_redirect = 0
AND cl_sortkey_prefix = pp_value;
/*
USE cswiki_p;
SELECT page_title, rev_user_text, rev_timestamp
FROM revision
JOIN page ON page_id = rev_page
WHERE page_is_redirect = 0
AND page_namespace = 0
AND rev_parent_id = 0
AND rev_timestamp BETWEEN 20180228230000 AND 20180331230000
ORDER BY rev_timestamp;
*/
SQL

Checking query status...
