User:Nixeagle/toolserver/admin blocks with reason of vandalism only account

This is a list of active blocks as of 02:59, 10 November 2008 (UTC) that had the reason of "vandalism only account".

select DISTINCT user_name, count(*) as counter from ipblocks JOIN user_ids ON user_id = ipb_by where ipb_reason LIKE "vandalism only account" group by user_name order by counter;

+--+-+ +--+-+ +--+-+
 * user_name                       | counter |
 * A Man In Black                  |       1 |
 * Keeper76                        |       1 |
 * Mike 7                          |       1 |
 * Cholmes75                       |       1 |
 * Gurch                           |       1 |
 * Soumyasch                       |       1 |
 * JGHowes                         |       1 |
 * Persian Poet Gal                |       1 |
 * TimVickers                      |       1 |
 * AuburnPilot                     |       1 |
 * Ameliorate!                     |       1 |
 * Academic Challenger             |       1 |
 * Sceptre                         |       1 |
 * Thatcher                        |       1 |
 * JPD                             |       1 |
 * Makemi                          |       1 |
 * Joke137                         |       1 |
 * Dijxtra                         |       1 |
 * Kyorosuke                       |       1 |
 * Verrai                          |       1 |
 * Cryptic                         |       1 |
 * RG2                             |       1 |
 * Chrislk02                       |       1 |
 * Splash                          |       1 |
 * Lethe                           |       1 |
 * Robdurbar                       |       1 |
 * Cbrown1023                      |       1 |
 * Jacoplane                       |       1 |
 * King of Hearts                  |       1 |
 * CLW                             |       1 |
 * GTBacchus                       |       1 |
 * Jpgordon                        |       1 |
 * Misza13                         |       1 |
 * FreplySpang                     |       1 |
 * J.smith                         |       1 |
 * JWSchmidt                       |       1 |
 * JDoorjam                        |       1 |
 * RobertG                         |       1 |
 * MacGyverMagic                   |       1 |
 * Khoikhoi                        |       1 |
 * InShaneee                       |       1 |
 * Oldelpaso                       |       1 |
 * JodyB                           |       1 |
 * Duk                             |       1 |
 * AndyZ                           |       1 |
 * JeremyA                         |       1 |
 * Jtkiefer                        |       1 |
 * Jfdwolff                        |       1 |
 * Femto                           |       1 |
 * Durin                           |       1 |
 * Donald Albury                   |       1 |
 * John Reaves                     |       1 |
 * Keegan                          |       1 |
 * Meegs                           |       1 |
 * Fastfission                     |       1 |
 * Husond                          |       1 |
 * Trebor                          |       1 |
 * Tregoweth                       |       1 |
 * WilyD                           |       1 |
 * Circeus                         |       1 |
 * TigerShark                      |       1 |
 * Chris 73                        |       1 |
 * Icairns                         |       1 |
 * Rx StrangeLove                  |       1 |
 * Khaosworks                      |       1 |
 * Herostratus                     |       1 |
 * Tariqabjotu                     |       1 |
 * Ricky81682                      |       1 |
 * Deiz                            |       1 |
 * Daniel                          |       1 |
 * SlimVirgin                      |       1 |
 * Kyle Barbour                    |       1 |
 * Stemonitis                      |       1 |
 * Matilda                         |       1 |
 * Cowman109                       |       1 |
 * GregAsche                       |       1 |
 * Fuzheado                        |       2 |
 * Canderson7                      |       2 |
 * Gilliam                         |       2 |
 * Durova                          |       2 |
 * Leithp                          |       2 |
 * KillerChihuahua                 |       2 |
 * Garion96                        |       2 |
 * Shreshth91                      |       2 |
 * Peter                           |       2 |
 * Chaser                          |       2 |
 * Lectonar                        |       2 |
 * TexasAndroid                    |       2 |
 * Yomangani                       |       2 |
 * Chuq                            |       2 |
 * Fys                             |       2 |
 * Sango123                        |       2 |
 * Sarah                           |       2 |
 * Moondyne                        |       2 |
 * Bucketsofg                      |       2 |
 * Royalguard11                    |       2 |
 * Anonymous editor                |       2 |
 * JesseW                          |       2 |
 * Stormie                         |       2 |
 * Johan Elisson                   |       2 |
 * Bishonen                        |       2 |
 * Rschen7754                      |       2 |
 * SCZenz                          |       2 |
 * Kurykh                          |       2 |
 * Dragons flight                  |       2 |
 * Commander Keane                 |       2 |
 * Ryulong                         |       2 |
 * Crazytales                      |       2 |
 * Ragib                           |       2 |
 * Merope                          |       2 |
 * Robth                           |       2 |
 * KimvdLinde                      |       2 |
 * Jeffrey O. Gustafson            |       2 |
 * Vsmith                          |       2 |
 * Ryan Postlethwaite              |       2 |
 * Mushroom                        |       2 |
 * Obli                            |       2 |
 * AnemoneProjectors               |       2 |
 * Isotope23                       |       2 |
 * JamesTeterenko                  |       2 |
 * Deville                         |       2 |
 * JoJan                           |       2 |
 * Shanes                          |       2 |
 * The JPS                         |       2 |
 * RyanGerbil10                    |       2 |
 * Ruud Koot                       |       3 |
 * Thunderboltz                    |       3 |
 * TenOfAllTrades                  |       3 |
 * Joelr31                         |       3 |
 * JzG                             |       3 |
 * CesarB                          |       3 |
 * Spike Wilbury                   |       3 |
 * B                               |       3 |
 * Irishguy                        |       3 |
 * Jni                             |       3 |
 * Zsinj                           |       3 |
 * Friday                          |       3 |
 * PDH                             |       3 |
 * Aaron Brenneman                 |       3 |
 * J Di                            |       3 |
 * Agathoclea                      |       3 |
 * Gnangarra                       |       3 |
 * Picaroon                        |       3 |
 * Pschemp                         |       3 |
 * Tango                           |       3 |
 * Coelacan                        |       3 |
 * Doc glasgow                     |       3 |
 * Hesperian                       |       3 |
 * Kylu                            |       3 |
 * Ezeu                            |       3 |
 * Ben W Bell                      |       4 |
 * GraemeL                         |       4 |
 * Jimfbleak                       |       4 |
 * Alex Bakharev                   |       4 |
 * Sir Nicholas de Mimsy-Porpington |      4 |
 * Tawker                          |       4 |
 * Shell Kinney                    |       4 |
 * Rune.welsh                      |       4 |
 * Feydey                          |       4 |
 * Rje                             |       4 |
 * HappyCamper                     |       4 |
 * PS2pcGAMER                      |       4 |
 * Arjun01                         |       4 |
 * Pepsidrinka                     |       4 |
 * Sandahl                         |       5 |
 * Nick                            |       5 |
 * Riana                           |       5 |
 * James086                        |       5 |
 * Raven4x4x                       |       5 |
 * Woohookitty                     |       5 |
 * Zzyzx11                         |       5 |
 * MONGO                           |       5 |
 * Daniel Olsen                    |       5 |
 * Finlay McWalter                 |       5 |
 * Rama's Arrow                    |       6 |
 * Henry Flower                    |       6 |
 * Tyrenius                        |       6 |
 * Rklawton                        |       6 |
 * Swatjester                      |       6 |
 * ZimZalaBim                      |       6 |
 * Xiner                           |       6 |
 * Antandrus                       |       6 |
 * Kjkolb                          |       6 |
 * Amberrock                       |       6 |
 * Necrothesp                      |       6 |
 * AzaToth                         |       6 |
 * Rick Block                      |       6 |
 * Retired username                |       6 |
 * Wafulz                          |       6 |
 * FayssalF                        |       7 |
 * PinchasC                        |       7 |
 * EWS23                           |       7 |
 * Alhutch                         |       7 |
 * Jayjg                           |       7 |
 * Ligulem                         |       7 |
 * Wizardman                       |       7 |
 * Geni                            |       8 |
 * Aksi great                      |       8 |
 * No Guru                         |       8 |
 * Canadian-Bacon                  |       8 |
 * Bookofjude                      |       8 |
 * Zscout370                       |       8 |
 * Oscarthecat                     |       8 |
 * Kilo-Lima                       |       9 |
 * Sandstein                       |      10 |
 * WJBscribe                       |      10 |
 * Firsfron                        |      10 |
 * Newyorkbrad                     |      10 |
 * Master Jay                      |      11 |
 * Xezbeth                         |      11 |
 * Infrogmation                    |      11 |
 * Alison                          |      11 |
 * JoanneB                         |      11 |
 * Yanksox                         |      13 |
 * Deskana                         |      13 |
 * Wangi                           |      15 |
 * Kusma                           |      16 |
 * Ahoerstemeier                   |      18 |
 * Waggers                         |      19 |
 * Angr                            |      19 |
 * Ginkgo100                       |      20 |
 * Malcolm                         |      21 |
 * Wayward                         |      22 |
 * Kafziel                         |      22 |
 * Peruvianllama                   |      23 |
 * JoshuaZ                         |      24 |
 * BorgQueen                       |      25 |
 * Theresa knott                   |      25 |
 * Kukini                          |      25 |
 * Lostintherush                   |      26 |
 * Aude                            |      28 |
 * Marudubshinki                   |      28 |
 * Samir                           |      28 |
 * Shanel                          |      34 |
 * Malo                            |      34 |
 * Kungfuadam                      |      35 |
 * ERcheck                         |      42 |
 * Bobet                           |      44 |
 * Alphachimp                      |      47 |
 * Winhunter                       |      49 |
 * Xaosflux                        |      55 |
 * Either way                      |      60 |
 * Zzuuzz                          |      61 |
 * Xy7                             |     101 |
 * Wiki alf                        |     106 |
 * Syrthiss                        |     108 |
 * Kuru                            |     117 |
 * KnowledgeOfSelf                 |     117 |
 * Samuel Blanning                 |     121 |
 * Ohnoitsjamie                    |     176 |
 * Edgar181                        |     315 |