Untitled query #77823

SQL

SELECT *
FROM pagelinks join page on pagelinks.pl_title = page.page_title
WHERE pl_title LIKE '%Articles_for_deletion%'
and not pl_title = 'Articles_for_deletion'
and pl_from in (SELECT  article.page_id
FROM page
INNER JOIN page article
ON page.page_title=article.page_title
INNER JOIN categorylinks  ON   cl_from = page.page_id
AND   categorylinks.cl_to = "WikiProject_Biography_articles"
WHERE page.page_namespace = 1 
AND article.page_namespace = 0
)
AND page_namespace = 4
AND page_is_redirect = 0

limit 30
SQL

Checking query status...
