Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: planetscape and me: 1282 nodes apiece

by chacham (Prior)
on Jul 10, 2015 at 15:51 UTC ( #1134189=note: print w/replies, xml ) Need Help??


in reply to planetscape and me: 1282 nodes apiece

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.

  1. Copy the table from Saints in our Book
  2. 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
  3. Replace None with 0
  4. Dress up the data in a CTE
  5. 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, 'CardinalNumber', 10070, 'Prior (17)', 30 + FROM Dual 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 )

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;

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

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;
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.

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1134189]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (9)
As of 2018-12-17 17:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many stories does it take before you've heard them all?







    Results (73 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!