User:Legoktm/Blocks

Some statistics about blocks in 2012. The raw queries are provided below for clarification and reuse.

Queries
mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND (log_comment like "%Long term abuse%" OR log_comment="LTA" OR log_comment="abuse"); +--+ +--+ +--+ 1 row in set (2 min 14.01 sec) mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND (log_comment like "%Abusing multiple accounts%" OR log_comment like "%sock puppet%"); +--+ +--+ +--+ 1 row in set (37.99 sec) mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND log_comment like "%blocked proxy%"; +--+ +--+ +--+ 1 row in set (1.98 sec) mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND log_comment like "%civility%"; +--+ +--+ +--+ 1 row in set (1.68 sec) mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND log_comment like "%vandalism%"; +--+ +--+ +--+ 1 row in set (1.45 sec) mysql> /*SLOW_OK */ -> SELECT -> COUNT(*) -> FROM logging -> WHERE log_type="block" -> AND log_action="block" -> AND log_timestamp like "2012%" -> AND log_comment like "%spam%"; +--+ +--+ +--+ 1 row in set (1.26 sec) mysql> /*SLOW_OK */ SELECT COUNT(*) FROM logging WHERE log_type="block" AND log_action="unblock" AND log_timestamp like "2012%"; +--+ +--+ +--+ 1 row in set (1 min 31.69 sec)
 * COUNT(*) |
 * 1739 |
 * COUNT(*) |
 * 961 |
 * COUNT(*) |
 * 201955 |
 * COUNT(*) |
 * 45 |
 * COUNT(*) |
 * 1254 |
 * COUNT(*) |
 * 16227 |
 * COUNT(*) |
 * 2216 |