Hewiki partial people articles list without defaultsort

SQL

USE hewiki_p;
SELECT page_title, 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 "%(%)"
and replace(page_title, "_", " ") like "% _%(%)")
#or (page_title not like "%)")
    )

SQL

Checking query status...