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);