use hewiki_p;

select page_namespace, page_title

from page inner join page_props

on page_id = pp_page

where pp_propname = "defaultsort"

and replace(replace(pp_value, ",", ""), " ", "_") = page_title

and locate("_", page_title) = 0

order by page_namespace asc;

select page_title, pp_value as defsort, replace(replace(pp_value, ",", ""), " ", "_") as replaced, locate("_", page_title) as space

from page inner join page_props

on page_id = pp_page

where page_namespace = 0

and pp_propname = "defaultsort"

having replaced = page_title

and space > 0

​