SELECT page_id,

       page_title,

       page_len,

       DATE_FORMAT(MIN(rev_timestamp), '%Y-%m-%d %H:%i:%s') AS 'First revision'

FROM page

JOIN revision ON rev_page = page_id

WHERE page_id IN (SELECT page_id

                  FROM page

                  LEFT JOIN externallinks ON el_from = page_id

                  LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'disambiguation'

                  LEFT JOIN categorylinks ON cl_from = page_id AND cl_to = 'All_set_index_articles'

                  WHERE page_namespace = 0

                    AND page_is_redirect = 0

                    AND el_id IS NULL

                    AND pp_page IS NULL

                    AND cl_from IS NULL

                    AND page_id IN (SELECT DISTINCT rev_page FROM revision WHERE rev_timestamp < '2002'))

GROUP BY page_id, page_title, page_len

ORDER BY MIN(rev_timestamp) ASC;