comment on

I'd rather you replied than used a hidden update like that. Almost missed this one. :)

Anyway, tracking such things take just a little effort, but can nonetheless be done easily. Here it is with Firefox, Notepad++, and Oracle.

Copy the table from Saints in our Book
Regex replace ^(\S+)(\s)([^\t]+)(\s)(\S+)(\s)(\S+\s\S+)(\s\S+).+ with \t SELECT \1,\2'\3',\4\5,\6'\7',\8 FROM Dual UNION ALL
Replace None with 0
Dress up the data in a CTE
Add other CTEs to help

Now we have:

WITH
    Data(Ranking, Name, XP, Title, Writeups)
AS
    (
     SELECT 1,    'vroom',    1007449,    'Pope (28)',    607 FROM Dua
+l UNION ALL
     SELECT 2,    'BrowserUk',    155965,    'Pope (28)',    21909 FRO
+M Dual UNION ALL
     SELECT 3,    'ikegami',    126888,    'Pope (28)',    19558 FROM 
+Dual UNION ALL
     SELECT 4,    'Corion',    117369,    'Pope (28)',    9329 FROM Du
+al UNION ALL
     SELECT 5,    'merlyn',    71106,    'Sage (25)',    6322 FROM Dua
+l UNION ALL
     SELECT 6,    'GrandFather',    70734,    'Sage (25)',    6442 FRO
+M Dual UNION ALL
     SELECT 7,    'tye',    69411,    'Cardinal (24)',    7731 FROM Du
+al UNION ALL
     SELECT 8,    'moritz',    65717,    'Cardinal (24)',    6415 FROM
+ Dual UNION ALL
     SELECT 9,    'Ovid',    60422,    'Cardinal (24)',    2990 FROM D
+ual UNION ALL
     SELECT 10,    'dragonchild',    58430,    'Archbishop (23)',    5
+986 FROM Dual UNION ALL
     SELECT 11,    'chromatic',    58203,    'Archbishop (23)',    594
+1 FROM Dual UNION ALL
     SELECT 12,    'tilly',    57169,    'Archbishop (23)',    5646 FR
+OM Dual UNION ALL
     SELECT 13,    'zentara',    56222,    'Archbishop (23)',    7239 
+FROM Dual UNION ALL
     SELECT 14,    'davido',    55496,    'Archbishop (23)',    4697 F
+ROM Dual UNION ALL
     SELECT 15,    'Zaxo',    54784,    'Archbishop (23)',    3416 FRO
+M Dual UNION ALL
     SELECT 16,    'ww',    45737,    'Bishop (22)',    3522 FROM Dual
+ UNION ALL
     SELECT 17,    'Old_Gray_Bear',    45289,    'Bishop (22)',    587
+ FROM Dual UNION ALL
     SELECT 18,    'grinder',    43660,    'Bishop (22)',    1570 FROM
+ Dual UNION ALL
     SELECT 19,    'CountZero',    42781,    'Bishop (22)',    4270 FR
+OM Dual UNION ALL
     SELECT 20,    'marto',    41870,    'Bishop (22)',    4449 FROM D
+ual UNION ALL
     SELECT 21,    'toolic',    41169,    'Bishop (22)',    3464 FROM 
+Dual UNION ALL
     SELECT 22,    'Abigail-II',    40862,    'Bishop (22)',    4089 F
+ROM Dual UNION ALL
     SELECT 23,    'jeffa',    40055,    'Bishop (22)',    2752 FROM D
+ual UNION ALL
     SELECT 24,    'dws',    38846,    'Chancellor (21)',    2536 FROM
+ Dual UNION ALL
     SELECT 25,    'Limbic~Region',    38006,    'Chancellor (21)',   
+ 2960 FROM Dual UNION ALL
     SELECT 26,    'perrin',    36242,    'Chancellor (21)',    4171 F
+ROM Dual UNION ALL
     SELECT 27,    'Aristotle',    35627,    'Chancellor (21)',    533
+5 FROM Dual UNION ALL
     SELECT 28,    'davorg',    34015,    'Chancellor (21)',    2988 F
+ROM Dual UNION ALL
     SELECT 29,    'Fletch',    33797,    'Chancellor (21)',    3608 F
+ROM Dual UNION ALL
     SELECT 30,    'tachyon',    32350,    'Chancellor (21)',    3268 
+FROM Dual UNION ALL
     SELECT 31,    'adrianh',    32159,    'Chancellor (21)',    2205 
+FROM Dual UNION ALL
     SELECT 32,    'graff',    31655,    'Chancellor (21)',    3878 FR
+OM Dual UNION ALL
     SELECT 33,    'demerphq',    31508,    'Chancellor (21)',    3269
+ FROM Dual UNION ALL
     SELECT 34,    'Your Mother',    30594,    'Chancellor (21)',    2
+497 FROM Dual UNION ALL
     SELECT 35,    'Gavin',    30566,    'Chancellor (21)',    598 FRO
+M Dual UNION ALL
     SELECT 36,    'roboticus',    30296,    'Chancellor (21)',    286
+8 FROM Dual UNION ALL
     SELECT 37,    'eyepopslikeamosquito',    29895,    'Canon (20)', 
+   1289 FROM Dual UNION ALL
     SELECT 38,    'planetscape',    29894,    'Canon (20)',    1289 F
+ROM Dual UNION ALL
     SELECT 39,    'Joost',    29453,    'Canon (20)',    3245 FROM Du
+al UNION ALL
     SELECT 40,    'syphilis',    29373,    'Canon (20)',    2692 FROM
+ Dual UNION ALL
     SELECT 41,    'japhy',    29144,    'Canon (20)',    2347 FROM Du
+al UNION ALL
     SELECT 42,    'LanX',    29120,    'Canon (20)',    4591 FROM Dua
+l UNION ALL
     SELECT 43,    'borisz',    27898,    'Canon (20)',    913 FROM Du
+al UNION ALL
     SELECT 44,    'bart',    27165,    'Canon (20)',    2611 FROM Dua
+l UNION ALL
     SELECT 45,    'Khen1950fx',    26510,    'Canon (20)',    1899 FR
+OM Dual UNION ALL
     SELECT 46,    'Tanktalus',    26165,    'Canon (20)',    2178 FRO
+M Dual UNION ALL
     SELECT 47,    'shmem',    26153,    'Canon (20)',    2490 FROM Du
+al UNION ALL
     SELECT 48,    'strat',    26010,    'Canon (20)',    538 FROM Dua
+l UNION ALL
     SELECT 49,    'diotalevi',    25716,    'Canon (20)',    3030 FRO
+M Dual UNION ALL
     SELECT 50,    'TStanley',    25503,    'Canon (20)',    469 FROM 
+Dual UNION ALL
     SELECT 51,    'choroba',    25392,    'Canon (20)',    3377 FROM 
+Dual UNION ALL
     SELECT 52,    'ysth',    25230,    'Canon (20)',    3438 FROM Dua
+l UNION ALL
     SELECT 53,    'blazar',    24988,    'Canon (20)',    2772 FROM D
+ual UNION ALL
     SELECT 54,    'talexb',    24558,    'Canon (20)',    1833 FROM D
+ual UNION ALL
     SELECT 55,    'jdporter',    24462,    'Canon (20)',    2961 FROM
+ Dual UNION ALL
     SELECT 56,    'mirod',    24125,    'Canon (20)',    1558 FROM Du
+al UNION ALL
     SELECT 57,    'hsmyers',    23877,    'Canon (20)',    515 FROM D
+ual UNION ALL
     SELECT 58,    'almut',    23869,    'Canon (20)',    2602 FROM Du
+al UNION ALL
     SELECT 59,    'JSchmitz',    23754,    'Canon (20)',    186 FROM 
+Dual UNION ALL
     SELECT 60,    'JavaFan',    23709,    'Canon (20)',    4500 FROM 
+Dual UNION ALL
     SELECT 61,    'pg',    23122,    'Canon (20)',    1848 FROM Dual 
+UNION ALL
     SELECT 62,    'Perlbotics',    23091,    'Canon (20)',    382 FRO
+M Dual UNION ALL
     SELECT 63,    'FunkyMonk',    23048,    'Canon (20)',    1024 FRO
+M Dual UNION ALL
     SELECT 64,    'PodMaster',    21841,    'Abbot (19)',    2401 FRO
+M Dual UNION ALL
     SELECT 65,    'YuckFoo',    21789,    'Abbot (19)',    203 FROM D
+ual UNION ALL
     SELECT 66,    'kcott',    21613,    'Abbot (19)',    2262 FROM Du
+al UNION ALL
     SELECT 67,    'Juerd',    21554,    'Abbot (19)',    2249 FROM Du
+al UNION ALL
     SELECT 68,    'kyle',    21535,    'Abbot (19)',    1659 FROM Dua
+l UNION ALL
     SELECT 69,    'Mr. Muskrat',    21298,    'Abbot (19)',    1538 F
+ROM Dual UNION ALL
     SELECT 70,    'gmax',    20736,    'Abbot (19)',    292 FROM Dual
+ UNION ALL
     SELECT 71,    'broquaint',    20398,    'Abbot (19)',    1326 FRO
+M Dual UNION ALL
     SELECT 72,    'AnomalousMonk',    20041,    'Abbot (19)',    2779
+ FROM Dual UNION ALL
     SELECT 73,    'Athanasius',    20030,    'Abbot (19)',    1209 FR
+OM Dual UNION ALL
     SELECT 74,    'ambrus',    19579,    'Abbot (19)',    2738 FROM D
+ual UNION ALL
     SELECT 75,    'wfsp',    19168,    'Abbot (19)',    904 FROM Dual
+ UNION ALL
     SELECT 76,    'brian_d_foy',    19011,    'Abbot (19)',    905 FR
+OM Dual UNION ALL
     SELECT 77,    'tobyink',    18997,    'Abbot (19)',    2554 FROM 
+Dual UNION ALL
     SELECT 78,    'runrig',    18838,    'Abbot (19)',    2597 FROM D
+ual UNION ALL
     SELECT 79,    'Moriarty',    18643,    'Abbot (19)',    128 FROM 
+Dual UNION ALL
     SELECT 80,    'johngg',    18365,    'Abbot (19)',    1680 FROM D
+ual UNION ALL
     SELECT 81,    'gryphon',    18239,    'Abbot (19)',    218 FROM D
+ual UNION ALL
     SELECT 82,    'samtregar',    17928,    'Abbot (19)',    1367 FRO
+M Dual UNION ALL
     SELECT 83,    'sauoq',    17847,    'Abbot (19)',    2077 FROM Du
+al UNION ALL
     SELECT 84,    'tirwhan',    17764,    'Abbot (19)',    793 FROM D
+ual UNION ALL
     SELECT 85,    'hardburn',    17727,    'Abbot (19)',    2000 FROM
+ Dual UNION ALL
     SELECT 86,    'NetWallah',    17720,    'Abbot (19)',    1978 FRO
+M Dual UNION ALL
     SELECT 87,    'valentin',    17659,    'Abbot (19)',    16 FROM D
+ual UNION ALL
     SELECT 88,    'salva',    17212,    'Abbot (19)',    2226 FROM Du
+al UNION ALL
     SELECT 89,    'Jenda',    17005,    'Abbot (19)',    2272 FROM Du
+al UNION ALL
     SELECT 90,    'dHarry',    16922,    'Abbot (19)',    454 FROM Du
+al UNION ALL
     SELECT 91,    'sundialsvc4',    16684,    'Abbot (19)',    3923 F
+ROM Dual UNION ALL
     SELECT 92,    'Popcorn Dave',    16636,    'Abbot (19)',    670 F
+ROM Dual UNION ALL
     SELECT 93,    'derby',    16598,    'Abbot (19)',    1452 FROM Du
+al UNION ALL
     SELECT 94,    'Happy-the-monk',    16443,    'Abbot (19)',    691
+ FROM Dual UNION ALL
     SELECT 95,    'kennethk',    16375,    'Abbot (19)',    1784 FROM
+ Dual UNION ALL
     SELECT 96,    'roho',    16363,    'Abbot (19)',    108 FROM Dual
+ UNION ALL
     SELECT 97,    'McDarren',    16271,    'Abbot (19)',    794 FROM 
+Dual UNION ALL
     SELECT 98,    'rob_au',    16270,    'Abbot (19)',    806 FROM Du
+al UNION ALL
     SELECT 99,    'uksza',    16001,    'Abbot (19)',    45 FROM Dual
+ UNION ALL
     SELECT 100,    'jplindstrom',    15759,    'Monsignor (18)',    5
+09 FROM Dual UNION ALL
     SELECT 101,    'jmcnamara',    15733,    'Monsignor (18)',    985
+ FROM Dual UNION ALL
     SELECT 102,    'apl',    15717,    'Monsignor (18)',    929 FROM 
+Dual UNION ALL
     SELECT 103,    'liverpole',    15646,    'Monsignor (18)',    910
+ FROM Dual UNION ALL
     SELECT 104,    'zwon',    15371,    'Monsignor (18)',    789 FROM
+ Dual UNION ALL
     SELECT 105,    'xdg',    15350,    'Monsignor (18)',    1214 FROM
+ Dual UNION ALL
     SELECT 106,    'footpad',    15156,    'Monsignor (18)',    527 F
+ROM Dual UNION ALL
     SELECT 107,    'atcroft',    15070,    'Monsignor (18)',    630 F
+ROM Dual UNION ALL
     SELECT 108,    'scorpio17',    15053,    'Monsignor (18)',    318
+ FROM Dual UNION ALL
     SELECT 109,    'tbone1',    15038,    'Monsignor (18)',    460 FR
+OM Dual UNION ALL
     SELECT 110,    'Tux',    14716,    'Monsignor (18)',    1439 FROM
+ Dual UNION ALL
     SELECT 111,    'rinceWind',    14642,    'Monsignor (18)',    807
+ FROM Dual UNION ALL
     SELECT 112,    'John M. Dlugosz',    14523,    'Monsignor (18)', 
+   2565 FROM Dual UNION ALL
     SELECT 113,    'Roy Johnson',    14443,    'Monsignor (18)',    2
+000 FROM Dual UNION ALL
     SELECT 114,    'stvn',    13707,    'Monsignor (18)',    1102 FRO
+M Dual UNION ALL
     SELECT 115,    'bassplayer',    13553,    'Monsignor (18)',    15
+2 FROM Dual UNION ALL
     SELECT 116,    'lepetitalbert',    13540,    'Monsignor (18)',   
+ 80 FROM Dual UNION ALL
     SELECT 117,    'blakem',    13528,    'Monsignor (18)',    1150 F
+ROM Dual UNION ALL
     SELECT 118,    'valdez',    13484,    'Monsignor (18)',    507 FR
+OM Dual UNION ALL
     SELECT 119,    'grep',    13469,    'Monsignor (18)',    554 FROM
+ Dual UNION ALL
     SELECT 120,    'VSarkiss',    13460,    'Monsignor (18)',    1015
+ FROM Dual UNION ALL
     SELECT 121,    'mojotoad',    13212,    'Monsignor (18)',    491 
+FROM Dual UNION ALL
     SELECT 122,    'kvale',    12987,    'Monsignor (18)',    680 FRO
+M Dual UNION ALL
     SELECT 123,    'mr_mischief',    12928,    'Monsignor (18)',    1
+282 FROM Dual UNION ALL
     SELECT 124,    'holli',    12910,    'Monsignor (18)',    1510 FR
+OM Dual UNION ALL
     SELECT 125,    'gellyfish',    12807,    'Monsignor (18)',    149
+3 FROM Dual UNION ALL
     SELECT 126,    'Masem',    12768,    'Monsignor (18)',    981 FRO
+M Dual UNION ALL
     SELECT 127,    'dvergin',    12731,    'Monsignor (18)',    311 F
+ROM Dual UNION ALL
     SELECT 128,    'liz',    12565,    'Monsignor (18)',    724 FROM 
+Dual UNION ALL
     SELECT 129,    'MidLifeXis',    12546,    'Monsignor (18)',    14
+80 FROM Dual UNION ALL
     SELECT 130,    'jethro',    12541,    'Monsignor (18)',    1676 F
+ROM Dual UNION ALL
     SELECT 131,    'dree',    12528,    'Monsignor (18)',    79 FROM 
+Dual UNION ALL
     SELECT 132,    'blokhead',    12474,    'Monsignor (18)',    654 
+FROM Dual UNION ALL
     SELECT 133,    'bobf',    12400,    'Monsignor (18)',    474 FROM
+ Dual UNION ALL
     SELECT 134,    'gawatkins',    12393,    'Monsignor (18)',    51 
+FROM Dual UNION ALL
     SELECT 135,    'jettero',    12332,    'Monsignor (18)',    1032 
+FROM Dual UNION ALL
     SELECT 136,    'jwkrahn',    12224,    'Monsignor (18)',    1557 
+FROM Dual UNION ALL
     SELECT 137,    'blue_cowdawg',    12192,    'Monsignor (18)',    
+1344 FROM Dual UNION ALL
     SELECT 138,    'Laurent_R',    11944,    'Prior (17)',    1788 FR
+OM Dual UNION ALL
     SELECT 139,    'theorbtwo',    11814,    'Prior (17)',    1040 FR
+OM Dual UNION ALL
     SELECT 140,    'davidrw',    11652,    'Prior (17)',    1216 FROM
+ Dual UNION ALL
     SELECT 141,    'tlm',    11538,    'Prior (17)',    1145 FROM Dua
+l UNION ALL
     SELECT 142,    'FoxtrotUniform',    11475,    'Prior (17)',    61
+1 FROM Dual UNION ALL
     SELECT 143,    'friedo',    11311,    'Prior (17)',    605 FROM D
+ual UNION ALL
     SELECT 144,    'hdb',    11214,    'Prior (17)',    1489 FROM Dua
+l UNION ALL
     SELECT 145,    'Ratazong',    11143,    'Prior (17)',    451 FROM
+ Dual UNION ALL
     SELECT 146,    'Marshall',    11087,    'Prior (17)',    2300 FRO
+M Dual UNION ALL
     SELECT 147,    'Albannach',    11002,    'Prior (17)',    450 FRO
+M Dual UNION ALL
     SELECT 148,    'vek',    10929,    'Prior (17)',    549 FROM Dual
+ UNION ALL
     SELECT 149,    'jcwren',    10878,    'Prior (17)',    575 FROM D
+ual UNION ALL
     SELECT 150,    'cdarke',    10859,    'Prior (17)',    1504 FROM 
+Dual UNION ALL
     SELECT 151,    'halley',    10807,    'Prior (17)',    1058 FROM 
+Dual UNION ALL
     SELECT 152,    'afoken',    10680,    'Prior (17)',    1107 FROM 
+Dual UNION ALL
     SELECT 153,    'Erudil',    10587,    'Prior (17)',    13 FROM Du
+al UNION ALL
     SELECT 154,    'vinoth.ree',    10569,    'Prior (17)',    530 FR
+OM Dual UNION ALL
     SELECT 155,    'hotshot',    10486,    'Prior (17)',    280 FROM 
+Dual UNION ALL
     SELECT 156,    'ajt',    10456,    'Prior (17)',    198 FROM Dual
+ UNION ALL
     SELECT 157,    'Argel',    10360,    'Prior (17)',    933 FROM Du
+al UNION ALL
     SELECT 158,    'jdtoronto',    10335,    'Prior (17)',    900 FRO
+M Dual UNION ALL
     SELECT 159,    'crazyinsomniac',    10301,    'Prior (17)',    59
+6 FROM Dual UNION ALL
     SELECT 160,    'thraxil',    10195,    'Prior (17)',    237 FROM 
+Dual UNION ALL
     SELECT 161,    'ELISHEVA',    10194,    'Prior (17)',    926 FROM
+ Dual UNION ALL
     SELECT 162,    'DrHyde',    10189,    'Prior (17)',    1480 FROM 
+Dual UNION ALL
     SELECT 163,    'barrd',    10086,    'Prior (17)',    154 FROM Du
+al UNION ALL
     SELECT 164,    'hawtin',    10085,    'Prior (17)',    196 FROM D
+ual UNION ALL
     SELECT 165,    'SankoR',    10070,    'Prior (17)',    30 FROM Du
+al UNION ALL
     SELECT 166,    'ybiC',    9912,    'Prior (17)',    493 FROM Dual
+ UNION ALL
     SELECT 167,    'revdiablo',    9854,    'Prior (17)',    955 FROM
+ Dual UNION ALL
     SELECT 168,    'Sinistral',    9840,    'Prior (17)',    147 FROM
+ Dual UNION ALL
     SELECT 169,    'flexvault',    9828,    'Prior (17)',    540 FROM
+ Dual UNION ALL
     SELECT 170,    'wazoox',    9819,    'Prior (17)',    764 FROM Du
+al UNION ALL
     SELECT 171,    'BUU',    9738,    'Prior (17)',    1582 FROM Dual
+ UNION ALL
     SELECT 172,    'jZed',    9693,    'Prior (17)',    1118 FROM Dua
+l UNION ALL
     SELECT 173,    'jhourcle',    9550,    'Prior (17)',    1019 FROM
+ Dual UNION ALL
     SELECT 174,    'bradcathey',    9440,    'Prior (17)',    832 FRO
+M Dual UNION ALL
     SELECT 175,    'sgifford',    9375,    'Prior (17)',    1184 FROM
+ Dual UNION ALL
     SELECT 176,    'Cody Pendant',    9364,    'Prior (17)',    1018 
+FROM Dual UNION ALL
     SELECT 177,    'tadman',    9334,    'Prior (17)',    935 FROM Du
+al UNION ALL
     SELECT 178,    'RMGir',    9227,    'Prior (17)',    769 FROM Dua
+l UNION ALL
     SELECT 179,    'belg4mit',    9176,    'Prior (17)',    1152 FROM
+ Dual UNION ALL
     SELECT 180,    'hossman',    9156,    'Prior (17)',    736 FROM D
+ual UNION ALL
     SELECT 181,    'vagnerr',    9093,    'Prior (17)',    86 FROM Du
+al UNION ALL
     SELECT 182,    'LTjake',    9048,    'Prior (17)',    194 FROM Du
+al UNION ALL
     SELECT 183,    'prasadbabu',    9040,    'Prior (17)',    296 FRO
+M Dual UNION ALL
     SELECT 184,    'Random_Walk',    8971,    'Parson (16)',    516 F
+ROM Dual UNION ALL
     SELECT 185,    'jepri',    8962,    'Parson (16)',    775 FROM Du
+al UNION ALL
     SELECT 186,    'dave_the_m',    8945,    'Parson (16)',    846 FR
+OM Dual UNION ALL
     SELECT 187,    'chipmunk',    8901,    'Parson (16)',    932 FROM
+ Dual UNION ALL
     SELECT 188,    'cLive ;-)',    8885,    'Parson (16)',    980 FRO
+M Dual UNION ALL
     SELECT 189,    'castaway',    8669,    'Parson (16)',    829 FROM
+ Dual UNION ALL
     SELECT 190,    'Roger',    8667,    'Parson (16)',    1133 FROM D
+ual UNION ALL
     SELECT 191,    'shotgunefx',    8657,    'Parson (16)',    1085 F
+ROM Dual UNION ALL
     SELECT 192,    'coreolyn',    8640,    'Parson (16)',    428 FROM
+ Dual UNION ALL
     SELECT 193,    'dsheroh',    8638,    'Parson (16)',    854 FROM 
+Dual UNION ALL
     SELECT 194,    'ChuckularOne',    8619,    'Parson (16)',    198 
+FROM Dual UNION ALL
     SELECT 195,    'TimToady',    8578,    'Parson (16)',    479 FROM
+ Dual UNION ALL
     SELECT 196,    'thinker',    8556,    'Parson (16)',    113 FROM 
+Dual UNION ALL
     SELECT 197,    'turnstep',    8359,    'Parson (16)',    774 FROM
+ Dual UNION ALL
     SELECT 198,    'swampyankee',    8336,    'Parson (16)',    921 F
+ROM Dual UNION ALL
     SELECT 199,    'jonadab',    8312,    'Parson (16)',    1126 FROM
+ Dual UNION ALL
     SELECT 200,    'lachoy',    8260,    'Parson (16)',    425 FROM D
+ual UNION ALL
     SELECT 201,    'andreychek',    8236,    'Parson (16)',    147 FR
+OM Dual UNION ALL
     SELECT 202,    'bibliophile',    8227,    'Parson (16)',    140 F
+ROM Dual UNION ALL
     SELECT 203,    'Not_a_Number',    8151,    'Parson (16)',    492 
+FROM Dual UNION ALL
     SELECT 204,    'btrott',    8113,    'Parson (16)',    839 FROM D
+ual UNION ALL
     SELECT 205,    'thatguy',    8068,    'Parson (16)',    69 FROM D
+ual UNION ALL
     SELECT 206,    'DigitalKitty',    8013,    'Parson (16)',    194 
+FROM Dual UNION ALL
     SELECT 207,    'larsen',    8006,    'Parson (16)',    285 FROM D
+ual UNION ALL
     SELECT 208,    'chargrill',    7987,    'Parson (16)',    385 FRO
+M Dual UNION ALL
     SELECT 209,    'dorko',    7947,    'Parson (16)',    163 FROM Du
+al UNION ALL
     SELECT 210,    'Arunbear',    7895,    'Parson (16)',    728 FROM
+ Dual UNION ALL
     SELECT 211,    'Generoso',    7860,    'Parson (16)',    85 FROM 
+Dual UNION ALL
     SELECT 212,    'IlyaM',    7857,    'Parson (16)',    505 FROM Du
+al UNION ALL
     SELECT 213,    'boo_radley',    7852,    'Parson (16)',    595 FR
+OM Dual UNION ALL
     SELECT 214,    'cog',    7820,    'Parson (16)',    551 FROM Dual
+ UNION ALL
     SELECT 215,    'skx',    7800,    'Parson (16)',    285 FROM Dual
+ UNION ALL
     SELECT 216,    'Enlil',    7792,    'Parson (16)',    423 FROM Du
+al UNION ALL
     SELECT 217,    'eric256',    7782,    'Parson (16)',    1075 FROM
+ Dual UNION ALL
     SELECT 218,    'redcloud',    7728,    'Parson (16)',    27 FROM 
+Dual UNION ALL
     SELECT 219,    'jbrugger',    7681,    'Parson (16)',    389 FROM
+ Dual UNION ALL
     SELECT 220,    'Mago',    7677,    'Parson (16)',    135 FROM Dua
+l UNION ALL
     SELECT 221,    'petdance',    7671,    'Parson (16)',    537 FROM
+ Dual UNION ALL
     SELECT 222,    'randyk',    7641,    'Parson (16)',    212 FROM D
+ual UNION ALL
     SELECT 223,    'gube',    7614,    'Parson (16)',    227 FROM Dua
+l UNION ALL
     SELECT 224,    'pbeckingham',    7614,    'Parson (16)',    379 F
+ROM Dual UNION ALL
     SELECT 225,    'herveus',    7589,    'Parson (16)',    593 FROM 
+Dual UNION ALL
     SELECT 226,    'Beatnik',    7573,    'Parson (16)',    728 FROM 
+Dual UNION ALL
     SELECT 227,    'Courage',    7532,    'Parson (16)',    569 FROM 
+Dual UNION ALL
     SELECT 228,    'sweetblood',    7526,    'Parson (16)',    239 FR
+OM Dual UNION ALL
     SELECT 229,    'Spooty',    7496,    'Parson (16)',    0 FROM Dua
+l UNION ALL
     SELECT 230,    'grantm',    7400,    'Parson (16)',    662 FROM D
+ual UNION ALL
     SELECT 231,    'artist',    7384,    'Parson (16)',    885 FROM D
+ual UNION ALL
     SELECT 232,    'gaal',    7364,    'Parson (16)',    796 FROM Dua
+l UNION ALL
     SELECT 233,    'Herkum',    7342,    'Parson (16)',    630 FROM D
+ual UNION ALL
     SELECT 234,    'jasonk',    7330,    'Parson (16)',    616 FROM D
+ual UNION ALL
     SELECT 235,    'hv',    7301,    'Parson (16)',    652 FROM Dual 
+UNION ALL
     SELECT 236,    'tinita',    7301,    'Parson (16)',    669 FROM D
+ual UNION ALL
     SELECT 237,    'tall_man',    7227,    'Parson (16)',    454 FROM
+ Dual UNION ALL
     SELECT 238,    'Elian',    7220,    'Parson (16)',    602 FROM Du
+al UNION ALL
     SELECT 239,    'suaveant',    7176,    'Parson (16)',    982 FROM
+ Dual UNION ALL
     SELECT 240,    'traveler',    7156,    'Parson (16)',    641 FROM
+ Dual UNION ALL
     SELECT 241,    'gregor42',    7152,    'Parson (16)',    253 FROM
+ Dual UNION ALL
     SELECT 242,    'radiantmatrix',    7144,    'Parson (16)',    905
+ FROM Dual UNION ALL
     SELECT 243,    'princepawn',    7122,    'Parson (16)',    1092 F
+ROM Dual UNION ALL
     SELECT 244,    'jfroebe',    7112,    'Parson (16)',    590 FROM 
+Dual UNION ALL
     SELECT 245,    'Kanji',    7094,    'Parson (16)',    417 FROM Du
+al UNION ALL
     SELECT 246,    'jlongino',    7089,    'Parson (16)',    433 FROM
+ Dual UNION ALL
     SELECT 247,    'Dominus',    7079,    'Parson (16)',    507 FROM 
+Dual UNION ALL
     SELECT 248,    'Crackers2',    7029,    'Parson (16)',    209 FRO
+M Dual UNION ALL
     SELECT 249,    'cjf',    7016,    'Parson (16)',    364 FROM Dual
+ UNION ALL
     SELECT 250,    'TGI',    6985,    'Vicar (15)',    647 FROM Dual 
+UNION ALL
     SELECT 251,    'jryan',    6983,    'Vicar (15)',    543 FROM Dua
+l UNION ALL
     SELECT 252,    'arturo',    6944,    'Vicar (15)',    876 FROM Du
+al UNION ALL
     SELECT 253,    'ccn',    6907,    'Vicar (15)',    464 FROM Dual 
+UNION ALL
     SELECT 254,    'saintmike',    6901,    'Vicar (15)',    475 FROM
+ Dual UNION ALL
     SELECT 255,    'TomDLux',    6895,    'Vicar (15)',    705 FROM D
+ual UNION ALL
     SELECT 256,    'quester',    6867,    'Vicar (15)',    211 FROM D
+ual UNION ALL
     SELECT 257,    'QM',    6828,    'Vicar (15)',    1010 FROM Dual 
+UNION ALL
     SELECT 258,    'simonm',    6812,    'Vicar (15)',    554 FROM Du
+al UNION ALL
     SELECT 259,    'Bloodnok',    6809,    'Vicar (15)',    1095 FROM
+ Dual UNION ALL
     SELECT 260,    'duff',    6805,    'Vicar (15)',    799 FROM Dual
+ UNION ALL
     SELECT 261,    'Anneq',    6800,    'Vicar (15)',    96 FROM Dual
+ UNION ALL
     SELECT 262,    'davis',    6770,    'Vicar (15)',    310 FROM Dua
+l UNION ALL
     SELECT 263,    'ioannis',    6752,    'Vicar (15)',    131 FROM D
+ual UNION ALL
     SELECT 264,    'nvivek',    6706,    'Vicar (15)',    76 FROM Dua
+l UNION ALL
     SELECT 265,    'Fastolfe',    6684,    'Vicar (15)',    1236 FROM
+ Dual UNION ALL
     SELECT 266,    'virtualsue',    6620,    'Vicar (15)',    334 FRO
+M Dual UNION ALL
     SELECT 267,    'Petruchio',    6619,    'Vicar (15)',    144 FROM
+ Dual UNION ALL
     SELECT 268,    'MeowChow',    6616,    'Vicar (15)',    685 FROM 
+Dual UNION ALL
     SELECT 269,    'davies',    6599,    'Vicar (15)',    445 FROM Du
+al UNION ALL
     SELECT 270,    'zby',    6588,    'Vicar (15)',    840 FROM Dual 
+UNION ALL
     SELECT 271,    'jaldhar',    6582,    'Vicar (15)',    152 FROM D
+ual UNION ALL
     SELECT 272,    'tphyahoo',    6580,    'Vicar (15)',    689 FROM 
+Dual UNION ALL
     SELECT 273,    'toma',    6574,    'Vicar (15)',    416 FROM Dual
+ UNION ALL
     SELECT 274,    'vladb',    6536,    'Vicar (15)',    369 FROM Dua
+l UNION ALL
     SELECT 275,    'chuckbutler',    6524,    'Vicar (15)',    37 FRO
+M Dual UNION ALL
     SELECT 276,    'andreas1234567',    6520,    'Vicar (15)',    630
+ FROM Dual UNION ALL
     SELECT 277,    'stonecolddevin',    6503,    'Vicar (15)',    686
+ FROM Dual UNION ALL
     SELECT 278,    'b10m',    6489,    'Vicar (15)',    575 FROM Dual
+ UNION ALL
     SELECT 279,    'AcidHawk',    6487,    'Vicar (15)',    232 FROM 
+Dual UNION ALL
     SELECT 280,    'silent11',    6474,    'Vicar (15)',    175 FROM 
+Dual UNION ALL
     SELECT 281,    'pc88mxer',    6466,    'Vicar (15)',    838 FROM 
+Dual UNION ALL
     SELECT 282,    'Errto',    6426,    'Vicar (15)',    585 FROM Dua
+l UNION ALL
     SELECT 283,    'RavingGoat',    6416,    'Vicar (15)',    4 FROM 
+Dual UNION ALL
     SELECT 284,    'erix',    6371,    'Vicar (15)',    361 FROM Dual
+ UNION ALL
     SELECT 285,    'jima',    6350,    'Vicar (15)',    18 FROM Dual 
+UNION ALL
     SELECT 286,    'Skeeve',    6336,    'Vicar (15)',    857 FROM Du
+al UNION ALL
     SELECT 287,    'kiat',    6302,    'Vicar (15)',    500 FROM Dual
+ UNION ALL
     SELECT 288,    'Marza',    6280,    'Vicar (15)',    447 FROM Dua
+l UNION ALL
     SELECT 289,    'samizdat',    6259,    'Vicar (15)',    532 FROM 
+Dual UNION ALL
     SELECT 290,    'exussum0',    6245,    'Vicar (15)',    600 FROM 
+Dual UNION ALL
     SELECT 291,    'bingos',    6213,    'Vicar (15)',    170 FROM Du
+al UNION ALL
     SELECT 292,    'spiritway',    6198,    'Vicar (15)',    586 FROM
+ Dual UNION ALL
     SELECT 293,    'educated_foo',    6186,    'Vicar (15)',    757 F
+ROM Dual UNION ALL
     SELECT 294,    'karlgoethebier',    6172,    'Vicar (15)',    914
+ FROM Dual UNION ALL
     SELECT 295,    'idsfa',    6170,    'Vicar (15)',    313 FROM Dua
+l UNION ALL
     SELECT 296,    'mpeppler',    6164,    'Vicar (15)',    798 FROM 
+Dual UNION ALL
     SELECT 297,    'manoj_speed',    6150,    'Vicar (15)',    20 FRO
+M Dual UNION ALL
     SELECT 298,    'polettix',    6094,    'Vicar (15)',    811 FROM 
+Dual UNION ALL
     SELECT 299,    'gjb',    6091,    'Vicar (15)',    467 FROM Dual 
+UNION ALL
     SELECT 300,    'ciderpunx',    6075,    'Vicar (15)',    130 FROM
+ Dual UNION ALL
     SELECT 301,    'RichardK',    6072,    'Vicar (15)',    390 FROM 
+Dual UNION ALL
     SELECT 302,    'kudra',    6066,    'Vicar (15)',    317 FROM Dua
+l UNION ALL
     SELECT 303,    'ghenry',    6049,    'Vicar (15)',    571 FROM Du
+al UNION ALL
     SELECT 304,    'Adam',    6042,    'Vicar (15)',    758 FROM Dual
+ UNION ALL
     SELECT 305,    'MadraghRua',    6032,    'Vicar (15)',    98 FROM
+ Dual UNION ALL
     SELECT 306,    'thezip',    6024,    'Vicar (15)',    301 FROM Du
+al UNION ALL
     SELECT 307,    'greenFox',    6005,    'Vicar (15)',    374 FROM 
+Dual UNION ALL
     SELECT 308,    'particle',    5957,    'Vicar (15)',    673 FROM 
+Dual UNION ALL
     SELECT 309,    'EdwardG',    5930,    'Vicar (15)',    285 FROM D
+ual UNION ALL
     SELECT 310,    'busunsl',    5920,    'Vicar (15)',    352 FROM D
+ual UNION ALL
     SELECT 311,    'jonnyfolk',    5903,    'Vicar (15)',    339 FROM
+ Dual UNION ALL
     SELECT 312,    'fglock',    5898,    'Vicar (15)',    658 FROM Du
+al UNION ALL
     SELECT 313,    'arhuman',    5851,    'Vicar (15)',    386 FROM D
+ual UNION ALL
     SELECT 314,    'hippo',    5848,    'Vicar (15)',    489 FROM Dua
+l UNION ALL
     SELECT 315,    'ignatz',    5821,    'Vicar (15)',    366 FROM Du
+al UNION ALL
     SELECT 316,    'Eliya',    5781,    'Vicar (15)',    725 FROM Dua
+l UNION ALL
     SELECT 317,    'didier',    5779,    'Vicar (15)',    42 FROM Dua
+l UNION ALL
     SELECT 318,    'Samy_rio',    5758,    'Vicar (15)',    174 FROM 
+Dual UNION ALL
     SELECT 319,    'rhesa',    5754,    'Vicar (15)',    488 FROM Dua
+l UNION ALL
     SELECT 320,    'chacham',    5736,    'Vicar (15)',    664 FROM D
+ual UNION ALL
     SELECT 321,    'Utilitarian',    5734,    'Vicar (15)',    470 FR
+OM Dual UNION ALL
     SELECT 322,    'ig',    5725,    'Vicar (15)',    884 FROM Dual U
+NION ALL
     SELECT 323,    'nimdokk',    5677,    'Vicar (15)',    450 FROM D
+ual UNION ALL
     SELECT 324,    'Chmrr',    5676,    'Vicar (15)',    284 FROM Dua
+l UNION ALL
     SELECT 325,    'simon.proctor',    5665,    'Vicar (15)',    359 
+FROM Dual UNION ALL
     SELECT 326,    'rir',    5649,    'Vicar (15)',    488 FROM Dual 
+UNION ALL
     SELECT 327,    'lhoward',    5644,    'Vicar (15)',    576 FROM D
+ual UNION ALL
     SELECT 328,    'sri',    5630,    'Vicar (15)',    117 FROM Dual 
+UNION ALL
     SELECT 329,    'stefp',    5618,    'Vicar (15)',    300 FROM Dua
+l UNION ALL
     SELECT 330,    'VinsWorldcom',    5589,    'Vicar (15)',    320 F
+ROM Dual UNION ALL
     SELECT 331,    'djw',    5573,    'Vicar (15)',    78 FROM Dual U
+NION ALL
     SELECT 332,    'bichonfrise74',    5537,    'Vicar (15)',    384 
+FROM Dual UNION ALL
     SELECT 333,    'thelenm',    5501,    'Vicar (15)',    333 FROM D
+ual UNION ALL
     SELECT 334,    'webfiend',    5456,    'Vicar (15)',    281 FROM 
+Dual UNION ALL
     SELECT 335,    'George_Sherston',    5455,    'Vicar (15)',    50
+3 FROM Dual UNION ALL
     SELECT 336,    'Gangabass',    5455,    'Vicar (15)',    439 FROM
+ Dual UNION ALL
     SELECT 337,    'soonix',    5446,    'Vicar (15)',    280 FROM Du
+al UNION ALL
     SELECT 338,    'benn',    5399,    'Priest (14)',    370 FROM Dua
+l UNION ALL
     SELECT 339,    'SuicideJunkie',    5394,    'Priest (14)',    683
+ FROM Dual UNION ALL
     SELECT 340,    'Plankton',    5381,    'Priest (14)',    468 FROM
+ Dual UNION ALL
     SELECT 341,    'johnnywang',    5352,    'Priest (14)',    488 FR
+OM Dual UNION ALL
     SELECT 342,    'PetaMem',    5349,    'Priest (14)',    289 FROM 
+Dual UNION ALL
     SELECT 343,    'BazB',    5349,    'Priest (14)',    240 FROM Dua
+l UNION ALL
     SELECT 344,    'ichimunki',    5336,    'Priest (14)',    557 FRO
+M Dual UNION ALL
     SELECT 345,    'zdog',    5332,    'Priest (14)',    221 FROM Dua
+l UNION ALL
     SELECT 346,    'GotToBTru',    5314,    'Priest (14)',    519 FRO
+M Dual UNION ALL
     SELECT 347,    'Punitha',    5291,    'Priest (14)',    41 FROM D
+ual UNION ALL
     SELECT 348,    'greywolf',    5274,    'Priest (14)',    83 FROM 
+Dual UNION ALL
     SELECT 349,    'duelafn',    5212,    'Priest (14)',    233 FROM 
+Dual UNION ALL
     SELECT 350,    'chas',    5207,    'Priest (14)',    218 FROM Dua
+l UNION ALL
     SELECT 351,    'etcshadow',    5140,    'Priest (14)',    475 FRO
+M Dual UNION ALL
     SELECT 352,    'mickeyn',    5129,    'Priest (14)',    71 FROM D
+ual UNION ALL
     SELECT 353,    'arashi',    5119,    'Priest (14)',    34 FROM Du
+al UNION ALL
     SELECT 354,    'I0',    5113,    'Priest (14)',    334 FROM Dual 
+UNION ALL
     SELECT 355,    'imp',    5112,    'Priest (14)',    391 FROM Dual
+ UNION ALL
     SELECT 356,    '2teez',    5066,    'Priest (14)',    611 FROM Du
+al UNION ALL
     SELECT 357,    'poj',    5064,    'Priest (14)',    599 FROM Dual
+ UNION ALL
     SELECT 358,    'kschwab',    5060,    'Priest (14)',    349 FROM 
+Dual UNION ALL
     SELECT 359,    'matija',    5054,    'Priest (14)',    511 FROM D
+ual UNION ALL
     SELECT 360,    'thor',    5044,    'Priest (14)',    798 FROM Dua
+l UNION ALL
     SELECT 361,    'g0n',    5040,    'Priest (14)',    309 FROM Dual
+ UNION ALL
     SELECT 362,    'pfaut',    5026,    'Priest (14)',    442 FROM Du
+al UNION ALL
     SELECT 363,    'ctilmes',    5022,    'Priest (14)',    207 FROM 
+Dual UNION ALL
     SELECT 364,    'kutsu',    5013,    'Priest (14)',    354 FROM Du
+al UNION ALL
     SELECT 365,    'Nkuvu',    5007,    'Priest (14)',    484 FROM Du
+al UNION ALL
     SELECT 366,    'Discipulus',    5004,    'Priest (14)',    616 FR
+OM Dual UNION ALL
     SELECT 367,    'rovf',    4988,    'Priest (14)',    927 FROM Dua
+l UNION ALL
     SELECT 368,    'bojinlund',    4986,    'Priest (14)',    29 FROM
+ Dual UNION ALL
     SELECT 369,    'dwm042',    4983,    'Priest (14)',    292 FROM D
+ual UNION ALL
     SELECT 370,    'mdillon',    4981,    'Priest (14)',    338 FROM 
+Dual UNION ALL
     SELECT 371,    'chanio',    4981,    'Priest (14)',    360 FROM D
+ual UNION ALL
     SELECT 372,    'pemungkah',    4972,    'Priest (14)',    501 FRO
+M Dual UNION ALL
     SELECT 373,    'parv',    4972,    'Priest (14)',    686 FROM Dua
+l UNION ALL
     SELECT 374,    'itub',    4969,    'Priest (14)',    425 FROM Dua
+l UNION ALL
     SELECT 375,    'emazep',    4941,    'Priest (14)',    37 FROM Du
+al UNION ALL
     SELECT 376,    'TheDamian',    4937,    'Priest (14)',    250 FRO
+M Dual UNION ALL
     SELECT 377,    'ptum',    4936,    'Priest (14)',    399 FROM Dua
+l UNION ALL
     SELECT 378,    'dreadpiratepeter',    4921,    'Priest (14)',    
+314 FROM Dual UNION ALL
     SELECT 379,    'Dog and Pony',    4899,    'Priest (14)',    370 
+FROM Dual UNION ALL
     SELECT 380,    'guha',    4894,    'Priest (14)',    163 FROM Dua
+l UNION ALL
     SELECT 381,    'Chady',    4875,    'Priest (14)',    482 FROM Du
+al UNION ALL
     SELECT 382,    'ar0n',    4869,    'Priest (14)',    323 FROM Dua
+l UNION ALL
     SELECT 383,    'Sidhekin',    4858,    'Priest (14)',    223 FROM
+ Dual UNION ALL
     SELECT 384,    'TheoPetersen',    4852,    'Priest (14)',    142 
+FROM Dual UNION ALL
     SELECT 385,    'spurperl',    4829,    'Priest (14)',    306 FROM
+ Dual UNION ALL
     SELECT 386,    'szabgab',    4826,    'Priest (14)',    341 FROM 
+Dual UNION ALL
     SELECT 387,    't0mas',    4824,    'Priest (14)',    282 FROM Du
+al UNION ALL
     SELECT 388,    'gopalr',    4819,    'Priest (14)',    154 FROM D
+ual UNION ALL
     SELECT 389,    'bulk88',    4817,    'Priest (14)',    586 FROM D
+ual UNION ALL
     SELECT 390,    'punkish',    4814,    'Priest (14)',    513 FROM 
+Dual UNION ALL
     SELECT 391,    'shenme',    4812,    'Priest (14)',    334 FROM D
+ual UNION ALL
     SELECT 392,    'rdfield',    4798,    'Priest (14)',    410 FROM 
+Dual UNION ALL
     SELECT 393,    'wind',    4793,    'Priest (14)',    620 FROM Dua
+l UNION ALL
     SELECT 394,    'djantzen',    4793,    'Priest (14)',    353 FROM
+ Dual UNION ALL
     SELECT 395,    'bronto',    4784,    'Priest (14)',    392 FROM D
+ual UNION ALL
     SELECT 396,    'pileofrogs',    4780,    'Priest (14)',    527 FR
+OM Dual UNION ALL
     SELECT 397,    'antirice',    4777,    'Priest (14)',    347 FROM
+ Dual UNION ALL
     SELECT 398,    'davidj',    4770,    'Priest (14)',    222 FROM D
+ual UNION ALL
     SELECT 399,    'broomduster',    4749,    'Priest (14)',    115 F
+ROM Dual UNION ALL
     SELECT 400,    'gmpassos',    4744,    'Priest (14)',    600 FROM
+ Dual UNION ALL
     SELECT 401,    'jacques',    4741,    'Priest (14)',    528 FROM 
+Dual UNION ALL
     SELECT 402,    'keszler',    4727,    'Priest (14)',    427 FROM 
+Dual UNION ALL
     SELECT 403,    'tomfahle',    4726,    'Priest (14)',    48 FROM 
+Dual UNION ALL
     SELECT 404,    'Steve_p',    4718,    'Priest (14)',    293 FROM 
+Dual UNION ALL
     SELECT 405,    'extremely',    4714,    'Priest (14)',    711 FRO
+M Dual UNION ALL
     SELECT 406,    'philcrow',    4713,    'Priest (14)',    377 FROM
+ Dual UNION ALL
     SELECT 407,    'flyingmoose',    4700,    'Priest (14)',    640 F
+ROM Dual UNION ALL
     SELECT 408,    'crenz',    4693,    'Priest (14)',    397 FROM Du
+al UNION ALL
     SELECT 409,    'bmann',    4690,    'Priest (14)',    214 FROM Du
+al UNION ALL
     SELECT 410,    'TedPride',    4686,    'Priest (14)',    1009 FRO
+M Dual UNION ALL
     SELECT 411,    'wil',    4656,    'Priest (14)',    119 FROM Dual
+ UNION ALL
     SELECT 412,    'ChemBoy',    4651,    'Priest (14)',    282 FROM 
+Dual UNION ALL
     SELECT 413,    'danger',    4645,    'Priest (14)',    280 FROM D
+ual UNION ALL
     SELECT 414,    'tcf22',    4643,    'Priest (14)',    310 FROM Du
+al UNION ALL
     SELECT 415,    'Tomte',    4625,    'Priest (14)',    369 FROM Du
+al UNION ALL
     SELECT 416,    'lemming',    4616,    'Priest (14)',    312 FROM 
+Dual UNION ALL
     SELECT 417,    'repellent',    4608,    'Priest (14)',    488 FRO
+M Dual UNION ALL
     SELECT 418,    'shadox',    4590,    'Priest (14)',    62 FROM Du
+al UNION ALL
     SELECT 419,    'Rhose',    4584,    'Priest (14)',    98 FROM Dua
+l UNION ALL
     SELECT 420,    'kwaping',    4580,    'Priest (14)',    452 FROM 
+Dual UNION ALL
     SELECT 421,    'hiseldl',    4578,    'Priest (14)',    199 FROM 
+Dual UNION ALL
     SELECT 422,    'Hue-Bond',    4575,    'Priest (14)',    354 FROM
+ Dual UNION ALL
     SELECT 423,    'trs80',    4570,    'Priest (14)',    294 FROM Du
+al UNION ALL
     SELECT 424,    'Paulster2',    4561,    'Priest (14)',    142 FRO
+M Dual UNION ALL
     SELECT 425,    'converter',    4560,    'Priest (14)',    269 FRO
+M Dual UNION ALL
     SELECT 426,    'fisher',    4535,    'Priest (14)',    152 FROM D
+ual UNION ALL
     SELECT 427,    'Theo',    4529,    'Priest (14)',    154 FROM Dua
+l UNION ALL
     SELECT 428,    'robartes',    4511,    'Priest (14)',    394 FROM
+ Dual UNION ALL
     SELECT 429,    'eXile',    4502,    'Priest (14)',    226 FROM Du
+al UNION ALL
     SELECT 430,    'leocharre',    4501,    'Priest (14)',    675 FRO
+M Dual UNION ALL
     SELECT 431,    'hacker',    4500,    'Priest (14)',    287 FROM D
+ual UNION ALL
     SELECT 432,    'sh1tn',    4498,    'Priest (14)',    578 FROM Du
+al UNION ALL
     SELECT 433,    'bsb',    4484,    'Priest (14)',    361 FROM Dual
+ UNION ALL
     SELECT 434,    'trammell',    4466,    'Priest (14)',    284 FROM
+ Dual UNION ALL
     SELECT 435,    'deprecated',    4449,    'Priest (14)',    232 FR
+OM Dual UNION ALL
     SELECT 436,    'svsingh',    4445,    'Priest (14)',    90 FROM D
+ual UNION ALL
     SELECT 437,    'pKai',    4431,    'Priest (14)',    232 FROM Dua
+l UNION ALL
     SELECT 438,    'biohisham',    4420,    'Priest (14)',    433 FRO
+M Dual UNION ALL
     SELECT 439,    'injunjoel',    4404,    'Priest (14)',    206 FRO
+M Dual UNION ALL
     SELECT 440,    'Eyck',    4400,    'Priest (14)',    197 FROM Dua
+l UNION ALL
     SELECT 441,    'willyyam',    4395,    'Priest (14)',    89 FROM 
+Dual UNION ALL
     SELECT 442,    'stephen',    4388,    'Priest (14)',    286 FROM 
+Dual UNION ALL
     SELECT 443,    'jeroenes',    4364,    'Priest (14)',    439 FROM
+ Dual UNION ALL
     SELECT 444,    'jynx',    4355,    'Priest (14)',    252 FROM Dua
+l UNION ALL
     SELECT 445,    'Dragonfly',    4338,    'Priest (14)',    55 FROM
+ Dual UNION ALL
     SELECT 446,    'Paladin',    4333,    'Priest (14)',    168 FROM 
+Dual UNION ALL
     SELECT 447,    'Kenosis',    4301,    'Priest (14)',    760 FROM 
+Dual UNION ALL
     SELECT 448,    'Ryszard',    4300,    'Priest (14)',    434 FROM 
+Dual UNION ALL
     SELECT 449,    'technojosh',    4294,    'Priest (14)',    108 FR
+OM Dual UNION ALL
     SELECT 450,    'jbert',    4276,    'Priest (14)',    430 FROM Du
+al UNION ALL
     SELECT 451,    'chrestomanci',    4231,    'Priest (14)',    383 
+FROM Dual UNION ALL
     SELECT 452,    'john_oshea',    4225,    'Priest (14)',    121 FR
+OM Dual UNION ALL
     SELECT 453,    'nothingmuch',    4222,    'Priest (14)',    390 F
+ROM Dual UNION ALL
     SELECT 454,    'moklevat',    4215,    'Priest (14)',    175 FROM
+ Dual UNION ALL
     SELECT 455,    'clinton',    4213,    'Priest (14)',    405 FROM 
+Dual UNION ALL
     SELECT 456,    'muba',    4201,    'Priest (14)',    441 FROM Dua
+l UNION ALL
     SELECT 457,    'fullermd',    4188,    'Priest (14)',    133 FROM
+ Dual UNION ALL
     SELECT 458,    'Util',    4169,    'Priest (14)',    287 FROM Dua
+l UNION ALL
     SELECT 459,    'neniro',    4162,    'Priest (14)',    262 FROM D
+ual UNION ALL
     SELECT 460,    'shriken',    4152,    'Priest (14)',    15 FROM D
+ual UNION ALL
     SELECT 461,    'KM',    4142,    'Priest (14)',    557 FROM Dual 
+UNION ALL
     SELECT 462,    'sth',    4133,    'Priest (14)',    80 FROM Dual 
+UNION ALL
     SELECT 463,    'monarch',    4127,    'Priest (14)',    453 FROM 
+Dual UNION ALL
     SELECT 464,    'AppleFritter',    4120,    'Priest (14)',    425 
+FROM Dual UNION ALL
     SELECT 465,    'fenLisesi',    4111,    'Priest (14)',    207 FRO
+M Dual UNION ALL
     SELECT 466,    'thunders',    4111,    'Priest (14)',    271 FROM
+ Dual UNION ALL
     SELECT 467,    'cguevara',    4082,    'Priest (14)',    1 FROM D
+ual UNION ALL
     SELECT 468,    'bikeNomad',    4073,    'Priest (14)',    507 FRO
+M Dual UNION ALL
     SELECT 469,    'McA',    4071,    'Priest (14)',    626 FROM Dual
+ UNION ALL
     SELECT 470,    'blahblahblah',    4071,    'Priest (14)',    169 
+FROM Dual UNION ALL
     SELECT 471,    'gornox_zx',    4067,    'Priest (14)',    9 FROM 
+Dual UNION ALL
     SELECT 472,    'trwww',    4065,    'Priest (14)',    186 FROM Du
+al UNION ALL
     SELECT 473,    'Mutant',    4052,    'Priest (14)',    349 FROM D
+ual UNION ALL
     SELECT 474,    'Biker',    4038,    'Priest (14)',    253 FROM Du
+al UNION ALL
     SELECT 475,    'redgreen',    4034,    'Priest (14)',    25 FROM 
+Dual UNION ALL
     SELECT 476,    'monkey_boy',    4033,    'Priest (14)',    141 FR
+OM Dual UNION ALL
     SELECT 477,    'phydeauxarff',    4033,    'Priest (14)',    201 
+FROM Dual UNION ALL
     SELECT 478,    'frankus',    4024,    'Priest (14)',    288 FROM 
+Dual UNION ALL
     SELECT 479,    'The Mad Hatter',    4009,    'Priest (14)',    38
+4 FROM Dual UNION ALL
     SELECT 480,    'crouchingpenguin',    4005,    'Priest (14)',    
+101 FROM Dual UNION ALL
     SELECT 481,    'iguanodon',    4005,    'Priest (14)',    145 FRO
+M Dual UNION ALL
     SELECT 482,    'AdamQuark',    4003,    'Priest (14)',    4 FROM 
+Dual UNION ALL
     SELECT 483,    'Thelonius',    4003,    'Priest (14)',    468 FRO
+M Dual UNION ALL
     SELECT 484,    'monkfan',    3989,    'Curate (13)',    308 FROM 
+Dual UNION ALL
     SELECT 485,    'elwarren',    3985,    'Curate (13)',    299 FROM
+ Dual UNION ALL
     SELECT 486,    'allolex',    3976,    'Curate (13)',    372 FROM 
+Dual UNION ALL
     SELECT 487,    'Elgon',    3968,    'Curate (13)',    151 FROM Du
+al UNION ALL
     SELECT 488,    'Siddartha',    3965,    'Curate (13)',    33 FROM
+ Dual UNION ALL
     SELECT 489,    'valavanp',    3965,    'Curate (13)',    68 FROM 
+Dual UNION ALL
     SELECT 490,    'MZSanford',    3953,    'Curate (13)',    386 FRO
+M Dual UNION ALL
     SELECT 491,    'Tanalis',    3953,    'Curate (13)',    254 FROM 
+Dual UNION ALL
     SELECT 492,    'rowdog',    3944,    'Curate (13)',    187 FROM D
+ual UNION ALL
     SELECT 493,    'frozenwithjoy',    3939,    'Curate (13)',    452
+ FROM Dual UNION ALL
     SELECT 494,    'pelagic',    3934,    'Curate (13)',    257 FROM 
+Dual UNION ALL
     SELECT 495,    'igelkott',    3931,    'Curate (13)',    222 FROM
+ Dual UNION ALL
     SELECT 496,    'zakzebrowski',    3923,    'Curate (13)',    300 
+FROM Dual UNION ALL
     SELECT 497,    'Jonathan',    3897,    'Curate (13)',    217 FROM
+ Dual UNION ALL
     SELECT 498,    'Rhandom',    3895,    'Curate (13)',    327 FROM 
+Dual UNION ALL
     SELECT 499,    'ChOas',    3878,    'Curate (13)',    168 FROM Du
+al UNION ALL
     SELECT 500,    'mifflin',    3877,    'Curate (13)',    244 FROM 
+Dual UNION ALL
     SELECT 501,    'rozallin',    3864,    'Curate (13)',    65 FROM 
+Dual UNION ALL
     SELECT 502,    'NodeReaper',    3844,    'Curate (13)',    57005 
+FROM Dual UNION ALL
     SELECT 503,    'sutch',    3844,    'Curate (13)',    103 FROM Du
+al UNION ALL
     SELECT 504,    'Jouke',    3840,    'Curate (13)',    279 FROM Du
+al UNION ALL
     SELECT 505,    '/dev/trash',    3828,    'Curate (13)',    26 FRO
+M Dual UNION ALL
     SELECT 506,    'Illuminatus',    3822,    'Curate (13)',    413 F
+ROM Dual UNION ALL
     SELECT 507,    'BigJoe',    3821,    'Curate (13)',    305 FROM D
+ual UNION ALL
     SELECT 508,    'tjh',    3821,    'Curate (13)',    156 FROM Dual
+ UNION ALL
     SELECT 509,    'fruiture',    3817,    'Curate (13)',    301 FROM
+ Dual UNION ALL
     SELECT 510,    'OeufMayo',    3800,    'Curate (13)',    146 FROM
+ Dual UNION ALL
     SELECT 511,    'lin0',    3799,    'Curate (13)',    149 FROM Dua
+l UNION ALL
     SELECT 512,    'geektron',    3797,    'Curate (13)',    464 FROM
+ Dual UNION ALL
     SELECT 513,    'DaWolf',    3784,    'Curate (13)',    274 FROM D
+ual UNION ALL
     SELECT 514,    'mertserger',    3780,    'Curate (13)',    80 FRO
+M Dual UNION ALL
     SELECT 515,    'kidd',    3778,    'Curate (13)',    66 FROM Dual
+ UNION ALL
     SELECT 516,    'defyance',    3775,    'Curate (13)',    167 FROM
+ Dual UNION ALL
     SELECT 517,    'ariels',    3774,    'Curate (13)',    238 FROM D
+ual UNION ALL
     SELECT 518,    'athomason',    3774,    'Curate (13)',    187 FRO
+M Dual UNION ALL
     SELECT 519,    'tsee',    3769,    'Curate (13)',    150 FROM Dua
+l UNION ALL
     SELECT 520,    'AgentM',    3767,    'Curate (13)',    542 FROM D
+ual UNION ALL
     SELECT 521,    'erroneousBollock',    3761,    'Curate (13)',    
+346 FROM Dual UNION ALL
     SELECT 522,    'Jim',    3756,    'Curate (13)',    537 FROM Dual
+ UNION ALL
     SELECT 523,    'arden',    3752,    'Curate (13)',    161 FROM Du
+al UNION ALL
     SELECT 524,    'Erez',    3743,    'Curate (13)',    177 FROM Dua
+l UNION ALL
     SELECT 525,    'haoess',    3739,    'Curate (13)',    92 FROM Du
+al UNION ALL
     SELECT 526,    'mattr',    3736,    'Curate (13)',    526 FROM Du
+al UNION ALL
     SELECT 527,    'leriksen',    3729,    'Curate (13)',    221 FROM
+ Dual UNION ALL
     SELECT 528,    'clintp',    3721,    'Curate (13)',    331 FROM D
+ual UNION ALL
     SELECT 529,    'DamnDirtyApe',    3706,    'Curate (13)',    379 
+FROM Dual UNION ALL
     SELECT 530,    'aaron_baugher',    3705,    'Curate (13)',    584
+ FROM Dual UNION ALL
     SELECT 531,    'elusion',    3703,    'Curate (13)',    209 FROM 
+Dual UNION ALL
     SELECT 532,    'mce',    3701,    'Curate (13)',    177 FROM Dual
+ UNION ALL
     SELECT 533,    'Trimbach',    3682,    'Curate (13)',    272 FROM
+ Dual UNION ALL
     SELECT 534,    'metaperl',    3679,    'Curate (13)',    593 FROM
+ Dual UNION ALL
     SELECT 535,    'dmitri',    3676,    'Curate (13)',    240 FROM D
+ual UNION ALL
     SELECT 536,    'sunadmn',    3674,    'Curate (13)',    103 FROM 
+Dual UNION ALL
     SELECT 537,    'dimar',    3673,    'Curate (13)',    261 FROM Du
+al UNION ALL
     SELECT 538,    'bluto',    3671,    'Curate (13)',    322 FROM Du
+al UNION ALL
     SELECT 539,    'jarich',    3660,    'Curate (13)',    199 FROM D
+ual UNION ALL
     SELECT 540,    'hominid',    3656,    'Curate (13)',    67 FROM D
+ual UNION ALL
     SELECT 541,    'khayos',    3654,    'Curate (13)',    0 FROM Dua
+l UNION ALL
     SELECT 542,    'Lawliet',    3653,    'Curate (13)',    411 FROM 
+Dual UNION ALL
     SELECT 543,    'markjugg',    3651,    'Curate (13)',    275 FROM
+ Dual UNION ALL
     SELECT 544,    'astaines',    3640,    'Curate (13)',    77 FROM 
+Dual UNION ALL
     SELECT 545,    'roke',    3639,    'Curate (13)',    5 FROM Dual 
+UNION ALL
     SELECT 546,    'little',    3634,    'Curate (13)',    364 FROM D
+ual UNION ALL
     SELECT 547,    'eduardo',    3632,    'Curate (13)',    159 FROM 
+Dual UNION ALL
     SELECT 548,    'LD2',    3621,    'Curate (13)',    201 FROM Dual
+ UNION ALL
     SELECT 549,    'premchai21',    3604,    'Curate (13)',    296 FR
+OM Dual UNION ALL
     SELECT 550,    'robsv',    3600,    'Curate (13)',    32 FROM Dua
+l UNION ALL
     SELECT 551,    'peppiv',    3593,    'Curate (13)',    98 FROM Du
+al UNION ALL
     SELECT 552,    '#include',    3590,    'Curate (13)',    18 FROM 
+Dual UNION ALL
     SELECT 553,    'andyford',    3586,    'Curate (13)',    286 FROM
+ Dual UNION ALL
     SELECT 554,    'newrisedesigns',    3584,    'Curate (13)',    26
+3 FROM Dual UNION ALL
     SELECT 555,    'citromatik',    3579,    'Curate (13)',    277 FR
+OM Dual UNION ALL
     SELECT 556,    'edan',    3572,    'Curate (13)',    355 FROM Dua
+l UNION ALL
     SELECT 557,    'RhetTbull',    3569,    'Curate (13)',    147 FRO
+M Dual UNION ALL
     SELECT 558,    'jptxs',    3566,    'Curate (13)',    313 FROM Du
+al UNION ALL
     SELECT 559,    'mrmick',    3559,    'Curate (13)',    195 FROM D
+ual UNION ALL
     SELECT 560,    'gam3',    3554,    'Curate (13)',    319 FROM Dua
+l UNION ALL
     SELECT 561,    'inman',    3546,    'Curate (13)',    473 FROM Du
+al UNION ALL
     SELECT 562,    'JayBonci',    3546,    'Curate (13)',    140 FROM
+ Dual UNION ALL
     SELECT 563,    'Moron',    3538,    'Curate (13)',    903 FROM Du
+al UNION ALL
     SELECT 564,    'andye',    3535,    'Curate (13)',    337 FROM Du
+al UNION ALL
     SELECT 565,    'teamster_jr',    3529,    'Curate (13)',    104 F
+ROM Dual UNION ALL
     SELECT 566,    'cchampion',    3525,    'Curate (13)',    144 FRO
+M Dual UNION ALL
     SELECT 567,    'logan',    3522,    'Curate (13)',    169 FROM Du
+al UNION ALL
     SELECT 568,    'mandog',    3522,    'Curate (13)',    167 FROM D
+ual UNION ALL
     SELECT 569,    'marinersk',    3521,    'Curate (13)',    591 FRO
+M Dual UNION ALL
     SELECT 570,    'tomhukins',    3506,    'Curate (13)',    274 FRO
+M Dual UNION ALL
     SELECT 571,    'moof1138',    3505,    'Curate (13)',    32 FROM 
+Dual UNION ALL
     SELECT 572,    'PERLscienceman',    3502,    'Curate (13)',    49
+ FROM Dual UNION ALL
     SELECT 573,    'mitd',    3495,    'Curate (13)',    165 FROM Dua
+l UNION ALL
     SELECT 574,    'neilwatson',    3494,    'Curate (13)',    471 FR
+OM Dual UNION ALL
     SELECT 575,    'cacharbe',    3493,    'Curate (13)',    240 FROM
+ Dual UNION ALL
     SELECT 576,    'graq',    3492,    'Curate (13)',    142 FROM Dua
+l UNION ALL
     SELECT 577,    'neophyte',    3489,    'Curate (13)',    150 FROM
+ Dual UNION ALL
     SELECT 578,    'jesuashok',    3485,    'Curate (13)',    542 FRO
+M Dual UNION ALL
     SELECT 579,    'waswas-fng',    3470,    'Curate (13)',    725 FR
+OM Dual UNION ALL
     SELECT 580,    'monsieur_champs',    3470,    'Curate (13)',    1
+87 FROM Dual UNION ALL
     SELECT 581,    'scottstef',    3467,    'Curate (13)',    116 FRO
+M Dual UNION ALL
     SELECT 582,    'renodino',    3454,    'Curate (13)',    263 FROM
+ Dual UNION ALL
     SELECT 583,    'reclaw',    3452,    'Curate (13)',    15 FROM Du
+al UNION ALL
     SELECT 584,    'lima1',    3450,    'Curate (13)',    242 FROM Du
+al UNION ALL
     SELECT 585,    'Hofmator',    3446,    'Curate (13)',    574 FROM
+ Dual UNION ALL
     SELECT 586,    'scain',    3430,    'Curate (13)',    216 FROM Du
+al UNION ALL
     SELECT 587,    'pajout',    3425,    'Curate (13)',    351 FROM D
+ual UNION ALL
     SELECT 588,    'sk',    3425,    'Curate (13)',    231 FROM Dual 
+UNION ALL
     SELECT 589,    'targetsmart',    3413,    'Curate (13)',    354 F
+ROM Dual UNION ALL
     SELECT 590,    'ehdonhon',    3409,    'Curate (13)',    329 FROM
+ Dual UNION ALL
     SELECT 591,    'moxliukas',    3405,    'Curate (13)',    126 FRO
+M Dual UNION ALL
     SELECT 592,    'dbwiz',    3400,    'Curate (13)',    133 FROM Du
+al UNION ALL
     SELECT 593,    'clemburg',    3399,    'Curate (13)',    352 FROM
+ Dual UNION ALL
     SELECT 594,    'epoptai',    3396,    'Curate (13)',    202 FROM 
+Dual UNION ALL
     SELECT 595,    'socketdave',    3388,    'Curate (13)',    98 FRO
+M Dual UNION ALL
     SELECT 596,    'perlfan',    3377,    'Curate (13)',    393 FROM 
+Dual UNION ALL
     SELECT 597,    'Dietz',    3370,    'Curate (13)',    65 FROM Dua
+l UNION ALL
     SELECT 598,    'Eily',    3359,    'Curate (13)',    272 FROM Dua
+l UNION ALL
     SELECT 599,    'crashtest',    3359,    'Curate (13)',    159 FRO
+M Dual UNION ALL
     SELECT 600,    'eff_i_g',    3354,    'Curate (13)',    273 FROM 
+Dual UNION ALL
     SELECT 601,    'chip',    3349,    'Curate (13)',    342 FROM Dua
+l UNION ALL
     SELECT 602,    'stefan k',    3329,    'Curate (13)',    259 FROM
+ Dual UNION ALL
     SELECT 603,    'ZZamboni',    3316,    'Curate (13)',    356 FROM
+ Dual UNION ALL
     SELECT 604,    'kyoshu',    3315,    'Curate (13)',    16 FROM Du
+al UNION ALL
     SELECT 605,    'rdw',    3307,    'Curate (13)',    24 FROM Dual 
+UNION ALL
     SELECT 606,    'jerrygarciuh',    3306,    'Curate (13)',    250 
+FROM Dual UNION ALL
     SELECT 607,    'tangent',    3305,    'Curate (13)',    330 FROM 
+Dual UNION ALL
     SELECT 608,    'aquarium',    3302,    'Curate (13)',    791 FROM
+ Dual UNION ALL
     SELECT 609,    'azatoth',    3297,    'Curate (13)',    171 FROM 
+Dual UNION ALL
     SELECT 610,    'murugu',    3293,    'Curate (13)',    150 FROM D
+ual UNION ALL
     SELECT 611,    'bwelch',    3286,    'Curate (13)',    57 FROM Du
+al UNION ALL
     SELECT 612,    'tfrayner',    3285,    'Curate (13)',    65 FROM 
+Dual UNION ALL
     SELECT 613,    'RolandGunslinger',    3281,    'Curate (13)',    
+36 FROM Dual UNION ALL
     SELECT 614,    'BioLion',    3280,    'Curate (13)',    301 FROM 
+Dual UNION ALL
     SELECT 615,    'dorward',    3279,    'Curate (13)',    268 FROM 
+Dual UNION ALL
     SELECT 616,    'screamingeagle',    3278,    'Curate (13)',    15
+4 FROM Dual UNION ALL
     SELECT 617,    'Jazz',    3274,    'Curate (13)',    77 FROM Dual
+ UNION ALL
     SELECT 618,    'maverick',    3265,    'Curate (13)',    279 FROM
+ Dual UNION ALL
     SELECT 619,    'rvosa',    3259,    'Curate (13)',    325 FROM Du
+al UNION ALL
     SELECT 620,    'arkturuz',    3242,    'Curate (13)',    178 FROM
+ Dual UNION ALL
     SELECT 621,    'Zoogie',    3232,    'Curate (13)',    44 FROM Du
+al UNION ALL
     SELECT 622,    'CharlesClarkson',    3229,    'Curate (13)',    1
+29 FROM Dual UNION ALL
     SELECT 623,    'petral',    3228,    'Curate (13)',    321 FROM D
+ual UNION ALL
     SELECT 624,    'MarkM',    3226,    'Curate (13)',    160 FROM Du
+al UNION ALL
     SELECT 625,    'olus',    3224,    'Curate (13)',    311 FROM Dua
+l UNION ALL
     SELECT 626,    'hok_si_la',    3224,    'Curate (13)',    76 FROM
+ Dual UNION ALL
     SELECT 627,    'Loops',    3219,    'Curate (13)',    352 FROM Du
+al UNION ALL
     SELECT 628,    'Maclir',    3219,    'Curate (13)',    269 FROM D
+ual UNION ALL
     SELECT 629,    'ruzam',    3214,    'Curate (13)',    311 FROM Du
+al UNION ALL
     SELECT 630,    'wog',    3214,    'Curate (13)',    251 FROM Dual
+ UNION ALL
     SELECT 631,    'gav^',    3212,    'Curate (13)',    275 FROM Dua
+l UNION ALL
     SELECT 632,    'cees',    3209,    'Curate (13)',    309 FROM Dua
+l UNION ALL
     SELECT 633,    'amarquis',    3206,    'Curate (13)',    202 FROM
+ Dual UNION ALL
     SELECT 634,    'Ponky',    3203,    'Curate (13)',    6 FROM Dual
+ UNION ALL
     SELECT 635,    'superfrink',    3200,    'Curate (13)',    235 FR
+OM Dual UNION ALL
     SELECT 636,    'steves',    3197,    'Curate (13)',    433 FROM D
+ual UNION ALL
     SELECT 637,    'tune',    3196,    'Curate (13)',    173 FROM Dua
+l UNION ALL
     SELECT 638,    'InfiniteSilence',    3196,    'Curate (13)',    4
+76 FROM Dual UNION ALL
     SELECT 639,    'wjw',    3194,    'Curate (13)',    370 FROM Dual
+ UNION ALL
     SELECT 640,    'Seumas',    3194,    'Curate (13)',    80 FROM Du
+al UNION ALL
     SELECT 641,    'rbc',    3193,    'Curate (13)',    211 FROM Dual
+ UNION ALL
     SELECT 642,    'jaredor',    3187,    'Curate (13)',    42 FROM D
+ual UNION ALL
     SELECT 643,    'Daruma',    3186,    'Curate (13)',    41 FROM Du
+al UNION ALL
     SELECT 644,    'tunaboy',    3183,    'Curate (13)',    29 FROM D
+ual UNION ALL
     SELECT 645,    'krujos',    3183,    'Curate (13)',    126 FROM D
+ual UNION ALL
     SELECT 646,    'tstock',    3175,    'Curate (13)',    135 FROM D
+ual UNION ALL
     SELECT 647,    'naChoZ',    3171,    'Curate (13)',    299 FROM D
+ual UNION ALL
     SELECT 648,    'bbfu',    3170,    'Curate (13)',    442 FROM Dua
+l UNION ALL
     SELECT 649,    'Hero Zzyzzx',    3165,    'Curate (13)',    300 F
+ROM Dual UNION ALL
     SELECT 650,    'jsprat',    3165,    'Curate (13)',    261 FROM D
+ual UNION ALL
     SELECT 651,    'punch_card_don',    3164,    'Curate (13)',    37
+3 FROM Dual UNION ALL
     SELECT 652,    'Thilosophy',    3152,    'Curate (13)',    247 FR
+OM Dual UNION ALL
     SELECT 653,    'chunlou',    3149,    'Curate (13)',    254 FROM 
+Dual UNION ALL
     SELECT 654,    'tinman',    3139,    'Curate (13)',    82 FROM Du
+al UNION ALL
     SELECT 655,    'ruoso',    3132,    'Curate (13)',    185 FROM Du
+al UNION ALL
     SELECT 656,    'swiftone',    3113,    'Curate (13)',    410 FROM
+ Dual UNION ALL
     SELECT 657,    'Jaap',    3111,    'Curate (13)',    461 FROM Dua
+l UNION ALL
     SELECT 658,    'wombat',    3105,    'Curate (13)',    48 FROM Du
+al UNION ALL
     SELECT 659,    'dasgar',    3099,    'Curate (13)',    518 FROM D
+ual UNION ALL
     SELECT 660,    'mje',    3097,    'Curate (13)',    680 FROM Dual
+ UNION ALL
     SELECT 661,    'been42',    3094,    'Curate (13)',    41 FROM Du
+al UNION ALL
     SELECT 662,    'rnahi',    3089,    'Curate (13)',    124 FROM Du
+al UNION ALL
     SELECT 663,    'creamygoodness',    3087,    'Curate (13)',    23
+4 FROM Dual UNION ALL
     SELECT 664,    'csuhockey3',    3086,    'Curate (13)',    122 FR
+OM Dual UNION ALL
     SELECT 665,    'giulienk',    3085,    'Curate (13)',    122 FROM
+ Dual UNION ALL
     SELECT 666,    'SparkeyG',    3083,    'Curate (13)',    42 FROM 
+Dual UNION ALL
     SELECT 667,    'vkon',    3077,    'Curate (13)',    382 FROM Dua
+l UNION ALL
     SELECT 668,    'naikonta',    3070,    'Curate (13)',    417 FROM
+ Dual UNION ALL
     SELECT 669,    'Rex(Wrecks)',    3069,    'Curate (13)',    238 F
+ROM Dual UNION ALL
     SELECT 670,    'juo',    3067,    'Curate (13)',    89 FROM Dual 
+UNION ALL
     SELECT 671,    'seeker',    3067,    'Curate (13)',    27 FROM Du
+al UNION ALL
     SELECT 672,    'BooK',    3063,    'Curate (13)',    118 FROM Dua
+l UNION ALL
     SELECT 673,    'phaylon',    3061,    'Curate (13)',    255 FROM 
+Dual UNION ALL
     SELECT 674,    'saberworks',    3060,    'Curate (13)',    235 FR
+OM Dual UNION ALL
     SELECT 675,    'mrpilot',    3056,    'Curate (13)',    23 FROM D
+ual UNION ALL
     SELECT 676,    'c-era',    3039,    'Curate (13)',    234 FROM Du
+al UNION ALL
     SELECT 677,    'pjf',    3035,    'Curate (13)',    149 FROM Dual
+ UNION ALL
     SELECT 678,    'lidden',    3034,    'Curate (13)',    206 FROM D
+ual UNION ALL
     SELECT 679,    'jjdeterick',    3034,    'Curate (13)',    11 FRO
+M Dual UNION ALL
     SELECT 680,    'hipowls',    3034,    'Curate (13)',    227 FROM 
+Dual UNION ALL
     SELECT 681,    'lvanhout',    3031,    'Curate (13)',    23 FROM 
+Dual UNION ALL
     SELECT 682,    'damian1301',    3021,    'Curate (13)',    232 FR
+OM Dual UNION ALL
     SELECT 683,    'Sandy',    3018,    'Curate (13)',    212 FROM Du
+al UNION ALL
     SELECT 684,    'cyocum',    3016,    'Curate (13)',    92 FROM Du
+al UNION ALL
     SELECT 685,    'Aragorn',    3005,    'Curate (13)',    234 FROM 
+Dual
),
    Step_XP_Writeups(Ranking, Name, XP, Title, Writeups, XP_Diff, Writ
+eups_Diff)
AS
    (
     SELECT
        Ranking,
        Name,
        XP,
        Title,
        Writeups,
        XP - LEAD(XP) OVER(ORDER BY Ranking),
        Writeups - LEAD(Writeups) OVER(ORDER BY Ranking)
     FROM
        Data
    ),
    Close(Ranking, XP_Diff, Writeups_Diff)
