SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS `creation`,

       EXISTS (SELECT 1

               FROM categorylinks

               WHERE cl_from = page_id

               AND cl_to = 'Redirects_from_moves') AS `R from move?`,

       page_title,

       rd_title

FROM page

JOIN revision ON rev_page = page_id

LEFT JOIN redirect ON rd_from = page_id

WHERE page_is_redirect = 1

  AND page_namespace = 0

  AND (page_title LIKE '%(untitled%'

       OR page_title LIKE '%(upcoming%'

       OR page_title LIKE 'Untitled\_%'

       OR page_title LIKE 'Upcoming\_%')

GROUP BY page_title

ORDER BY MIN(rev_timestamp) ASC;