use enwiki_p;

select *

from page p

join page_props pp on p.page_id=pp.pp_page

where p.page_namespace=0 and p.page_title in (select distinct pla.page_title

        from categorylinks cla

        join page pla on cla.cl_from=pla.page_id# and cla.tl_from_

        where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="Unassessed_Basketball_articles")

and pp_propname='defaultsort'

limit 50;