Web browser: ---
            Bug ID: 59320
           Summary: DBQ-65 Find most common hashes for Commons' deleted
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
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 <>

From: Mike.lifeguard <>
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

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

Reply via email to