SQL
x
use hewiki_p;
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"
and replace(replace(pp_value, ",", ""), " ", "_") = page_title
and space = 0;
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.