SQL
AخA
select page_title,concat("User:",pl_title)
from pagelinks join page on pl_from=page_id where pl_namespace=2 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 actor_name from actor_revision join revision on rev_id=page_latest);
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.