https://bugzilla.wikimedia.org/show_bug.cgi?id=59320
Web browser: ---
Bug ID: 59320
Summary: DBQ-65 Find most common hashes for Commons' deleted
images
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
This issue was converted from https://jira.toolserver.org/browse/DBQ-65.
Summary: Find most common hashes for Commons' deleted images
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Mr.Z-man <mrzmanwikim...@gmail.com>
-------------------------------------------------------------------------------
From: Mike.lifeguard <mike.lifeguard...@gmail.com>
Date: Tue, 16 Jun 2009 18:31:09
-------------------------------------------------------------------------------
I'd like to have a list of the most common sha1 hashes for Commons' deleted
images. Specifically, I'm interested in vandalistic images, so the query could
be limited to
a) those with \b(?:vandal(?:ism)?|goatse|shock image|...)\b in the delete
reason and/or
b) the last ~10,000 deletions or something (if that'd actually make a
difference)
For output, I'd like a list of the top 100 sha1 hashes and a file name for each
hash so I can find the file.
So far as I know, the hashes aren't stored for deleted files.
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
