Untitled query #73091

SQL

SELECT revisions.rev_page page_id,pagelinks.pl_title link_title#, pp.page_id link_id  page.page_title, 
FROM pagelinks
    INNER JOIN (SELECT distinct rev_page
                FROM revision
                WHERE rev_timestamp BETWEEN '20220601000001' and '20220602000001' LIMIT 100
               ) revisions 
    on pagelinks.pl_from=revisions.rev_page 
    and  pagelinks.pl_namespace='0' and pagelinks.pl_from_namespace='0'
	#LEFT JOIN page on page.page_id = revision.rev_page
    #LEFT JOIN page pp on pp.page_title = pagelinks.pl_title
# 14 M for 100k = 140 for 1
SQL

Checking query status...
