Creators of a list of pages

SQL

-- 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)')
  
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 ('Operation_Swift_Retort_(short_film)', 'Operation_Swift_Retort_(film)')

ORDER BY timestamp;
SQL

Checking query status...
