Articles about people in cswiki without DEFAULTSORT

SQL

USE cswiki_p;
SELECT page_title, cl_to, page_is_redirect
	FROM (SELECT * FROM categorylinks WHERE cl_to IN ("Muži","Ženy")) AS category
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'defaultsort') AS sorted
		ON pp_page = page_id
    JOIN page
		ON page_id = cl_from
	LEFT JOIN (SELECT * FROM templatelinks WHERE tl_title IN ("Infobox_-_panovnice", "Infobox_-_panovník") AND tl_namespace = 10) AS tl
		ON tl_from = page_id
WHERE pp_propname IS NULL
AND tl_title IS NULL
AND page_namespace = 0
AND page_title LIKE '%&_%' ESCAPE '&'
AND page_title NOT LIKE 'Svatý&_%' ESCAPE '&'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%-%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%.%'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%,&_%' ESCAPE '&'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%&_a&_%' ESCAPE '&'
AND SUBSTRING_INDEX(page_title, '(', 1) NOT LIKE '%&_z&_%' ESCAPE '&'
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...
