nlwiki Isotopes and similar needing catsort

SQL

SELECT 
	pl.page_title AS 'pl', ppl.pp_value AS 'ls', 
    ph.page_title AS 'ph', pph.pp_value AS 'hs'
FROM 
	page pl LEFT JOIN page_props ppl ON (pp_page=pl.page_id AND pp_propname='defaultsort'), 
    page ph LEFT JOIN page_props pph ON (pp_page=ph.page_id AND pp_propname='defaultsort')
WHERE pl.page_namespace=0 AND ph.page_namespace=0 AND 
	pl.page_is_redirect=0 AND ph.page_is_redirect=0 AND 
	pl.page_title REGEXP '^[A-Z][a-zäëïöüáéíóúàèìòùâêîôû]+[\\- ][0-9]+$' AND ph.page_title REGEXP '^[A-Z][a-zäëïöüáéíóúàèìòùâêîôû]+[\\- ][0-9]+$' AND
    REGEXP_SUBSTR(pl.page_title,'^[^\\- ]+')=REGEXP_SUBSTR(ph.page_title,'^[^\\- ]+') AND
    LENGTHB(pl.page_title)<LENGTHB(ph.page_title)
#GROUP BY REGEXP_SUBSTR(pl.page_title,'^[^-]+')
HAVING `ls`=''
SQL

Checking query status...
