[[mw:Topic:T2cwp91qh66mpnde]]

SQL

USE commonswiki_p;
SELECT CONCAT('[[:File:', img_name, ']]') AS Name, img_timestamp AS UploadDate, 'Not deleted' AS Status, '' AS DeletionDate, '' AS DeletionReason, tl_title AS Template FROM image
JOIN page ON page_title = img_name AND page_namespace = 6
LEFT JOIN templatelinks ON page_id = tl_from AND tl_namespace = 10 AND tl_title IN ('Deletion_template_tag', 'OTRS_pending', 'OTRS_received')
WHERE img_timestamp > 20160308000000 AND img_timestamp < 20160308240000
AND img_description LIKE 'Cross-wiki upload from %'
UNION ALL
SELECT CONCAT('[[:File:', oi_name, ']]') AS Name, oi_timestamp AS Uploaddate, 'Overwritten' AS Status, '' AS DeletionDate, '' AS DeletionReason, tl_title AS Template FROM oldimage
JOIN page ON page_title = img_name AND page_namespace = 6
LEFT JOIN templatelinks ON page_id = tl_from AND tl_namespace = 10 AND tl_title IN ('Deletion_template_tag', 'OTRS_pending', 'OTRS_received')
WHERE oi_timestamp > 20160308000000 AND oi_timestamp < 20160308240000
AND oi_description LIKE 'Cross-wiki upload from %'
UNION ALL
SELECT CONCAT('[[:File:', fa_name, ']]') AS Name, fa_timestamp AS Uploaddate, 'Deleted' AS Status, fa_deleted_timestamp AS DeletionDate, fa_deleted_reason AS DeletionReason, '' AS Template FROM filearchive
WHERE fa_timestamp > 20160308000000 AND fa_timestamp < 20160308240000
AND fa_description LIKE 'Cross-wiki upload from %'
GROUP BY Uploaddate
SQL

Checking query status...