AS
    (
     SELECT
        Ranking,
        XP - LEAD(XP) OVER(ORDER BY Ranking),
        Writeups - LEAD(Writeups) OVER(ORDER BY Ranking)
     FROM
        Step_XP_Writeups
     WHERE
        XP_Diff        BETWEEN -30 AND 30
       AND    Writeups_Diff    BETWEEN -5 AND 5
    ),
    MMA
AS
    (
     SELECT
        MIN(XP_Diff)        XP_Diff_Min,
        MAX(XP_Diff)        XP_Diff_Max,
        AVG(XP_Diff)        XP_Diff_Avg,
        MIN(Writeups_Diff)    Writeups_Diff_Min,
        MAX(Writeups_Diff)    Writeups_Diff_Max,
        AVG(Writeups_Diff)    Writeups_Diff_Avg
     FROM    
        Step_XP_Writeups
    )
[download]

Now for some useless data:

SELECT
    (SELECT COUNT(COUNT(*)) FROM Data GROUP BY XP, Writeups    HAVING 
+Count(*) > 1) Both,
    (SELECT COUNT(*) FROM Close) Close,
    (SELECT COUNT(COUNT(*)) FROM Data GROUP BY XP HAVING Count(*) > 1)
+ XP,
    XP_Diff_Min,
    XP_Diff_Max,
    XP_Diff_Avg,
    (SELECT COUNT(COUNT(*)) FROM Data GROUP BY Writeups HAVING Count(*
+) > 1) Writeups,
    Writeups_Diff_Min,
    Writeups_Diff_Max,
    Writeups_Diff_Avg
