Hewiki partial people articles list without defaultsort

SQL

USE hewiki_p;
SELECT distinct(replace(page_title, "_", " ")) as 'שם_הערך_לבדיקה_של_מיון_מהיר' FROM categorylinks INNER JOIN page ON page_id=cl_from
AND page_namespace=0 LEFT JOIN page_props ON pp_propname ='defaultsort' AND pp_page=cl_from
WHERE (cl_to LIKE '%אישים%' OR cl_to LIKE '%שחקני%') AND pp_propname IS NULL
AND (LENGTH(page_title) - LENGTH(REPLACE(page_title, '_', '')))>1
and (replace(page_title, "_", " ") like "% _%(%)"
or page_title not like "%)")
and replace(page_title, "_", " ") not like "%, מלך %"
and replace(page_title, "_", " ") not like "%, נסיך %"
and replace(page_title, "_", " ") not like "%, דוכס %"
and replace(page_title, "_", " ") not like "%, קיסר %"
and replace(page_title, "_", " ") not like "%, הנסיך %"
and replace(page_title, "_", " ") not like "%, נסיכת %"
and replace(page_title, "_", " ") not like "%, קיסרית %"
and replace(page_title, "_", " ") not like "%, המלכה %"
and replace(page_title, "_", " ") not like "%, הרוזנת %"
and replace(page_title, "_", " ") not like "%, מלכת %"
and replace(page_title, "_", " ") not like "%, דוכסית %"
and replace(page_title, "_", " ") not like "%, הדוכס %"
and replace(page_title, "_", " ") not like "%, הרוזן %"
and replace(page_title, "_", " ") not like "%, הדוכסית %"
and replace(page_title, "_", " ") not like "%, יורש העצר %"
and replace(page_title, "_", " ") not like "%, ברון %"
and replace(page_title, "_", " ") not like "%, רוזן %"
and replace(page_title, "_", " ") not like "%, מרקיזת %"
and not page_title like "בית_ה%"
and not page_title like "נמל_התעופה_%"
SQL

Checking query status...
