Cross-wiki upload from pt.wikipedia.org [21.10.—28.10.2015] (living & deleted)

SQL

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 > 20151022000000 AND img_timestamp < 20151022240000
AND img_description = 'Cross-wiki upload from pt.wikipedia.org'
UNION ALL
SELECT oi_name AS Name, oi_timestamp AS Uploaddate, 'Overwritten' AS Status, '' AS DeletionDate, '' AS DeletionReason FROM oldimage
WHERE oi_timestamp > 20151022000000 AND oi_timestamp < 20151022240000
AND oi_description = 'Cross-wiki upload from pt.wikipedia.org'
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 > 20151022000000 AND fa_timestamp < 20151022240000
AND fa_description = 'Cross-wiki upload from pt.wikipedia.org'
GROUP BY Uploaddate

SQL

Checking query status...