Untitled query #9242

SQL

USE plwikisource_p;
SELECT page_id,page_title,MAX(rev_timestamp) AS last_timestamp
  FROM page JOIN templatelinks ON page_id=tl_from JOIN revision ON page_id=rev_page
  WHERE page_namespace = 0 AND tl_title='Proofreadpage_pagenum_template' AND tl_namespace=8
  GROUP BY page_id
  ORDER BY last_timestamp
  LIMIT 1000 OFFSET 100640;

SELECT DISTINCT tl_from, page_id, page_title as with_scans_by_Phe_way2
                    FROM
                    	templatelinks,
                    	page
                    WHERE
                    	page_id=tl_from AND
                    	tl_namespace = 100 AND
                    	page_namespace = 0 AND
                        page_id NOT IN (SELECT page_id
  FROM page JOIN templatelinks ON page_id=tl_from
  WHERE page_namespace = 0 AND tl_title='Proofreadpage_pagenum_template' AND tl_namespace=8
  GROUP BY page_id)
           LIMIT 1000 ;
SQL

Checking query status...
