links - Quarry

SQL

SELECT count(*)#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' 
                ORDER BY rev_page DESC
                #LIMIT 10000  OFFSET 100000 
               ) 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
    INNER JOIN (SELECT distinct rev_page
                FROM revision
                WHERE rev_timestamp BETWEEN '20220601000001' and '20220602000001' 
                ORDER BY rev_page DESC
                #LIMIT 10000  OFFSET 100000 
               ) revisions_2 
    on pp.page_id=revisions_2.rev_page 
#          100    10 min (640 sec)    10 sec
#          1k
# 14 M for 100k = 140 for 1
SQL

Checking query status...
