use hewiki_p;

select page_title, page_props.* from page left join page_props

on page_id = pp_page where (pp_propname is null or pp_propname = 'defaultsort') 

and page_namespace = 0

and page_is_redirect = 0 limit 100

#and page_title regexp '[0-9],[0-9]'

#and pp_page is null limit 10

#and (pp_propname = "defaultsort" or pp_propname is null)

​