Untitled query #73091

SQL

SELECT revisions.rev_page page_id, pagelinks.pl_title link_title,  page.page_title #, pp.page_id link_id  
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 = revisions.rev_page
    #LEFT JOIN page pp on pp.page_title = pagelinks.pl_title
#          100    10 min (640 sec)
#          1k
# 14 M for 100k = 140 for 1
SQL

Checking query status...
