Untitled query #69785

SQL

select *
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
limit 100
SQL

Checking query status...
