SQL
AخA
select distinct cl_to from categorylinks join page on page_id=cl_from where page_namespace=2 and page_title not like "%/%"
and cl_to not like "%Wikipedian%"
and cl_to not like "Wikipedia_sockpuppets_of%"
and cl_to not like "Suspected_Wikipedia_sockpuppets_of%"
and cl_to not like "%ser_templates%"
and cl_to not like "AfC_submissions_by_date/%"
/*/and cl_to not regexp "^User_([a-zA-Z-]{2,}-[12345N]$|[a-z]{2,4})$"
and cl_to not regexp "^WikiProject_[A-Za-z_]*_(members|participants)$"
and cl_to not regexp "task_force_(members|participants)$"
and not exists (select 1 from templatelinks join linktarget on lt_id=tl_target_id where tl_from=(select page_id from page
where page_namespace=14 and
page_title=cl_to)
and lt_namespace=10 and lt_title="Polluted_category")/**/
order by (select page_id from page where page_namespace=14 and page_title=cl_to) desc
limit 10000;
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.