FROM
    MMA;
[download]

Results in (2015/07/10, 2015/07/20, 2015/07/29, 2015/09/02, 2016/01/06, 2016/03/09, 2016/05/03, 2016/06/01, 2016/7/22):

      BOTH      CLOSE         XP XP_DIFF_MIN XP_DIFF_MAX XP_DIFF_AVG  
+ WRITEUPS WRITEUPS_DIFF_MIN WRITEUPS_DIFF_MAX WRITEUPS_DIFF_AVG
---------- ---------- ---------- ----------- ----------- ----------- -
+--------- ----------------- ----------------- -----------------
         0          7         31           0      851484  1468.48538  
+      135            -56940             56902        .545321637
         1          5         34           0      851046  1466.34161  
+      132            -56940             56902        .544525547
         1          6         30           0      850755  1466.34161  
+      132            -56940             56902        .544525547
         0          4         30           0      849885  1462.07569  
+      128            -56761             56940        .54294032
         0         10         27           0      847648  1453.62373  
+      135            -56761             56940        .781476122
         0         11         37           0      847042  1453.62952  
+      127            -56761             56940        .781476122
         0          5         30           0      845891  1451.52457  
+      135            -56761             56940        .780346821
         1          7         30           0      845449   1449.4329  
+      127            -56761             56940        .779220779
         1          8         33           0      844286  1449.44733  
