Articles about people in cswiki without DEFAULTSORT

SQL

USE cswiki_p;
SELECT page_title, cl_to, page_is_redirect, page_latest
FROM categorylinks
JOIN page ON page_id = cl_from
LEFT JOIN page_props ON pp_page = cl_from AND pp_propname = 'defaultsort'
LEFT JOIN templatelinks ON tl_from = cl_from AND tl_namespace = 10 AND tl_title IN ("Infobox_-_panovnice", "Infobox_-_panovník", "Infobox_-_světec")
WHERE pp_propname IS NULL
AND tl_title IS NULL
AND cl_to IN ("Muži", "Ženy")
AND page_namespace = 0
AND page_title LIKE '%\_%'
AND page_title NOT LIKE 'Svatý\_%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%-%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%.%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%,\_%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%\_a\_%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%\_z\_%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%\_ze\_%'
AND SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_', 2), '_', -1) NOT LIKE '(%'
AND LENGTH(SUBSTRING_INDEX(page_title, '_', 1)) > 2
AND LENGTH(SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_', 2), '_', -1)) > 2
ORDER BY page_title;
SQL

Checking query status...
