Untitled query #77910

SQL

select A.page_id, A.page_title, revision.rev_timestamp from
(SELECT  article.page_id as page_id, article.page_title as page_title
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) as A inner join revision on A.page_id = revision.rev_page
and rev_parent_id=0 and rev_timestamp <=20231103235959
limit 100 offset 100
SQL

Checking query status...