+      130            -56761             56940        .779220779
[download]

To see the actual listings of those that are close:

SELECT
    Data.Ranking,
    Data.Name,
    Data.XP,
    Data.Title,
    Data.Writeups
FROM
    Data,
    Close
WHERE
    Data.Ranking BETWEEN Close.Ranking AND Close.Ranking + 1
ORDER BY
    Data.Ranking;
[download]

   RANKING NAME                         XP TITLE             WRITEUPS
---------- -------------------- ---------- --------------- ----------
        37 eyepopslikeamosquito      29895 Canon (20)            1289
        38 planetscape               29894 Canon (20)            1289
       412 ChemBoy                    4651 Priest (14)            282
       413 danger                     4645 Priest (14)            280
       426 fisher                     4535 Priest (14)            152
       427 Theo                       4529 Priest (14)            154
       510 OeufMayo                   3800 Curate (13)            146
       511 lin0                       3799 Curate (13)            149
       567 logan                      3522 Curate (13)            169
       568 mandog                     3522 Curate (13)            167
       642 jaredor                    3187 Curate (13)             42
       643 Daruma                     3186 Curate (13)             41
       664 csuhockey3                 3086 Curate (13)            122
       665 giulienk                   3085 Curate (13)            122

14 rows selected.
[download]

Obviously, you can change the definition of "close" in the CTE.

As long as the database supports analytical functions, this ought to work outside Oracle. But, you'll llikely have to remove " FROM Dual" or add a Dual CTE, like: Dual AS (SELECT Null).

Update 2014/07/20: Transposed backwards XP and Writeups! Some of the results are different.

In reply to Re: planetscape and me: 1282 nodes apiece by chacham
in thread planetscape and me: 1282 nodes apiece by eyepopslikeamosquito

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


There's more than one way to do things
	PerlMonks