USE commonswiki_p;

SELECT fa_name AS File, fa_timestamp AS Uploaded, LEFT(fa_deleted_timestamp,8) AS Deleted,

    fa_deleted_reason AS Comment, COUNT(*)

from filearchive

WHERE fa_description = 'Cross-wiki upload from pt.wikipedia.org'

GROUP BY Uploaded

LIMIT 100;