select p.page_namespace, p.page_title, p.page_id

from page p

join (select cl_to

from categorylinks

where cl_from = 49001 

and cl_to not like 'Articles_%' and cl_to not like 'Use_%' and cl_to not like 'CS%' and cl_to not like 'Commons_category_%' 

and cl_to not like 'Pages_%' and cl_to not like 'All_%' and cl_to not like 'AC_%' and cl_to not like 'Good_articles'

 and cl_to not like '%Webarchive%' and cl_to not like '%Wikipedia%' and cl_to not like '%Wikidata%') t1

 on t1.cl_to=p.page_title

where p.page_namespace=0 or p.page_namespace=14

limit 100