SQL
AخA
USE commonswiki_p;
SELECT
LEFT(fa_deleted_timestamp,8) AS Date,
CAST(fa_width * fa_height / 1000000 AS INTEGER) AS Res,
fa_name AS File,
LEFT(fa_deleted_reason, 80) AS Comment
from filearchive
WHERE fa_deleted_user="459942"
ORDER BY LEFT(fa_timestamp, 8) DESC, fa_width * fa_height DESC
LIMIT 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.