select pageA.page_title

from page pageA

where pageA.page_namespace = 0

and pageA.page_is_redirect = 0

and not exists(

  select 1 from categorylinks join page pageB on pageB.page_namespace = 1

  where pageB.page_id=categorylinks.cl_from 

  and pageB.page_title = pageA.page_title

  and (categorylinks.cl_to like "%articles" or categorylinks.cl_to like "%disambiguation%")

)

and not exists(

  select 1 from categorylinks

  where pageA.page_id=categorylinks.cl_from 

  and (categorylinks.cl_to like "%disambiguation")

)

  limit 30

​