pl wikisource Pages_Without_Scans

SQL

SELECT
	page_title AS title,
	page_len AS len,
    pl_title AS author,
	DATE_FORMAT(MAX(rev_timestamp),'%Y-%m-%d') AS ledit_date,
    DATE_FORMAT(MIN(rev_timestamp),'%Y-%m-%d') AS create_date
FROM
	revision, page LEFT JOIN (SELECT DISTINCT pl_from, pl_title FROM pagelinks WHERE pl_namespace = 104) AS PGL on page_id = pl_from
WHERE
	page_id = rev_page AND
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	page_id NOT IN (SELECT DISTINCT
                    	tl_from
                    FROM
                    	templatelinks,
                    	page,
                    	linktarget
                    WHERE
                    	page_id=tl_from AND
                    	tl_target_id = lt_id AND
                    	lt_namespace = 100 AND
                    	page_namespace = 0) AND
	page_id NOT IN (SELECT
                    	page_id
                    FROM
                    	page,
                    	templatelinks,
                    	linktarget
                    WHERE
                    	page_id=tl_from AND
                    	tl_target_id = lt_id AND
                    	page_namespace=0 AND
                    	lt_namespace=10 AND
                    (lt_title='Versions' OR lt_title='Translations' OR lt_title='Disambiguation' OR lt_title='Interwiki redirect')) AND
    page_title NOT LIKE '%/%'
GROUP BY title
ORDER BY len
LIMIT 100000;
SQL

Checking query status...
