Untitled query #77823

SQL

select A.TrimPage , A.rev_timestamp from
(SELECT  TRIM("Articles_for_deletion/" from A.page_title) as TrimPage, page_id, rev_timestamp
FROM page join revision 
on page.page_id = revision.rev_page
WHERE page_title LIKE '%Articles_for_deletion%'
AND page_namespace = 4
AND page_is_redirect = 0
and rev_parent_id=0
and TRIM("Articles_for_deletion/" from page_title) in 
(
SELECT  article.page_title
FROM page
INNER JOIN page article
ON page.page_title=article.page_title
INNER JOIN revision
on revision.rev_page = page.page_id
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
)) as A join page on page.page_title = A.TrimPage
limit 500
SQL

Checking query status...
