Which of my uploads have been deleted most recently?

This query is marked as a draft This query has been published by Fæ.

With mass uploads it can be hard to work out if deletions are going on without notification. Files filtered to avoid blank deletion requests. Some or many of these may not be my uploads, but I may have contributed to the file history in some other way.

SQL

USE commonswiki_p;
SELECT fa_name AS File,
	fa_deleted_reason AS Comment,
	LEFT(fa_deleted_timestamp,8) AS Date
from filearchive
WHERE fa_user="1086557"
AND fa_deleted_reason NOT REGEXP "recently uploaded|uthor requested|ploader requested|corrupt|empty|[Bb]lank"
ORDER BY fa_timestamp DESC
LIMIT 20;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...