Last modified: 2013-12-21 22:35:59 UTC
This issue was converted from https://jira.toolserver.org/browse/REPORTS-49. Summary: IP block SQL Query on en-wiki Issue type: Task - A task that needs to be done. Priority: Major Status: Open Assignee: River Tarnell <river.tarnell@wikimedia.de> On Thu, 23 Oct 2008 13:18:04, brett hillebrand <server@internode.on.net> opened the following bug: > HI I would like a Query to be run on a monthly basis on the en- > wikipedia database. I want it to find all IPs that have had 5 or > more blocks and if possible, the last block being within the last > month. Im requesting this as a new measure of finding ips for > WP:ABUSE (abuse reports) Thanks User:Promethean
On Thu, 23 Oct 2008 13:54:07, DaB. <dab@ts.wikimedia.org> wrote: > Works with SELECT log_title, COUNT(log_title) AS count FROM > logging WHERE log_timestamp>20080101000000 AND log_type="block" AND > log_action="block" AND log_title REGEXP "^[0-9.]*$" GROUP BY > log_title ORDER By count DESC LIMIT 10;
