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 cat_pages > 0

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;