Cross-wiki upload from pt.wikipedia.org [January 2016] (living & tagged & deleted)

1st run on 31.05.2016. 1301 rows. 476 living (11 pending deletion), 825 deleted.
2nd run on 06.06.2016. 1328 rows. 442 living (183 pending deletion), 886 deleted.
3rd run on 22.06.2016. 1301 rows. 275 living (18 pending deletion). 1026 deleted.
4th run on 06.07.2016. 1301 rows. 221 living (28 pending deletion). 1080 deleted.
5th run on 28.07.2017. 1300 rows. 186 living (0 pending deletion). 1114 deleted.

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', 'No_permission_since', 'No_source_since', 'Copyvio')
WHERE img_timestamp > 20160101000000 AND img_timestamp < 20160131240000
AND img_description = 'Cross-wiki upload from pt.wikipedia.org'
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 = oi_name AND page_namespace = 6
LEFT JOIN templatelinks ON page_id = tl_from AND tl_namespace = 10 AND tl_title IN ('Deletion_template_tag', 'No_permission_since', 'No_source_since', 'Copyvio')
WHERE oi_timestamp > 20160101000000 AND img_timestamp < 20160131240000
AND oi_description = 'Cross-wiki upload from pt.wikipedia.org'
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 > 20160101000000 AND img_timestamp < 20160131240000
AND fa_description = 'Cross-wiki upload from pt.wikipedia.org'
GROUP BY Uploaddate

SQL

Checking query status...