WITH
Data(Ranking, Name, XP, Title, Writeups)
AS
(
SELECT 1, 'vroom', 1007449, 'Pope (28)', 607 FROM Dual UNION ALL
SELECT 2, 'BrowserUk', 155965, 'Pope (28)', 21909 FROM Dual UNION ALL
SELECT 3, 'ikegami', 126888, 'Pope (28)', 19558 FROM Dual UNION ALL
SELECT 4, 'Corion', 117369, 'Pope (28)', 9329 FROM Dual UNION ALL
SELECT 5, 'merlyn', 71106, 'Sage (25)', 6322 FROM Dual UNION ALL
SELECT 6, 'GrandFather', 70734, 'Sage (25)', 6442 FROM Dual UNION ALL
SELECT 7, 'tye', 69411, 'Cardinal (24)', 7731 FROM Dual UNION ALL
SELECT 8, 'moritz', 65717, 'Cardinal (24)', 6415 FROM Dual UNION ALL
SELECT 9, 'Ovid', 60422, 'Cardinal (24)', 2990 FROM Dual UNION ALL
SELECT 10, 'dragonchild', 58430, 'Archbishop (23)', 5986 FROM Dual UNION ALL
SELECT 11, 'chromatic', 58203, 'Archbishop (23)', 5941 FROM Dual UNION ALL
SELECT 12, 'tilly', 57169, 'Archbishop (23)', 5646 FROM Dual UNION ALL
SELECT 13, 'zentara', 56222, 'Archbishop (23)', 7239 FROM Dual UNION ALL
SELECT 14, 'davido', 55496, 'Archbishop (23)', 4697 FROM Dual UNION ALL
SELECT 15, 'Zaxo', 54784, 'Archbishop (23)', 3416 FROM 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 FROM Dual UNION ALL
SELECT 20, 'marto', 41870, 'Bishop (22)', 4449 FROM Dual UNION ALL
SELECT 21, 'toolic', 41169, 'Bishop (22)', 3464 FROM Dual UNION ALL
SELECT 22, 'Abigail-II', 40862, 'Bishop (22)', 4089 FROM Dual UNION ALL
SELECT 23, 'jeffa', 40055, 'Bishop (22)', 2752 FROM Dual 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 FROM Dual UNION ALL
SELECT 27, 'Aristotle', 35627, 'Chancellor (21)', 5335 FROM Dual UNION ALL
SELECT 28, 'davorg', 34015, 'Chancellor (21)', 2988 FROM Dual UNION ALL
SELECT 29, 'Fletch', 33797, 'Chancellor (21)', 3608 FROM 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 FROM Dual UNION ALL
SELECT 33, 'demerphq', 31508, 'Chancellor (21)', 3269 FROM Dual UNION ALL
SELECT 34, 'Your Mother', 30594, 'Chancellor (21)', 2497 FROM Dual UNION ALL
SELECT 35, 'Gavin', 30566, 'Chancellor (21)', 598 FROM Dual UNION ALL
SELECT 36, 'roboticus', 30296, 'Chancellor (21)', 2868 FROM Dual UNION ALL
SELECT 37, 'eyepopslikeamosquito', 29895, 'Canon (20)', 1289 FROM Dual UNION ALL
SELECT 38, 'planetscape', 29894, 'Canon (20)', 1289 FROM Dual UNION ALL
SELECT 39, 'Joost', 29453, 'Canon (20)', 3245 FROM Dual UNION ALL
SELECT 40, 'syphilis', 29373, 'Canon (20)', 2692 FROM Dual UNION ALL
SELECT 41, 'japhy', 29144, 'Canon (20)', 2347 FROM Dual UNION ALL
SELECT 42, 'LanX', 29120, 'Canon (20)', 4591 FROM Dual UNION ALL
SELECT 43, 'borisz', 27898, 'Canon (20)', 913 FROM Dual UNION ALL
SELECT 44, 'bart', 27165, 'Canon (20)', 2611 FROM Dual UNION ALL
SELECT 45, 'Khen1950fx', 26510, 'Canon (20)', 1899 FROM Dual UNION ALL
SELECT 46, 'Tanktalus', 26165, 'Canon (20)', 2178 FROM Dual UNION ALL
SELECT 47, 'shmem', 26153, 'Canon (20)', 2490 FROM Dual UNION ALL
SELECT 48, 'strat', 26010, 'Canon (20)', 538 FROM Dual UNION ALL
SELECT 49, 'diotalevi', 25716, 'Canon (20)', 3030 FROM 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 Dual UNION ALL
SELECT 53, 'blazar', 24988, 'Canon (20)', 2772 FROM Dual UNION ALL
SELECT 54, 'talexb', 24558, 'Canon (20)', 1833 FROM Dual UNION ALL
SELECT 55, 'jdporter', 24462, 'Canon (20)', 2961 FROM Dual UNION ALL
SELECT 56, 'mirod', 24125, 'Canon (20)', 1558 FROM Dual UNION ALL
SELECT 57, 'hsmyers', 23877, 'Canon (20)', 515 FROM Dual UNION ALL
SELECT 58, 'almut', 23869, 'Canon (20)', 2602 FROM Dual 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 FROM Dual UNION ALL
SELECT 63, 'FunkyMonk', 23048, 'Canon (20)', 1024 FROM Dual UNION ALL
SELECT 64, 'PodMaster', 21841, 'Abbot (19)', 2401 FROM Dual UNION ALL
SELECT 65, 'YuckFoo', 21789, 'Abbot (19)', 203 FROM Dual UNION ALL
SELECT 66, 'kcott', 21613, 'Abbot (19)', 2262 FROM Dual UNION ALL
SELECT 67, 'Juerd', 21554, 'Abbot (19)', 2249 FROM Dual UNION ALL
SELECT 68, 'kyle', 21535, 'Abbot (19)', 1659 FROM Dual UNION ALL
SELECT 69, 'Mr. Muskrat', 21298, 'Abbot (19)', 1538 FROM Dual UNION ALL
SELECT 70, 'gmax', 20736, 'Abbot (19)', 292 FROM Dual UNION ALL
SELECT 71, 'broquaint', 20398, 'Abbot (19)', 1326 FROM Dual UNION ALL
SELECT 72, 'AnomalousMonk', 20041, 'Abbot (19)', 2779 FROM Dual UNION ALL
SELECT 73, 'Athanasius', 20030, 'Abbot (19)', 1209 FROM Dual UNION ALL
SELECT 74, 'ambrus', 19579, 'Abbot (19)', 2738 FROM Dual UNION ALL
SELECT 75, 'wfsp', 19168, 'Abbot (19)', 904 FROM Dual UNION ALL
SELECT 76, 'brian_d_foy', 19011, 'Abbot (19)', 905 FROM Dual UNION ALL
SELECT 77, 'tobyink', 18997, 'Abbot (19)', 2554 FROM Dual UNION ALL
SELECT 78, 'runrig', 18838, 'Abbot (19)', 2597 FROM Dual UNION ALL
SELECT 79, 'Moriarty', 18643, 'Abbot (19)', 128 FROM Dual UNION ALL
SELECT 80, 'johngg', 18365, 'Abbot (19)', 1680 FROM Dual UNION ALL
SELECT 81, 'gryphon', 18239, 'Abbot (19)', 218 FROM Dual UNION ALL
SELECT 82, 'samtregar', 17928, 'Abbot (19)', 1367 FROM Dual UNION ALL
SELECT 83, 'sauoq', 17847, 'Abbot (19)', 2077 FROM Dual UNION ALL
SELECT 84, 'tirwhan', 17764, 'Abbot (19)', 793 FROM Dual UNION ALL
SELECT 85, 'hardburn', 17727, 'Abbot (19)', 2000 FROM Dual UNION ALL
SELECT 86, 'NetWallah', 17720, 'Abbot (19)', 1978 FROM Dual UNION ALL
SELECT 87, 'valentin', 17659, 'Abbot (19)', 16 FROM Dual UNION ALL
SELECT 88, 'salva', 17212, 'Abbot (19)', 2226 FROM Dual UNION ALL
SELECT 89, 'Jenda', 17005, 'Abbot (19)', 2272 FROM Dual UNION ALL
SELECT 90, 'dHarry', 16922, 'Abbot (19)', 454 FROM Dual UNION ALL
SELECT 91, 'sundialsvc4', 16684, 'Abbot (19)', 3923 FROM Dual UNION ALL
SELECT 92, 'Popcorn Dave', 16636, 'Abbot (19)', 670 FROM Dual UNION ALL
SELECT 93, 'derby', 16598, 'Abbot (19)', 1452 FROM Dual 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 Dual UNION ALL
SELECT 99, 'uksza', 16001, 'Abbot (19)', 45 FROM Dual UNION ALL
SELECT 100, 'jplindstrom', 15759, 'Monsignor (18)', 509 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 FROM Dual UNION ALL
SELECT 107, 'atcroft', 15070, 'Monsignor (18)', 630 FROM Dual UNION ALL
SELECT 108, 'scorpio17', 15053, 'Monsignor (18)', 318 FROM Dual UNION ALL
SELECT 109, 'tbone1', 15038, 'Monsignor (18)', 460 FROM 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)', 2000 FROM Dual UNION ALL
SELECT 114, 'stvn', 13707, 'Monsignor (18)', 1102 FROM Dual UNION ALL
SELECT 115, 'bassplayer', 13553, 'Monsignor (18)', 152 FROM Dual UNION ALL
SELECT 116, 'lepetitalbert', 13540, 'Monsignor (18)', 80 FROM Dual UNION ALL
SELECT 117, 'blakem', 13528, 'Monsignor (18)', 1150 FROM Dual UNION ALL
SELECT 118, 'valdez', 13484, 'Monsignor (18)', 507 FROM 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 FROM Dual UNION ALL
SELECT 123, 'mr_mischief', 12928, 'Monsignor (18)', 1282 FROM Dual UNION ALL
SELECT 124, 'holli', 12910, 'Monsignor (18)', 1510 FROM Dual UNION ALL
SELECT 125, 'gellyfish', 12807, 'Monsignor (18)', 1493 FROM Dual UNION ALL
SELECT 126, 'Masem', 12768, 'Monsignor (18)', 981 FROM Dual UNION ALL
SELECT 127, 'dvergin', 12731, 'Monsignor (18)', 311 FROM Dual UNION ALL
SELECT 128, 'liz', 12565, 'Monsignor (18)', 724 FROM Dual UNION ALL
SELECT 129, 'MidLifeXis', 12546, 'Monsignor (18)', 1480 FROM Dual UNION ALL
SELECT 130, 'jethro', 12541, 'Monsignor (18)', 1676 FROM 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 FROM Dual UNION ALL
SELECT 139, 'theorbtwo', 11814, 'Prior (17)', 1040 FROM Dual UNION ALL
SELECT 140, 'davidrw', 11652, 'Prior (17)', 1216 FROM Dual UNION ALL
SELECT 141, 'tlm', 11538, 'Prior (17)', 1145 FROM Dual UNION ALL
SELECT 142, 'FoxtrotUniform', 11475, 'Prior (17)', 611 FROM Dual UNION ALL
SELECT 143, 'friedo', 11311, 'Prior (17)', 605 FROM Dual UNION ALL
SELECT 144, 'hdb', 11214, 'Prior (17)', 1489 FROM Dual UNION ALL
SELECT 145, 'Ratazong', 11143, 'Prior (17)', 451 FROM Dual UNION ALL
SELECT 146, 'Marshall', 11087, 'Prior (17)', 2300 FROM Dual UNION ALL
SELECT 147, 'Albannach', 11002, 'Prior (17)', 450 FROM Dual UNION ALL
SELECT 148, 'vek', 10929, 'Prior (17)', 549 FROM Dual UNION ALL
SELECT 149, 'jcwren', 10878, 'Prior (17)', 575 FROM Dual 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 Dual UNION ALL
SELECT 154, 'vinoth.ree', 10569, 'Prior (17)', 530 FROM 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 Dual UNION ALL
SELECT 158, 'jdtoronto', 10335, 'Prior (17)', 900 FROM Dual UNION ALL
SELECT 159, 'crazyinsomniac', 10301, 'Prior (17)', 596 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 Dual UNION ALL
SELECT 164, 'hawtin', 10085, 'Prior (17)', 196 FROM Dual UNION ALL
SELECT 165, 'SankoR', 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 Dual UNION ALL
SELECT 171, 'BUU', 9738, 'Prior (17)', 1582 FROM Dual UNION ALL
SELECT 172, 'jZed', 9693, 'Prior (17)', 1118 FROM Dual UNION ALL
SELECT 173, 'jhourcle', 9550, 'Prior (17)', 1019 FROM Dual UNION ALL
SELECT 174, 'bradcathey', 9440, 'Prior (17)', 832 FROM 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 Dual UNION ALL
SELECT 178, 'RMGir', 9227, 'Prior (17)', 769 FROM Dual UNION ALL
SELECT 179, 'belg4mit', 9176, 'Prior (17)', 1152 FROM Dual UNION ALL
SELECT 180, 'hossman', 9156, 'Prior (17)', 736 FROM Dual UNION ALL
SELECT 181, 'vagnerr', 9093, 'Prior (17)', 86 FROM Dual UNION ALL
SELECT 182, 'LTjake', 9048, 'Prior (17)', 194 FROM Dual UNION ALL
SELECT 183, 'prasadbabu', 9040, 'Prior (17)', 296 FROM Dual UNION ALL
SELECT 184, 'Random_Walk', 8971, 'Parson (16)', 516 FROM Dual UNION ALL
SELECT 185, 'jepri', 8962, 'Parson (16)', 775 FROM Dual UNION ALL
SELECT 186, 'dave_the_m', 8945, 'Parson (16)', 846 FROM Dual UNION ALL
SELECT 187, 'chipmunk', 8901, 'Parson (16)', 932 FROM Dual UNION ALL
SELECT 188, 'cLive ;-)', 8885, 'Parson (16)', 980 FROM Dual UNION ALL
SELECT 189, 'castaway', 8669, 'Parson (16)', 829 FROM Dual UNION ALL
SELECT 190, 'Roger', 8667, 'Parson (16)', 1133 FROM Dual UNION ALL
SELECT 191, 'shotgunefx', 8657, 'Parson (16)', 1085 FROM 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 FROM Dual UNION ALL
SELECT 199, 'jonadab', 8312, 'Parson (16)', 1126 FROM Dual UNION ALL
SELECT 200, 'lachoy', 8260, 'Parson (16)', 425 FROM Dual UNION ALL
SELECT 201, 'andreychek', 8236, 'Parson (16)', 147 FROM Dual UNION ALL
SELECT 202, 'bibliophile', 8227, 'Parson (16)', 140 FROM Dual UNION ALL
SELECT 203, 'Not_a_Number', 8151, 'Parson (16)', 492 FROM Dual UNION ALL
SELECT 204, 'btrott', 8113, 'Parson (16)', 839 FROM Dual UNION ALL
SELECT 205, 'thatguy', 8068, 'Parson (16)', 69 FROM Dual UNION ALL
SELECT 206, 'DigitalKitty', 8013, 'Parson (16)', 194 FROM Dual UNION ALL
SELECT 207, 'larsen', 8006, 'Parson (16)', 285 FROM Dual UNION ALL
SELECT 208, 'chargrill', 7987, 'Parson (16)', 385 FROM Dual UNION ALL
SELECT 209, 'dorko', 7947, 'Parson (16)', 163 FROM Dual 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 Dual UNION ALL
SELECT 213, 'boo_radley', 7852, 'Parson (16)', 595 FROM 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 Dual 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 Dual UNION ALL
SELECT 221, 'petdance', 7671, 'Parson (16)', 537 FROM Dual UNION ALL
SELECT 222, 'randyk', 7641, 'Parson (16)', 212 FROM Dual UNION ALL
SELECT 223, 'gube', 7614, 'Parson (16)', 227 FROM Dual UNION ALL
SELECT 224, 'pbeckingham', 7614, 'Parson (16)', 379 FROM 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 FROM Dual UNION ALL
SELECT 229, 'Spooty', 7496, 'Parson (16)', 0 FROM Dual UNION ALL
SELECT 230, 'grantm', 7400, 'Parson (16)', 662 FROM Dual UNION ALL
SELECT 231, 'artist', 7384, 'Parson (16)', 885 FROM Dual UNION ALL
SELECT 232, 'gaal', 7364, 'Parson (16)', 796 FROM Dual UNION ALL
SELECT 233, 'Herkum', 7342, 'Parson (16)', 630 FROM Dual UNION ALL
SELECT 234, 'jasonk', 7330, 'Parson (16)', 616 FROM Dual UNION ALL
SELECT 235, 'hv', 7301, 'Parson (16)', 652 FROM Dual UNION ALL
SELECT 236, 'tinita', 7301, 'Parson (16)', 669 FROM Dual UNION ALL
SELECT 237, 'tall_man', 7227, 'Parson (16)', 454 FROM Dual UNION ALL
SELECT 238, 'Elian', 7220, 'Parson (16)', 602 FROM Dual 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 FROM Dual UNION ALL
SELECT 244, 'jfroebe', 7112, 'Parson (16)', 590 FROM Dual UNION ALL
SELECT 245, 'Kanji', 7094, 'Parson (16)', 417 FROM Dual 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 FROM 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 Dual UNION ALL
SELECT 252, 'arturo', 6944, 'Vicar (15)', 876 FROM Dual 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 Dual UNION ALL
SELECT 256, 'quester', 6867, 'Vicar (15)', 211 FROM Dual UNION ALL
SELECT 257, 'QM', 6828, 'Vicar (15)', 1010 FROM Dual UNION ALL
SELECT 258, 'simonm', 6812, 'Vicar (15)', 554 FROM Dual 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 Dual UNION ALL
SELECT 263, 'ioannis', 6752, 'Vicar (15)', 131 FROM Dual UNION ALL
SELECT 264, 'nvivek', 6706, 'Vicar (15)', 76 FROM Dual UNION ALL
SELECT 265, 'Fastolfe', 6684, 'Vicar (15)', 1236 FROM Dual UNION ALL
SELECT 266, 'virtualsue', 6620, 'Vicar (15)', 334 FROM 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 Dual UNION ALL
SELECT 270, 'zby', 6588, 'Vicar (15)', 840 FROM Dual UNION ALL
SELECT 271, 'jaldhar', 6582, 'Vicar (15)', 152 FROM Dual 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 Dual UNION ALL
SELECT 275, 'chuckbutler', 6524, 'Vicar (15)', 37 FROM 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 Dual 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 Dual UNION ALL
SELECT 287, 'kiat', 6302, 'Vicar (15)', 500 FROM Dual UNION ALL
SELECT 288, 'Marza', 6280, 'Vicar (15)', 447 FROM Dual 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 Dual UNION ALL
SELECT 292, 'spiritway', 6198, 'Vicar (15)', 586 FROM Dual UNION ALL
SELECT 293, 'educated_foo', 6186, 'Vicar (15)', 757 FROM Dual UNION ALL
SELECT 294, 'karlgoethebier', 6172, 'Vicar (15)', 914 FROM Dual UNION ALL
SELECT 295, 'idsfa', 6170, 'Vicar (15)', 313 FROM Dual UNION ALL
SELECT 296, 'mpeppler', 6164, 'Vicar (15)', 798 FROM Dual UNION ALL
SELECT 297, 'manoj_speed', 6150, 'Vicar (15)', 20 FROM 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 Dual UNION ALL
SELECT 303, 'ghenry', 6049, 'Vicar (15)', 571 FROM Dual 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 Dual 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 Dual UNION ALL
SELECT 310, 'busunsl', 5920, 'Vicar (15)', 352 FROM Dual UNION ALL
SELECT 311, 'jonnyfolk', 5903, 'Vicar (15)', 339 FROM Dual UNION ALL
SELECT 312, 'fglock', 5898, 'Vicar (15)', 658 FROM Dual UNION ALL
SELECT 313, 'arhuman', 5851, 'Vicar (15)', 386 FROM Dual UNION ALL
SELECT 314, 'hippo', 5848, 'Vicar (15)', 489 FROM Dual UNION ALL
SELECT 315, 'ignatz', 5821, 'Vicar (15)', 366 FROM Dual UNION ALL
SELECT 316, 'Eliya', 5781, 'Vicar (15)', 725 FROM Dual UNION ALL
SELECT 317, 'didier', 5779, 'Vicar (15)', 42 FROM Dual UNION ALL
SELECT 318, 'Samy_rio', 5758, 'Vicar (15)', 174 FROM Dual UNION ALL
SELECT 319, 'rhesa', 5754, 'Vicar (15)', 488 FROM Dual UNION ALL
SELECT 320, 'chacham', 5736, 'Vicar (15)', 664 FROM Dual UNION ALL
SELECT 321, 'Utilitarian', 5734, 'Vicar (15)', 470 FROM Dual UNION ALL
SELECT 322, 'ig', 5725, 'Vicar (15)', 884 FROM Dual UNION ALL
SELECT 323, 'nimdokk', 5677, 'Vicar (15)', 450 FROM Dual UNION ALL
SELECT 324, 'Chmrr', 5676, 'Vicar (15)', 284 FROM Dual 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 Dual UNION ALL
SELECT 328, 'sri', 5630, 'Vicar (15)', 117 FROM Dual UNION ALL
SELECT 329, 'stefp', 5618, 'Vicar (15)', 300 FROM Dual UNION ALL
SELECT 330, 'VinsWorldcom', 5589, 'Vicar (15)', 320 FROM Dual UNION ALL
SELECT 331, 'djw', 5573, 'Vicar (15)', 78 FROM Dual UNION ALL
SELECT 332, 'bichonfrise74', 5537, 'Vicar (15)', 384 FROM Dual UNION ALL
SELECT 333, 'thelenm', 5501, 'Vicar (15)', 333 FROM Dual UNION ALL
SELECT 334, 'webfiend', 5456, 'Vicar (15)', 281 FROM Dual UNION ALL
SELECT 335, 'George_Sherston', 5455, 'Vicar (15)', 503 FROM Dual UNION ALL
SELECT 336, 'Gangabass', 5455, 'Vicar (15)', 439 FROM Dual UNION ALL
SELECT 337, 'soonix', 5446, 'Vicar (15)', 280 FROM Dual UNION ALL
SELECT 338, 'benn', 5399, 'Priest (14)', 370 FROM Dual 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 FROM Dual UNION ALL
SELECT 342, 'PetaMem', 5349, 'Priest (14)', 289 FROM Dual UNION ALL
SELECT 343, 'BazB', 5349, 'Priest (14)', 240 FROM Dual UNION ALL
SELECT 344, 'ichimunki', 5336, 'Priest (14)', 557 FROM Dual UNION ALL
SELECT 345, 'zdog', 5332, 'Priest (14)', 221 FROM Dual UNION ALL
SELECT 346, 'GotToBTru', 5314, 'Priest (14)', 519 FROM Dual UNION ALL
SELECT 347, 'Punitha', 5291, 'Priest (14)', 41 FROM Dual 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 Dual UNION ALL
SELECT 351, 'etcshadow', 5140, 'Priest (14)', 475 FROM Dual UNION ALL
SELECT 352, 'mickeyn', 5129, 'Priest (14)', 71 FROM Dual UNION ALL
SELECT 353, 'arashi', 5119, 'Priest (14)', 34 FROM Dual 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 Dual 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 Dual UNION ALL
SELECT 360, 'thor', 5044, 'Priest (14)', 798 FROM Dual UNION ALL
SELECT 361, 'g0n', 5040, 'Priest (14)', 309 FROM Dual UNION ALL
SELECT 362, 'pfaut', 5026, 'Priest (14)', 442 FROM Dual UNION ALL
SELECT 363, 'ctilmes', 5022, 'Priest (14)', 207 FROM Dual UNION ALL
SELECT 364, 'kutsu', 5013, 'Priest (14)', 354 FROM Dual UNION ALL
SELECT 365, 'Nkuvu', 5007, 'Priest (14)', 484 FROM Dual UNION ALL
SELECT 366, 'Discipulus', 5004, 'Priest (14)', 616 FROM Dual UNION ALL
SELECT 367, 'rovf', 4988, 'Priest (14)', 927 FROM Dual UNION ALL
SELECT 368, 'bojinlund', 4986, 'Priest (14)', 29 FROM Dual UNION ALL
SELECT 369, 'dwm042', 4983, 'Priest (14)', 292 FROM Dual UNION ALL
SELECT 370, 'mdillon', 4981, 'Priest (14)', 338 FROM Dual UNION ALL
SELECT 371, 'chanio', 4981, 'Priest (14)', 360 FROM Dual UNION ALL
SELECT 372, 'pemungkah', 4972, 'Priest (14)', 501 FROM Dual UNION ALL
SELECT 373, 'parv', 4972, 'Priest (14)', 686 FROM Dual UNION ALL
SELECT 374, 'itub', 4969, 'Priest (14)', 425 FROM Dual UNION ALL
SELECT 375, 'emazep', 4941, 'Priest (14)', 37 FROM Dual UNION ALL
SELECT 376, 'TheDamian', 4937, 'Priest (14)', 250 FROM Dual UNION ALL
SELECT 377, 'ptum', 4936, 'Priest (14)', 399 FROM Dual 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 Dual UNION ALL
SELECT 381, 'Chady', 4875, 'Priest (14)', 482 FROM Dual UNION ALL
SELECT 382, 'ar0n', 4869, 'Priest (14)', 323 FROM Dual 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 Dual UNION ALL
SELECT 388, 'gopalr', 4819, 'Priest (14)', 154 FROM Dual UNION ALL
SELECT 389, 'bulk88', 4817, 'Priest (14)', 586 FROM Dual UNION ALL
SELECT 390, 'punkish', 4814, 'Priest (14)', 513 FROM Dual UNION ALL
SELECT 391, 'shenme', 4812, 'Priest (14)', 334 FROM Dual UNION ALL
SELECT 392, 'rdfield', 4798, 'Priest (14)', 410 FROM Dual UNION ALL
SELECT 393, 'wind', 4793, 'Priest (14)', 620 FROM Dual UNION ALL
SELECT 394, 'djantzen', 4793, 'Priest (14)', 353 FROM Dual UNION ALL
SELECT 395, 'bronto', 4784, 'Priest (14)', 392 FROM Dual UNION ALL
SELECT 396, 'pileofrogs', 4780, 'Priest (14)', 527 FROM Dual UNION ALL
SELECT 397, 'antirice', 4777, 'Priest (14)', 347 FROM Dual UNION ALL
SELECT 398, 'davidj', 4770, 'Priest (14)', 222 FROM Dual UNION ALL
SELECT 399, 'broomduster', 4749, 'Priest (14)', 115 FROM 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 FROM Dual UNION ALL
SELECT 406, 'philcrow', 4713, 'Priest (14)', 377 FROM Dual UNION ALL
SELECT 407, 'flyingmoose', 4700, 'Priest (14)', 640 FROM Dual UNION ALL
SELECT 408, 'crenz', 4693, 'Priest (14)', 397 FROM Dual UNION ALL
SELECT 409, 'bmann', 4690, 'Priest (14)', 214 FROM Dual UNION ALL
SELECT 410, 'TedPride', 4686, 'Priest (14)', 1009 FROM 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 Dual UNION ALL
SELECT 414, 'tcf22', 4643, 'Priest (14)', 310 FROM Dual UNION ALL
SELECT 415, 'Tomte', 4625, 'Priest (14)', 369 FROM Dual UNION ALL
SELECT 416, 'lemming', 4616, 'Priest (14)', 312 FROM Dual UNION ALL
SELECT 417, 'repellent', 4608, 'Priest (14)', 488 FROM Dual UNION ALL
SELECT 418, 'shadox', 4590, 'Priest (14)', 62 FROM Dual UNION ALL
SELECT 419, 'Rhose', 4584, 'Priest (14)', 98 FROM Dual 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 Dual UNION ALL
SELECT 424, 'Paulster2', 4561, 'Priest (14)', 142 FROM Dual UNION ALL
SELECT 425, 'converter', 4560, 'Priest (14)', 269 FROM Dual UNION ALL
SELECT 426, 'fisher', 4535, 'Priest (14)', 152 FROM Dual UNION ALL
SELECT 427, 'Theo', 4529, 'Priest (14)', 154 FROM Dual UNION ALL
SELECT 428, 'robartes', 4511, 'Priest (14)', 394 FROM Dual UNION ALL
SELECT 429, 'eXile', 4502, 'Priest (14)', 226 FROM Dual UNION ALL
SELECT 430, 'leocharre', 4501, 'Priest (14)', 675 FROM Dual UNION ALL
SELECT 431, 'hacker', 4500, 'Priest (14)', 287 FROM Dual UNION ALL
SELECT 432, 'sh1tn', 4498, 'Priest (14)', 578 FROM Dual 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 FROM Dual UNION ALL
SELECT 436, 'svsingh', 4445, 'Priest (14)', 90 FROM Dual UNION ALL
SELECT 437, 'pKai', 4431, 'Priest (14)', 232 FROM Dual UNION ALL
SELECT 438, 'biohisham', 4420, 'Priest (14)', 433 FROM Dual UNION ALL
SELECT 439, 'injunjoel', 4404, 'Priest (14)', 206 FROM Dual UNION ALL
SELECT 440, 'Eyck', 4400, 'Priest (14)', 197 FROM Dual 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 Dual 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 FROM Dual UNION ALL
SELECT 450, 'jbert', 4276, 'Priest (14)', 430 FROM Dual UNION ALL
SELECT 451, 'chrestomanci', 4231, 'Priest (14)', 383 FROM Dual UNION ALL
SELECT 452, 'john_oshea', 4225, 'Priest (14)', 121 FROM Dual UNION ALL
SELECT 453, 'nothingmuch', 4222, 'Priest (14)', 390 FROM 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 Dual UNION ALL
SELECT 457, 'fullermd', 4188, 'Priest (14)', 133 FROM Dual UNION ALL
SELECT 458, 'Util', 4169, 'Priest (14)', 287 FROM Dual UNION ALL
SELECT 459, 'neniro', 4162, 'Priest (14)', 262 FROM Dual UNION ALL
SELECT 460, 'shriken', 4152, 'Priest (14)', 15 FROM Dual 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 FROM Dual UNION ALL
SELECT 466, 'thunders', 4111, 'Priest (14)', 271 FROM Dual UNION ALL
SELECT 467, 'cguevara', 4082, 'Priest (14)', 1 FROM Dual UNION ALL
SELECT 468, 'bikeNomad', 4073, 'Priest (14)', 507 FROM 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 Dual UNION ALL
SELECT 473, 'Mutant', 4052, 'Priest (14)', 349 FROM Dual UNION ALL
SELECT 474, 'Biker', 4038, 'Priest (14)', 253 FROM Dual UNION ALL
SELECT 475, 'redgreen', 4034, 'Priest (14)', 25 FROM Dual UNION ALL
SELECT 476, 'monkey_boy', 4033, 'Priest (14)', 141 FROM 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)', 384 FROM Dual UNION ALL
SELECT 480, 'crouchingpenguin', 4005, 'Priest (14)', 101 FROM Dual UNION ALL
SELECT 481, 'iguanodon', 4005, 'Priest (14)', 145 FROM Dual UNION ALL
SELECT 482, 'AdamQuark', 4003, 'Priest (14)', 4 FROM Dual UNION ALL
SELECT 483, 'Thelonius', 4003, 'Priest (14)', 468 FROM 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 Dual 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 FROM Dual UNION ALL
SELECT 491, 'Tanalis', 3953, 'Curate (13)', 254 FROM Dual UNION ALL
SELECT 492, 'rowdog', 3944, 'Curate (13)', 187 FROM Dual 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 Dual 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 Dual UNION ALL
SELECT 504, 'Jouke', 3840, 'Curate (13)', 279 FROM Dual UNION ALL
SELECT 505, '/dev/trash', 3828, 'Curate (13)', 26 FROM Dual UNION ALL
SELECT 506, 'Illuminatus', 3822, 'Curate (13)', 413 FROM Dual UNION ALL
SELECT 507, 'BigJoe', 3821, 'Curate (13)', 305 FROM Dual 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 Dual UNION ALL
SELECT 512, 'geektron', 3797, 'Curate (13)', 464 FROM Dual UNION ALL
SELECT 513, 'DaWolf', 3784, 'Curate (13)', 274 FROM Dual UNION ALL
SELECT 514, 'mertserger', 3780, 'Curate (13)', 80 FROM 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 Dual UNION ALL
SELECT 518, 'athomason', 3774, 'Curate (13)', 187 FROM Dual UNION ALL
SELECT 519, 'tsee', 3769, 'Curate (13)', 150 FROM Dual UNION ALL
SELECT 520, 'AgentM', 3767, 'Curate (13)', 542 FROM Dual 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 Dual UNION ALL
SELECT 524, 'Erez', 3743, 'Curate (13)', 177 FROM Dual UNION ALL
SELECT 525, 'haoess', 3739, 'Curate (13)', 92 FROM Dual UNION ALL
SELECT 526, 'mattr', 3736, 'Curate (13)', 526 FROM Dual UNION ALL
SELECT 527, 'leriksen', 3729, 'Curate (13)', 221 FROM Dual UNION ALL
SELECT 528, 'clintp', 3721, 'Curate (13)', 331 FROM Dual 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 Dual UNION ALL
SELECT 536, 'sunadmn', 3674, 'Curate (13)', 103 FROM Dual UNION ALL
SELECT 537, 'dimar', 3673, 'Curate (13)', 261 FROM Dual UNION ALL
SELECT 538, 'bluto', 3671, 'Curate (13)', 322 FROM Dual UNION ALL
SELECT 539, 'jarich', 3660, 'Curate (13)', 199 FROM Dual UNION ALL
SELECT 540, 'hominid', 3656, 'Curate (13)', 67 FROM Dual UNION ALL
SELECT 541, 'khayos', 3654, 'Curate (13)', 0 FROM Dual 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 Dual 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 FROM Dual UNION ALL
SELECT 550, 'robsv', 3600, 'Curate (13)', 32 FROM Dual UNION ALL
SELECT 551, 'peppiv', 3593, 'Curate (13)', 98 FROM Dual 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)', 263 FROM Dual UNION ALL
SELECT 555, 'citromatik', 3579, 'Curate (13)', 277 FROM Dual UNION ALL
SELECT 556, 'edan', 3572, 'Curate (13)', 355 FROM Dual UNION ALL
SELECT 557, 'RhetTbull', 3569, 'Curate (13)', 147 FROM Dual UNION ALL
SELECT 558, 'jptxs', 3566, 'Curate (13)', 313 FROM Dual UNION ALL
SELECT 559, 'mrmick', 3559, 'Curate (13)', 195 FROM Dual UNION ALL
SELECT 560, 'gam3', 3554, 'Curate (13)', 319 FROM Dual UNION ALL
SELECT 561, 'inman', 3546, 'Curate (13)', 473 FROM Dual UNION ALL
SELECT 562, 'JayBonci', 3546, 'Curate (13)', 140 FROM Dual UNION ALL
SELECT 563, 'Moron', 3538, 'Curate (13)', 903 FROM Dual UNION ALL
SELECT 564, 'andye', 3535, 'Curate (13)', 337 FROM Dual UNION ALL
SELECT 565, 'teamster_jr', 3529, 'Curate (13)', 104 FROM Dual UNION ALL
SELECT 566, 'cchampion', 3525, 'Curate (13)', 144 FROM Dual UNION ALL
SELECT 567, 'logan', 3522, 'Curate (13)', 169 FROM Dual UNION ALL
SELECT 568, 'mandog', 3522, 'Curate (13)', 167 FROM Dual UNION ALL
SELECT 569, 'marinersk', 3521, 'Curate (13)', 591 FROM Dual UNION ALL
SELECT 570, 'tomhukins', 3506, 'Curate (13)', 274 FROM 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 Dual UNION ALL
SELECT 574, 'neilwatson', 3494, 'Curate (13)', 471 FROM Dual UNION ALL
SELECT 575, 'cacharbe', 3493, 'Curate (13)', 240 FROM Dual UNION ALL
SELECT 576, 'graq', 3492, 'Curate (13)', 142 FROM Dual UNION ALL
SELECT 577, 'neophyte', 3489, 'Curate (13)', 150 FROM Dual UNION ALL
SELECT 578, 'jesuashok', 3485, 'Curate (13)', 542 FROM Dual UNION ALL
SELECT 579, 'waswas-fng', 3470, 'Curate (13)', 725 FROM Dual UNION ALL
SELECT 580, 'monsieur_champs', 3470, 'Curate (13)', 187 FROM Dual UNION ALL
SELECT 581, 'scottstef', 3467, 'Curate (13)', 116 FROM Dual UNION ALL
SELECT 582, 'renodino', 3454, 'Curate (13)', 263 FROM Dual UNION ALL
SELECT 583, 'reclaw', 3452, 'Curate (13)', 15 FROM Dual UNION ALL
SELECT 584, 'lima1', 3450, 'Curate (13)', 242 FROM Dual UNION ALL
SELECT 585, 'Hofmator', 3446, 'Curate (13)', 574 FROM Dual UNION ALL
SELECT 586, 'scain', 3430, 'Curate (13)', 216 FROM Dual UNION ALL
SELECT 587, 'pajout', 3425, 'Curate (13)', 351 FROM Dual UNION ALL
SELECT 588, 'sk', 3425, 'Curate (13)', 231 FROM Dual UNION ALL
SELECT 589, 'targetsmart', 3413, 'Curate (13)', 354 FROM Dual UNION ALL
SELECT 590, 'ehdonhon', 3409, 'Curate (13)', 329 FROM Dual UNION ALL
SELECT 591, 'moxliukas', 3405, 'Curate (13)', 126 FROM Dual UNION ALL
SELECT 592, 'dbwiz', 3400, 'Curate (13)', 133 FROM Dual 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 FROM Dual UNION ALL
SELECT 596, 'perlfan', 3377, 'Curate (13)', 393 FROM Dual UNION ALL
SELECT 597, 'Dietz', 3370, 'Curate (13)', 65 FROM Dual UNION ALL
SELECT 598, 'Eily', 3359, 'Curate (13)', 272 FROM Dual UNION ALL
SELECT 599, 'crashtest', 3359, 'Curate (13)', 159 FROM Dual UNION ALL
SELECT 600, 'eff_i_g', 3354, 'Curate (13)', 273 FROM Dual UNION ALL
SELECT 601, 'chip', 3349, 'Curate (13)', 342 FROM Dual 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 Dual 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 Dual UNION ALL
SELECT 611, 'bwelch', 3286, 'Curate (13)', 57 FROM Dual 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)', 154 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 Dual UNION ALL
SELECT 620, 'arkturuz', 3242, 'Curate (13)', 178 FROM Dual UNION ALL
SELECT 621, 'Zoogie', 3232, 'Curate (13)', 44 FROM Dual UNION ALL
SELECT 622, 'CharlesClarkson', 3229, 'Curate (13)', 129 FROM Dual UNION ALL
SELECT 623, 'petral', 3228, 'Curate (13)', 321 FROM Dual UNION ALL
SELECT 624, 'MarkM', 3226, 'Curate (13)', 160 FROM Dual UNION ALL
SELECT 625, 'olus', 3224, 'Curate (13)', 311 FROM Dual UNION ALL
SELECT 626, 'hok_si_la', 3224, 'Curate (13)', 76 FROM Dual UNION ALL
SELECT 627, 'Loops', 3219, 'Curate (13)', 352 FROM Dual UNION ALL
SELECT 628, 'Maclir', 3219, 'Curate (13)', 269 FROM Dual UNION ALL
SELECT 629, 'ruzam', 3214, 'Curate (13)', 311 FROM Dual UNION ALL
SELECT 630, 'wog', 3214, 'Curate (13)', 251 FROM Dual UNION ALL
SELECT 631, 'gav^', 3212, 'Curate (13)', 275 FROM Dual UNION ALL
SELECT 632, 'cees', 3209, 'Curate (13)', 309 FROM Dual 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 FROM Dual UNION ALL
SELECT 636, 'steves', 3197, 'Curate (13)', 433 FROM Dual UNION ALL
SELECT 637, 'tune', 3196, 'Curate (13)', 173 FROM Dual UNION ALL
SELECT 638, 'InfiniteSilence', 3196, 'Curate (13)', 476 FROM Dual UNION ALL
SELECT 639, 'wjw', 3194, 'Curate (13)', 370 FROM Dual UNION ALL
SELECT 640, 'Seumas', 3194, 'Curate (13)', 80 FROM Dual UNION ALL
SELECT 641, 'rbc', 3193, 'Curate (13)', 211 FROM Dual UNION ALL
SELECT 642, 'jaredor', 3187, 'Curate (13)', 42 FROM Dual UNION ALL
SELECT 643, 'Daruma', 3186, 'Curate (13)', 41 FROM Dual UNION ALL
SELECT 644, 'tunaboy', 3183, 'Curate (13)', 29 FROM Dual UNION ALL
SELECT 645, 'krujos', 3183, 'Curate (13)', 126 FROM Dual UNION ALL
SELECT 646, 'tstock', 3175, 'Curate (13)', 135 FROM Dual UNION ALL
SELECT 647, 'naChoZ', 3171, 'Curate (13)', 299 FROM Dual UNION ALL
SELECT 648, 'bbfu', 3170, 'Curate (13)', 442 FROM Dual UNION ALL
SELECT 649, 'Hero Zzyzzx', 3165, 'Curate (13)', 300 FROM Dual UNION ALL
SELECT 650, 'jsprat', 3165, 'Curate (13)', 261 FROM Dual UNION ALL
SELECT 651, 'punch_card_don', 3164, 'Curate (13)', 373 FROM Dual UNION ALL
SELECT 652, 'Thilosophy', 3152, 'Curate (13)', 247 FROM Dual UNION ALL
SELECT 653, 'chunlou', 3149, 'Curate (13)', 254 FROM Dual UNION ALL
SELECT 654, 'tinman', 3139, 'Curate (13)', 82 FROM Dual UNION ALL
SELECT 655, 'ruoso', 3132, 'Curate (13)', 185 FROM Dual UNION ALL
SELECT 656, 'swiftone', 3113, 'Curate (13)', 410 FROM Dual UNION ALL
SELECT 657, 'Jaap', 3111, 'Curate (13)', 461 FROM Dual UNION ALL
SELECT 658, 'wombat', 3105, 'Curate (13)', 48 FROM Dual UNION ALL
SELECT 659, 'dasgar', 3099, 'Curate (13)', 518 FROM Dual UNION ALL
SELECT 660, 'mje', 3097, 'Curate (13)', 680 FROM Dual UNION ALL
SELECT 661, 'been42', 3094, 'Curate (13)', 41 FROM Dual UNION ALL
SELECT 662, 'rnahi', 3089, 'Curate (13)', 124 FROM Dual UNION ALL
SELECT 663, 'creamygoodness', 3087, 'Curate (13)', 234 FROM Dual UNION ALL
SELECT 664, 'csuhockey3', 3086, 'Curate (13)', 122 FROM 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 Dual UNION ALL
SELECT 668, 'naikonta', 3070, 'Curate (13)', 417 FROM Dual UNION ALL
SELECT 669, 'Rex(Wrecks)', 3069, 'Curate (13)', 238 FROM Dual UNION ALL
SELECT 670, 'juo', 3067, 'Curate (13)', 89 FROM Dual UNION ALL
SELECT 671, 'seeker', 3067, 'Curate (13)', 27 FROM Dual UNION ALL
SELECT 672, 'BooK', 3063, 'Curate (13)', 118 FROM Dual UNION ALL
SELECT 673, 'phaylon', 3061, 'Curate (13)', 255 FROM Dual UNION ALL
SELECT 674, 'saberworks', 3060, 'Curate (13)', 235 FROM Dual UNION ALL
SELECT 675, 'mrpilot', 3056, 'Curate (13)', 23 FROM Dual UNION ALL
SELECT 676, 'c-era', 3039, 'Curate (13)', 234 FROM Dual UNION ALL
SELECT 677, 'pjf', 3035, 'Curate (13)', 149 FROM Dual UNION ALL
SELECT 678, 'lidden', 3034, 'Curate (13)', 206 FROM Dual UNION ALL
SELECT 679, 'jjdeterick', 3034, 'Curate (13)', 11 FROM 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 FROM Dual UNION ALL
SELECT 683, 'Sandy', 3018, 'Curate (13)', 212 FROM Dual UNION ALL
SELECT 684, 'cyocum', 3016, 'Curate (13)', 92 FROM Dual UNION ALL
SELECT 685, 'Aragorn', 3005, 'Curate (13)', 234 FROM Dual
),
Step_XP_Writeups(Ranking, Name, XP, Title, Writeups, XP_Diff, Writeups_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
)
####
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;
####
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
####
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.