Untitled query #7592

SQL

USE etwiki_p;
SELECT page_title, cl_to, page_is_redirect
	FROM (SELECT * FROM categorylinks WHERE cl_to IN ("Inimesed")) AS category
    JOIN (SELECT * FROM page WHERE page_namespace = 0) AS pages
		ON page_id = cl_from
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'defaultsort') AS sorted
		ON pp_page = page_id
WHERE pp_propname IS NULL
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...
