SQL
AخA
select page_title,concat("User:",pl_title)
from pagelinks join page on pl_from=page_id where pl_namespace=3 and pl_from_namespace=0
and not exists (select 1 from categorylinks where cl_from=pl_from and cl_to="All_articles_proposed_for_deletion")
and pl_title != (select replace(actor_name," ","_") from actor_revision join revision on rev_id=page_latest where actor_id=rev_actor);
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.