Biographical Articles with page_id and creation date

SQL

SELECT  article.page_id, article.page_title, rev_timestamp
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
AND  rev_parent_id = 0
limit 10


#select page_id, page_title, rev_timestamp from revision join page on revision.rev_page = page.page_id 
#where page_namespace = 0 and rev_parent_id = 0
#LIMIT 1000000 OFFSET 1000000;

SQL

Checking query status...