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