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%" or page_title like "User%"
and cat_pages > 0
and cat_subcats = 0
and not exists (select 1 from categorylinks join page contents on page_id=cl_from where cl_to=cat_title
and not (exists (select 1 from templatelinks where tl_from=contents.page_id and tl_namespace=10 and tl_title="Userbox")
and (contents.page_namespace != 2 or contents.page_title like "%/%")))
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.