select p.page_namespace, p.page_title, p.page_id, r.rev_id, r.rev_actor, r.rev_timestamp, r.rev_minor_edit

from revision r

join page p on r.rev_page=p.page_id

join (select cl_to

from categorylinks

where cl_from = 45711036 

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

order by r.rev_timestamp

limit 100