Cross-wiki upload from *.wikipedia.org [08.03.2016] (living & tagged & deleted & from where))

Executed on 10.05.2016. 1.289** rows.  902 living (87 pending deletion), 387 deleted. 
2nd run on 12.05.2016. 1.309** rows. 846 living (180 pending deletion), 463 deleted.
3rd run on 15.05.2016: 1.317** rows. 813 living (252 pending deletion), 504 deleted.
4th run on 29.05.2016: 1.291** rows. 643 living (97 pending deletion), 648 deleted.
5th run on 01.06.2016: 1.299** rows. 522 living (146 pending deletion), 777 deleted.
6th run on 07.06.2016: 1.279** rows. 446 living (73 pending deletion), 833 deleted.
7th run on 27.07.2016: 1.276** rows, 363 living (0 pending deletion), 913 deleted.
**) including some double entries due to bug [[phabricator:T140522]]

SQL

USE commonswiki_p;
SELECT CONCAT('[[:File:', img_name, ']]') AS Name, img_timestamp AS UploadDate, user_registration AS RegistrationDate, img_description AS Origin, '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
JOIN user ON img_user = user_id
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 > 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, user_registration AS RegistrationDate, oi_description AS Origin, 'Overwritten' AS Status, '' AS DeletionDate, '' AS DeletionReason, tl_title AS Template FROM oldimage
JOIN page ON page_title = oi_name AND page_namespace = 6
JOIN user ON oi_user = user_id
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 > 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, user_registration AS RegistrationDate, fa_description AS Origin, 'Deleted' AS Status, fa_deleted_timestamp AS DeletionDate, fa_deleted_reason AS DeletionReason, '' AS Template FROM filearchive
JOIN user ON fa_user = user_id
WHERE fa_timestamp > 20160308000000 AND fa_timestamp < 20160308240000
AND fa_description LIKE 'Cross-wiki upload from %'
GROUP BY Uploaddate

SQL

Checking query status...