defaultsort - Quarry

SQL

SELECT concat('#[[',page.page_title,']]') 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 
left join pagelinks 
ON pl_title=page.page_title and pl_namespace=0
left join page olddefsort on olddefsort.page_id=pl_from and olddefsort.page_title='ערן/ערכים_ללא_מיון_רגיל'
WHERE (cl_to LIKE '%אישים%' OR cl_to LIKE '%שחקני%') 
AND pp_propname IS NULL and (length(page.page_title) - length(replace(page.page_title, '_', '')))>1 and olddefsort.page_title IS NULL
group by page.page_title;
SQL

Checking query status...
