Shamzan draft - Quarry

SQL

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
SQL

Checking query status...
