-- currently-deleted pages

SELECT CONCAT('[[', REPLACE(ar_title, '_', ' '), ']]') AS title,

       CONCAT('[[User:', actor_name, ']]') AS creator,

       CAST(ar_timestamp AS DATETIME) AS timestamp

FROM archive

JOIN actor_archive ON actor_id = ar_actor

WHERE ar_namespace = 0

  AND ar_parent_id = 0

  AND ar_title IN ('DJ_Kamal_Mustafa', 'Kamal_Mustafa_(filmmaker)', 'Kamal_Mustafa_(DJ)',

                   'Operation_Swift_Retort_(2019_Film)', 'Operation_Swift_Retort_(short_film)', 'Operation_Swift_Retort_(film)')

UNION

​

-- currently-existing pages

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]'),

       CONCAT('[[User:', actor_name, ']]'),

       CAST(rev_timestamp AS DATETIME)

FROM revision

JOIN page ON page_id = rev_page

JOIN actor_revision ON actor_id = rev_actor

WHERE page_namespace = 0

  AND rev_parent_id = 0

  AND page_title IN ('DJ_Kamal_Mustafa', 'Kamal_Mustafa_(filmmaker)', 'Kamal_Mustafa_(DJ)',

                     'Operation_Swift_Retort_(2019_Film)', 'Operation_Swift_Retort_(short_film)', 'Operation_Swift_Retort_(film)')

​

ORDER BY timestamp;