These are exclusively standing indefinite blocks from the ipblock table, rather than blocks from the logging table, solely to avoid that. One piece of followup I&#39;m doing will involve using the logging table instead - I&#39;m thunkin&#39; hard on ways to detect quickly-reverted blocks (compare timestamps of block/unblock, exclude those with a difference less than... or something). Parsing which unblocks apply to which blocks&#39;ll be the fun bit :)<br>
<br><div class="gmail_quote">On 30 April 2013 21:53, Aaron Halfaker <span dir="ltr">&lt;<a href="mailto:aaron.halfaker@gmail.com" target="_blank">aaron.halfaker@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Very cool!  <div><br></div><div>Is there an easy way we could detect some false-positives?  I&#39;m imagining blocks that were quickly reversed.</div><div><br></div><div>-Aaron</div></div><div class="gmail_extra">


<br><br><div class="gmail_quote"><div><div class="h5">On Tue, Apr 30, 2013 at 3:44 PM, Oliver Keyes <span dir="ltr">&lt;<a href="mailto:okeyes@wikimedia.org" target="_blank">okeyes@wikimedia.org</a>&gt;</span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">

Per Howie&#39;s prompting (this was cool! You should send it out to the team) some research I did in my spare time - <a href="http://blog.ironholds.org/?p=31" target="_blank">http://blog.ironholds.org/?p=31</a><br><br>Planning to do a pile of followup work, so any feedback, hypotheses or requests for info gratefully received.<span><font color="#888888"><br clear="all">



<br>-- <br>Oliver Keyes<br>Community Liaison, Product Development<br>Wikimedia Foundation<br>
</font></span><br></div></div>_______________________________________________<br>
EE mailing list<br>
<a href="mailto:EE@lists.wikimedia.org" target="_blank">EE@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/ee" target="_blank">https://lists.wikimedia.org/mailman/listinfo/ee</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
EE mailing list<br>
<a href="mailto:EE@lists.wikimedia.org">EE@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/ee" target="_blank">https://lists.wikimedia.org/mailman/listinfo/ee</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Oliver Keyes<br>Community Liaison, Product Development<br>Wikimedia Foundation<br>