USE commonswiki_p;

SELECT img_name AS Name, img_timestamp AS Uploaddate, 'Not deleted' AS Status, '' AS DeletionDate, '' AS DeletionReason FROM image

WHERE img_timestamp > 20160308000000 AND img_timestamp < 20160308240000

AND img_description LIKE 'Cross-wiki upload from %'

UNION ALL

SELECT oi_name AS Name, oi_timestamp AS Uploaddate, 'Overwritten' AS Status, '' AS DeletionDate, '' AS DeletionReason FROM oldimage

WHERE oi_timestamp > 20160308000000 AND oi_timestamp < 20160308240000

AND oi_description LIKE 'Cross-wiki upload from %'

UNION ALL

SELECT fa_name AS Name, fa_timestamp AS Uploaddate, 'Deleted' AS Status, fa_deleted_timestamp AS DeletionDate, fa_deleted_reason AS DeletionReason FROM filearchive

WHERE fa_timestamp > 20160308000000 AND fa_timestamp < 20160308240000

AND fa_description LIKE 'Cross-wiki upload from %'

GROUP BY Uploaddate