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