SQL
AخA
select concat("Category:",page_title),page_len from page
join revision on rev_page=page_id and rev_parent_id=0
join category on cat_title=page_title
where page_namespace=14
and page_title like "%Wikipedian%"
and not exists (select 1 from categorylinks where cl_from=page_id and cl_to="Wikipedia_soft_redirected_categories")
and not exists (select 1 from categorylinks join page contents on page_id=cl_from where cl_to=cat_title and contents.page_namespace in (2,14))
order by rev_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.