Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^2: poll ideas quest 2015 (xp/writeups ratio)

by chacham (Prior)
on Sep 02, 2015 at 12:54 UTC ( #1140816=note: print w/replies, xml ) Need Help??


in reply to Re: poll ideas quest 2015 (xp/writeups ratio)
in thread poll ideas quest 2015

Dontja hate it when people ask what you can answer in code? :)

WITH Data(Ranking, Name, XP, Writeups) AS ( SELECT 1, 'vroom', 1007451, 607 FROM Dual UNION ALL SELECT 2, 'BrowserUk', 157567, 22120 FROM Dual UNION + ALL SELECT 3, 'ikegami', 127207, 19609 FROM Dual UNION A +LL SELECT 4, 'Corion', 118780, 9450 FROM Dual UNION ALL SELECT 5, 'GrandFather', 71452, 6493 FROM Dual UNION + ALL SELECT 6, 'merlyn', 71109, 6322 FROM Dual UNION ALL SELECT 7, 'tye', 70080, 7805 FROM Dual UNION ALL SELECT 8, 'moritz', 65741, 6416 FROM Dual UNION ALL SELECT 9, 'Ovid', 60429, 2990 FROM Dual UNION ALL SELECT 10, 'dragonchild', 58437, 5988 FROM Dual UNIO +N ALL SELECT 11, 'chromatic', 58205, 5941 FROM Dual UNION +ALL SELECT 12, 'tilly', 57176, 5646 FROM Dual UNION ALL SELECT 13, 'zentara', 56223, 7239 FROM Dual UNION AL +L SELECT 14, 'davido', 55750, 4711 FROM Dual UNION ALL SELECT 15, 'Zaxo', 54787, 3416 FROM Dual UNION ALL SELECT 16, 'ww', 46264, 3553 FROM Dual UNION ALL SELECT 17, 'Old_Gray_Bear', 45701, 587 FROM Dual UNI +ON ALL SELECT 18, 'grinder', 43663, 1570 FROM Dual UNION AL +L SELECT 19, 'CountZero', 43186, 4299 FROM Dual UNION +ALL SELECT 20, 'marto', 42225, 4473 FROM Dual UNION ALL SELECT 21, 'toolic', 41739, 3501 FROM Dual UNION ALL SELECT 22, 'Abigail-II', 40869, 4089 FROM Dual UNION + ALL SELECT 23, 'jeffa', 40311, 2775 FROM Dual UNION ALL SELECT 24, 'dws', 38846, 2536 FROM Dual UNION ALL SELECT 25, 'Limbic~Region', 38019, 2960 FROM Dual UN +ION ALL SELECT 26, 'perrin', 36242, 4171 FROM Dual UNION ALL SELECT 27, 'Aristotle', 35627, 5335 FROM Dual UNION +ALL SELECT 28, 'davorg', 34015, 2988 FROM Dual UNION ALL SELECT 29, 'Fletch', 33802, 3608 FROM Dual UNION ALL SELECT 30, 'tachyon', 32350, 3268 FROM Dual UNION AL +L SELECT 31, 'adrianh', 32159, 2205 FROM Dual UNION AL +L SELECT 32, 'graff', 31685, 3883 FROM Dual UNION ALL SELECT 33, 'demerphq', 31508, 3269 FROM Dual UNION A +LL SELECT 34, 'Your Mother', 31406, 2583 FROM Dual UNIO +N ALL SELECT 35, 'Gavin', 31069, 598 FROM Dual UNION ALL SELECT 36, 'roboticus', 30746, 2902 FROM Dual UNION +ALL SELECT 37, 'eyepopslikeamosquito', 30303, 1303 FROM +Dual UNION ALL SELECT 38, 'planetscape', 30270, 1295 FROM Dual UNIO +N ALL SELECT 39, 'syphilis', 29906, 2730 FROM Dual UNION A +LL SELECT 40, 'LanX', 29569, 4647 FROM Dual UNION ALL SELECT 41, 'Joost', 29453, 3245 FROM Dual UNION ALL SELECT 42, 'japhy', 29144, 2347 FROM Dual UNION ALL SELECT 43, 'borisz', 27899, 913 FROM Dual UNION ALL SELECT 44, 'bart', 27165, 2611 FROM Dual UNION ALL SELECT 45, 'shmem', 26803, 2549 FROM Dual UNION ALL SELECT 46, 'Khen1950fx', 26518, 1899 FROM Dual UNION + ALL SELECT 47, 'choroba', 26238, 3451 FROM Dual UNION AL +L SELECT 48, 'Tanktalus', 26170, 2178 FROM Dual UNION +ALL SELECT 49, 'strat', 26010, 538 FROM Dual UNION ALL SELECT 50, 'diotalevi', 25717, 3030 FROM Dual UNION +ALL SELECT 51, 'TStanley', 25531, 472 FROM Dual UNION AL +L SELECT 52, 'ysth', 25233, 3439 FROM Dual UNION ALL SELECT 53, 'blazar', 24988, 2772 FROM Dual UNION ALL SELECT 54, 'talexb', 24662, 1842 FROM Dual UNION ALL SELECT 55, 'jdporter', 24604, 2973 FROM Dual UNION A +LL SELECT 56, 'mirod', 24129, 1558 FROM Dual UNION ALL SELECT 57, 'hsmyers', 23877, 515 FROM Dual UNION ALL SELECT 58, 'almut', 23869, 2602 FROM Dual UNION ALL SELECT 59, 'JSchmitz', 23754, 186 FROM Dual UNION AL +L SELECT 60, 'JavaFan', 23709, 4500 FROM Dual UNION AL +L SELECT 61, 'Perlbotics', 23614, 382 FROM Dual UNION +ALL SELECT 62, 'FunkyMonk', 23318, 1024 FROM Dual UNION +ALL SELECT 63, 'pg', 23122, 1848 FROM Dual UNION ALL SELECT 64, 'kcott', 22277, 2298 FROM Dual UNION ALL SELECT 65, 'PodMaster', 21842, 2401 FROM Dual UNION +ALL SELECT 66, 'YuckFoo', 21789, 203 FROM Dual UNION ALL SELECT 67, 'Athanasius', 21578, 1292 FROM Dual UNION + ALL SELECT 68, 'Juerd', 21555, 2249 FROM Dual UNION ALL SELECT 69, 'kyle', 21536, 1659 FROM Dual UNION ALL SELECT 70, 'Mr. Muskrat', 21300, 1538 FROM Dual UNIO +N ALL SELECT 71, 'AnomalousMonk', 20908, 2868 FROM Dual UN +ION ALL SELECT 72, 'gmax', 20736, 292 FROM Dual UNION ALL SELECT 73, 'broquaint', 20398, 1326 FROM Dual UNION +ALL SELECT 74, 'ambrus', 19632, 2745 FROM Dual UNION ALL SELECT 75, 'wfsp', 19168, 904 FROM Dual UNION ALL SELECT 76, 'brian_d_foy', 19015, 905 FROM Dual UNION + ALL SELECT 77, 'tobyink', 19004, 2554 FROM Dual UNION AL +L SELECT 78, 'runrig', 18923, 2607 FROM Dual UNION ALL SELECT 79, 'Moriarty', 18645, 128 FROM Dual UNION AL +L SELECT 80, 'johngg', 18509, 1687 FROM Dual UNION ALL SELECT 81, 'gryphon', 18239, 218 FROM Dual UNION ALL SELECT 82, 'samtregar', 17929, 1367 FROM Dual UNION +ALL SELECT 83, 'NetWallah', 17880, 1988 FROM Dual UNION +ALL SELECT 84, 'sauoq', 17847, 2077 FROM Dual UNION ALL SELECT 85, 'tirwhan', 17764, 793 FROM Dual UNION ALL SELECT 86, 'hardburn', 17743, 2001 FROM Dual UNION A +LL SELECT 87, 'valentin', 17660, 16 FROM Dual UNION ALL SELECT 88, 'salva', 17365, 2246 FROM Dual UNION ALL SELECT 89, 'Jenda', 17055, 2278 FROM Dual UNION ALL SELECT 90, 'dHarry', 16922, 454 FROM Dual UNION ALL SELECT 91, 'roho', 16831, 109 FROM Dual UNION ALL SELECT 92, 'Happy-the-monk', 16804, 691 FROM Dual UN +ION ALL SELECT 93, 'sundialsvc4', 16681, 4040 FROM Dual UNIO +N ALL SELECT 94, 'derby', 16651, 1455 FROM Dual UNION ALL SELECT 95, 'Popcorn Dave', 16637, 670 FROM Dual UNIO +N ALL SELECT 96, 'kennethk', 16497, 1797 FROM Dual UNION A +LL SELECT 97, 'uksza', 16378, 45 FROM Dual UNION ALL SELECT 98, 'rob_au', 16274, 806 FROM Dual UNION ALL SELECT 99, 'McDarren', 16273, 794 FROM Dual UNION AL +L SELECT 100, 'jplindstrom', 15761, 509 FROM Dual UNIO +N ALL SELECT 101, 'jmcnamara', 15734, 985 FROM Dual UNION +ALL SELECT 102, 'apl', 15718, 929 FROM Dual UNION ALL SELECT 103, 'liverpole', 15646, 910 FROM Dual UNION +ALL SELECT 104, 'zwon', 15460, 791 FROM Dual UNION ALL SELECT 105, 'scorpio17', 15382, 318 FROM Dual UNION +ALL SELECT 106, 'xdg', 15353, 1214 FROM Dual UNION ALL SELECT 107, 'atcroft', 15186, 634 FROM Dual UNION AL +L SELECT 108, 'footpad', 15156, 527 FROM Dual UNION AL +L SELECT 109, 'tbone1', 15044, 460 FROM Dual UNION ALL SELECT 110, 'Tux', 14919, 1456 FROM Dual UNION ALL SELECT 111, 'rinceWind', 14642, 807 FROM Dual UNION +ALL SELECT 112, 'John M. Dlugosz', 14525, 2565 FROM Dual + UNION ALL SELECT 113, 'Roy Johnson', 14446, 2000 FROM Dual UNI +ON ALL SELECT 114, 'stvn', 13707, 1102 FROM Dual UNION ALL SELECT 115, 'lepetitalbert', 13635, 80 FROM Dual UNI +ON ALL SELECT 116, 'bassplayer', 13557, 152 FROM Dual UNION + ALL SELECT 117, 'blakem', 13528, 1150 FROM Dual UNION AL +L SELECT 118, 'valdez', 13486, 507 FROM Dual UNION ALL SELECT 119, 'grep', 13469, 554 FROM Dual UNION ALL SELECT 120, 'VSarkiss', 13461, 1015 FROM Dual UNION +ALL SELECT 121, 'mojotoad', 13212, 491 FROM Dual UNION A +LL SELECT 122, 'Laurent_R', 13122, 1934 FROM Dual UNION + ALL SELECT 123, 'mr_mischief', 13045, 1300 FROM Dual UNI +ON ALL SELECT 124, 'kvale', 12987, 680 FROM Dual UNION ALL SELECT 125, 'holli', 12910, 1510 FROM Dual UNION ALL SELECT 126, 'gellyfish', 12808, 1493 FROM Dual UNION + ALL SELECT 127, 'Masem', 12769, 981 FROM Dual UNION ALL SELECT 128, 'MidLifeXis', 12737, 1507 FROM Dual UNIO +N ALL SELECT 129, 'dvergin', 12731, 311 FROM Dual UNION AL +L SELECT 130, 'liz', 12571, 724 FROM Dual UNION ALL SELECT 131, 'jethro', 12543, 1676 FROM Dual UNION AL +L SELECT 132, 'dree', 12528, 79 FROM Dual UNION ALL SELECT 133, 'blokhead', 12474, 654 FROM Dual UNION A +LL SELECT 134, 'bobf', 12400, 474 FROM Dual UNION ALL SELECT 135, 'gawatkins', 12393, 51 FROM Dual UNION A +LL SELECT 136, 'jettero', 12333, 1032 FROM Dual UNION A +LL SELECT 137, 'jwkrahn', 12224, 1557 FROM Dual UNION A +LL SELECT 138, 'blue_cowdawg', 12218, 1347 FROM Dual UN +ION ALL SELECT 139, 'theorbtwo', 11818, 1040 FROM Dual UNION + ALL SELECT 140, 'davidrw', 11652, 1216 FROM Dual UNION A +LL SELECT 141, 'tlm', 11541, 1145 FROM Dual UNION ALL SELECT 142, 'FoxtrotUniform', 11475, 611 FROM Dual U +NION ALL SELECT 143, 'afoken', 11359, 1164 FROM Dual UNION AL +L SELECT 144, 'Ratazong', 11320, 455 FROM Dual UNION A +LL SELECT 145, 'friedo', 11311, 605 FROM Dual UNION ALL SELECT 146, 'hdb', 11285, 1493 FROM Dual UNION ALL SELECT 147, 'vinoth.ree', 11164, 555 FROM Dual UNION + ALL SELECT 148, 'Marshall', 11122, 2305 FROM Dual UNION +ALL SELECT 149, 'Albannach', 11024, 450 FROM Dual UNION +ALL SELECT 150, 'vek', 10930, 549 FROM Dual UNION ALL SELECT 151, 'jcwren', 10878, 575 FROM Dual UNION ALL SELECT 152, 'cdarke', 10859, 1504 FROM Dual UNION AL +L SELECT 153, 'halley', 10807, 1058 FROM Dual UNION AL +L SELECT 154, 'Erudil', 10587, 13 FROM Dual UNION ALL SELECT 155, 'barrd', 10558, 154 FROM Dual UNION ALL SELECT 156, 'hotshot', 10486, 280 FROM Dual UNION AL +L SELECT 157, 'ajt', 10478, 198 FROM Dual UNION ALL SELECT 158, 'Argel', 10365, 933 FROM Dual UNION ALL SELECT 159, 'jdtoronto', 10336, 900 FROM Dual UNION +ALL SELECT 160, 'crazyinsomniac', 10301, 596 FROM Dual U +NION ALL SELECT 161, 'flexvault', 10257, 559 FROM Dual UNION +ALL SELECT 162, 'ELISHEVA', 10198, 926 FROM Dual UNION A +LL SELECT 163, 'thraxil', 10195, 237 FROM Dual UNION AL +L SELECT 164, 'DrHyde', 10194, 1480 FROM Dual UNION AL +L SELECT 165, 'hawtin', 10085, 196 FROM Dual UNION ALL SELECT 166, 'SankoR', 10078, 30 FROM Dual UNION ALL SELECT 167, 'ybiC', 9912, 493 FROM Dual UNION ALL SELECT 168, 'revdiablo', 9854, 955 FROM Dual UNION A +LL SELECT 169, 'Sinistral', 9840, 147 FROM Dual UNION A +LL SELECT 170, 'wazoox', 9824, 764 FROM Dual UNION ALL SELECT 171, 'BUU', 9741, 1582 FROM Dual UNION ALL SELECT 172, 'jZed', 9693, 1118 FROM Dual UNION ALL SELECT 173, 'jhourcle', 9550, 1019 FROM Dual UNION A +LL SELECT 174, 'bradcathey', 9441, 832 FROM Dual UNION +ALL SELECT 175, 'sgifford', 9376, 1184 FROM Dual UNION A +LL SELECT 176, 'Cody Pendant', 9364, 1018 FROM Dual UNI +ON ALL SELECT 177, 'tadman', 9335, 935 FROM Dual UNION ALL SELECT 178, 'RMGir', 9254, 769 FROM Dual UNION ALL SELECT 179, 'belg4mit', 9177, 1152 FROM Dual UNION A +LL SELECT 180, 'hossman', 9169, 736 FROM Dual UNION ALL SELECT 181, 'dave_the_m', 9150, 858 FROM Dual UNION +ALL SELECT 182, 'vagnerr', 9093, 86 FROM Dual UNION ALL SELECT 183, 'LTjake', 9048, 194 FROM Dual UNION ALL SELECT 184, 'prasadbabu', 9040, 296 FROM Dual UNION +ALL SELECT 185, 'Random_Walk', 9005, 517 FROM Dual UNION + ALL SELECT 186, 'jepri', 8963, 775 FROM Dual UNION ALL SELECT 187, 'cLive ;-)', 8903, 983 FROM Dual UNION A +LL SELECT 188, 'chipmunk', 8901, 932 FROM Dual UNION AL +L SELECT 189, 'dsheroh', 8718, 859 FROM Dual UNION ALL SELECT 190, 'castaway', 8669, 829 FROM Dual UNION AL +L SELECT 191, 'Roger', 8667, 1133 FROM Dual UNION ALL SELECT 192, 'shotgunefx', 8657, 1085 FROM Dual UNION + ALL SELECT 193, 'coreolyn', 8640, 428 FROM Dual UNION AL +L SELECT 194, 'ChuckularOne', 8625, 198 FROM Dual UNIO +N ALL SELECT 195, 'TimToady', 8579, 479 FROM Dual UNION AL +L SELECT 196, 'thinker', 8556, 113 FROM Dual UNION ALL SELECT 197, 'turnstep', 8359, 774 FROM Dual UNION AL +L SELECT 198, 'swampyankee', 8339, 922 FROM Dual UNION + ALL SELECT 199, 'jonadab', 8338, 1126 FROM Dual UNION AL +L SELECT 200, 'bibliophile', 8276, 140 FROM Dual UNION + ALL SELECT 201, 'lachoy', 8260, 425 FROM Dual UNION ALL SELECT 202, 'Not_a_Number', 8242, 499 FROM Dual UNIO +N ALL SELECT 203, 'andreychek', 8236, 147 FROM Dual UNION +ALL SELECT 204, 'btrott', 8113, 839 FROM Dual UNION ALL SELECT 205, 'thatguy', 8068, 69 FROM Dual UNION ALL SELECT 206, 'DigitalKitty', 8013, 194 FROM Dual UNIO +N ALL SELECT 207, 'larsen', 8006, 285 FROM Dual UNION ALL SELECT 208, 'dorko', 7996, 163 FROM Dual UNION ALL SELECT 209, 'chargrill', 7987, 385 FROM Dual UNION A +LL SELECT 210, 'Generoso', 7957, 85 FROM Dual UNION ALL SELECT 211, 'Arunbear', 7939, 734 FROM Dual UNION AL +L SELECT 212, 'IlyaM', 7857, 505 FROM Dual UNION ALL SELECT 213, 'boo_radley', 7852, 595 FROM Dual UNION +ALL SELECT 214, 'cog', 7821, 551 FROM Dual UNION ALL SELECT 215, 'skx', 7808, 285 FROM Dual UNION ALL SELECT 216, 'Enlil', 7792, 423 FROM Dual UNION ALL SELECT 217, 'eric256', 7782, 1075 FROM Dual UNION AL +L SELECT 218, 'redcloud', 7728, 27 FROM Dual UNION ALL SELECT 219, 'jbrugger', 7681, 389 FROM Dual UNION AL +L SELECT 220, 'Mago', 7678, 135 FROM Dual UNION ALL SELECT 221, 'petdance', 7678, 537 FROM Dual UNION AL +L SELECT 222, 'randyk', 7641, 212 FROM Dual UNION ALL SELECT 223, 'herveus', 7616, 594 FROM Dual UNION ALL SELECT 224, 'pbeckingham', 7616, 379 FROM Dual UNION + ALL SELECT 225, 'gube', 7614, 227 FROM Dual UNION ALL SELECT 226, 'Beatnik', 7573, 728 FROM Dual UNION ALL SELECT 227, 'Spooty', 7571, 0 FROM Dual UNION ALL SELECT 228, 'Courage', 7532, 569 FROM Dual UNION ALL SELECT 229, 'sweetblood', 7528, 239 FROM Dual UNION +ALL SELECT 230, 'grantm', 7400, 662 FROM Dual UNION ALL SELECT 231, 'artist', 7384, 885 FROM Dual UNION ALL SELECT 232, 'gaal', 7365, 796 FROM Dual UNION ALL SELECT 233, 'Herkum', 7342, 630 FROM Dual UNION ALL SELECT 234, 'jasonk', 7330, 616 FROM Dual UNION ALL SELECT 235, 'tinita', 7302, 669 FROM Dual UNION ALL SELECT 236, 'hv', 7301, 652 FROM Dual UNION ALL SELECT 237, 'tall_man', 7228, 454 FROM Dual UNION AL +L SELECT 238, 'Elian', 7220, 602 FROM Dual UNION ALL SELECT 239, 'suaveant', 7176, 982 FROM Dual UNION AL +L SELECT 240, 'traveler', 7156, 641 FROM Dual UNION AL +L SELECT 241, 'gregor42', 7152, 253 FROM Dual UNION AL +L SELECT 242, 'radiantmatrix', 7144, 905 FROM Dual UNI +ON ALL SELECT 243, 'ioannis', 7136, 131 FROM Dual UNION ALL SELECT 244, 'princepawn', 7122, 1092 FROM Dual UNION + ALL SELECT 245, 'jfroebe', 7121, 592 FROM Dual UNION ALL SELECT 246, 'Kanji', 7094, 417 FROM Dual UNION ALL SELECT 247, 'jlongino', 7089, 433 FROM Dual UNION AL +L SELECT 248, 'Dominus', 7089, 507 FROM Dual UNION ALL SELECT 249, 'Crackers2', 7073, 214 FROM Dual UNION A +LL SELECT 250, 'cjf', 7016, 364 FROM Dual UNION ALL SELECT 251, 'QM', 6999, 1027 FROM Dual UNION ALL SELECT 252, 'TGI', 6988, 648 FROM Dual UNION ALL SELECT 253, 'jryan', 6983, 543 FROM Dual UNION ALL SELECT 254, 'arturo', 6945, 876 FROM Dual UNION ALL SELECT 255, 'ccn', 6907, 464 FROM Dual UNION ALL SELECT 256, 'saintmike', 6903, 475 FROM Dual UNION A +LL SELECT 257, 'TomDLux', 6900, 705 FROM Dual UNION ALL SELECT 258, 'quester', 6867, 211 FROM Dual UNION ALL SELECT 259, 'Bloodnok', 6828, 1096 FROM Dual UNION A +LL SELECT 260, 'chuckbutler', 6818, 38 FROM Dual UNION +ALL SELECT 261, 'simonm', 6812, 554 FROM Dual UNION ALL SELECT 262, 'duff', 6805, 799 FROM Dual UNION ALL SELECT 263, 'Anneq', 6800, 96 FROM Dual UNION ALL SELECT 264, 'davis', 6774, 311 FROM Dual UNION ALL SELECT 265, 'Fastolfe', 6706, 1236 FROM Dual UNION A +LL SELECT 266, 'nvivek', 6706, 76 FROM Dual UNION ALL SELECT 267, 'davies', 6669, 450 FROM Dual UNION ALL SELECT 268, 'virtualsue', 6621, 334 FROM Dual UNION +ALL SELECT 269, 'Petruchio', 6620, 144 FROM Dual UNION A +LL SELECT 270, 'MeowChow', 6616, 685 FROM Dual UNION AL +L SELECT 271, 'zby', 6588, 840 FROM Dual UNION ALL SELECT 272, 'jaldhar', 6582, 152 FROM Dual UNION ALL SELECT 273, 'tphyahoo', 6581, 689 FROM Dual UNION AL +L SELECT 274, 'toma', 6574, 416 FROM Dual UNION ALL SELECT 275, 'karlgoethebier', 6560, 946 FROM Dual UN +ION ALL SELECT 276, 'stonecolddevin', 6553, 689 FROM Dual UN +ION ALL SELECT 277, 'vladb', 6536, 369 FROM Dual UNION ALL SELECT 278, 'andreas1234567', 6523, 630 FROM Dual UN +ION ALL SELECT 279, 'b10m', 6490, 575 FROM Dual UNION ALL SELECT 280, 'AcidHawk', 6488, 232 FROM Dual UNION AL +L SELECT 281, 'silent11', 6479, 175 FROM Dual UNION AL +L SELECT 282, 'erix', 6472, 368 FROM Dual UNION ALL SELECT 283, 'pc88mxer', 6466, 838 FROM Dual UNION AL +L SELECT 284, 'Errto', 6426, 585 FROM Dual UNION ALL SELECT 285, 'RavingGoat', 6416, 4 FROM Dual UNION AL +L SELECT 286, 'manoj_speed', 6404, 20 FROM Dual UNION +ALL SELECT 287, 'Skeeve', 6363, 857 FROM Dual UNION ALL SELECT 288, 'jima', 6351, 18 FROM Dual UNION ALL SELECT 289, 'RichardK', 6348, 404 FROM Dual UNION AL +L SELECT 290, 'hippo', 6306, 524 FROM Dual UNION ALL SELECT 291, 'kiat', 6302, 500 FROM Dual UNION ALL SELECT 292, 'Marza', 6281, 447 FROM Dual UNION ALL SELECT 293, 'samizdat', 6259, 532 FROM Dual UNION AL +L SELECT 294, 'exussum0', 6246, 600 FROM Dual UNION AL +L SELECT 295, 'bingos', 6228, 170 FROM Dual UNION ALL SELECT 296, 'spiritway', 6198, 586 FROM Dual UNION A +LL SELECT 297, 'educated_foo', 6186, 757 FROM Dual UNIO +N ALL SELECT 298, 'idsfa', 6170, 313 FROM Dual UNION ALL SELECT 299, 'mpeppler', 6165, 798 FROM Dual UNION AL +L SELECT 300, 'chacham', 6160, 736 FROM Dual UNION ALL SELECT 301, 'polettix', 6102, 813 FROM Dual UNION AL +L SELECT 302, 'gjb', 6091, 467 FROM Dual UNION ALL SELECT 303, 'ciderpunx', 6078, 130 FROM Dual UNION A +LL SELECT 304, 'kudra', 6067, 317 FROM Dual UNION ALL SELECT 305, 'thezip', 6055, 302 FROM Dual UNION ALL SELECT 306, 'ghenry', 6050, 571 FROM Dual UNION ALL SELECT 307, 'Adam', 6045, 758 FROM Dual UNION ALL SELECT 308, 'MadraghRua', 6032, 98 FROM Dual UNION A +LL SELECT 309, 'greenFox', 6006, 374 FROM Dual UNION AL +L SELECT 310, 'particle', 5957, 673 FROM Dual UNION AL +L SELECT 311, 'EdwardG', 5930, 285 FROM Dual UNION ALL SELECT 312, 'soonix', 5922, 307 FROM Dual UNION ALL SELECT 313, 'busunsl', 5920, 352 FROM Dual UNION ALL SELECT 314, 'fglock', 5912, 658 FROM Dual UNION ALL SELECT 315, 'jonnyfolk', 5907, 339 FROM Dual UNION A +LL SELECT 316, 'arhuman', 5852, 386 FROM Dual UNION ALL SELECT 317, 'VinsWorldcom', 5832, 339 FROM Dual UNIO +N ALL SELECT 318, 'ignatz', 5821, 366 FROM Dual UNION ALL SELECT 319, 'Eliya', 5782, 725 FROM Dual UNION ALL SELECT 320, 'didier', 5779, 42 FROM Dual UNION ALL SELECT 321, 'GotToBTru', 5776, 567 FROM Dual UNION A +LL SELECT 322, 'Samy_rio', 5758, 174 FROM Dual UNION AL +L SELECT 323, 'Utilitarian', 5756, 471 FROM Dual UNION + ALL SELECT 324, 'rhesa', 5754, 488 FROM Dual UNION ALL SELECT 325, 'ig', 5725, 884 FROM Dual UNION ALL SELECT 326, 'nimdokk', 5680, 450 FROM Dual UNION ALL SELECT 327, 'Chmrr', 5677, 284 FROM Dual UNION ALL SELECT 328, 'simon.proctor', 5666, 359 FROM Dual UNI +ON ALL SELECT 329, 'rir', 5653, 488 FROM Dual UNION ALL SELECT 330, 'lhoward', 5644, 576 FROM Dual UNION ALL SELECT 331, 'sri', 5630, 117 FROM Dual UNION ALL SELECT 332, 'stefp', 5619, 300 FROM Dual UNION ALL SELECT 333, 'poj', 5580, 696 FROM Dual UNION ALL SELECT 334, 'djw', 5573, 78 FROM Dual UNION ALL SELECT 335, 'bichonfrise74', 5537, 384 FROM Dual UNI +ON ALL SELECT 336, 'thelenm', 5503, 333 FROM Dual UNION ALL SELECT 337, 'Gangabass', 5459, 439 FROM Dual UNION A +LL SELECT 338, 'webfiend', 5457, 281 FROM Dual UNION AL +L SELECT 339, 'George_Sherston', 5456, 503 FROM Dual U +NION ALL SELECT 340, 'SuicideJunkie', 5453, 690 FROM Dual UNI +ON ALL SELECT 341, 'benn', 5399, 370 FROM Dual UNION ALL SELECT 342, 'Plankton', 5384, 468 FROM Dual UNION AL +L SELECT 343, 'johnnywang', 5353, 488 FROM Dual UNION +ALL SELECT 344, 'PetaMem', 5349, 289 FROM Dual UNION ALL SELECT 345, 'BazB', 5349, 240 FROM Dual UNION ALL SELECT 346, 'ichimunki', 5336, 557 FROM Dual UNION A +LL SELECT 347, 'zdog', 5332, 221 FROM Dual UNION ALL SELECT 348, 'Punitha', 5291, 41 FROM Dual UNION ALL SELECT 349, 'greywolf', 5275, 83 FROM Dual UNION ALL SELECT 350, 'bojinlund', 5264, 29 FROM Dual UNION AL +L SELECT 351, 'duelafn', 5251, 234 FROM Dual UNION ALL SELECT 352, 'chas', 5207, 218 FROM Dual UNION ALL SELECT 353, 'etcshadow', 5143, 475 FROM Dual UNION A +LL SELECT 354, 'mickeyn', 5129, 71 FROM Dual UNION ALL SELECT 355, '2teez', 5128, 615 FROM Dual UNION ALL SELECT 356, 'Discipulus', 5124, 633 FROM Dual UNION +ALL SELECT 357, 'arashi', 5119, 34 FROM Dual UNION ALL SELECT 358, 'I0', 5114, 334 FROM Dual UNION ALL SELECT 359, 'imp', 5112, 391 FROM Dual UNION ALL SELECT 360, 'kschwab', 5061, 349 FROM Dual UNION ALL SELECT 361, 'matija', 5054, 511 FROM Dual UNION ALL SELECT 362, 'parv', 5045, 693 FROM Dual UNION ALL SELECT 363, 'thor', 5044, 798 FROM Dual UNION ALL SELECT 364, 'g0n', 5040, 309 FROM Dual UNION ALL SELECT 365, 'pfaut', 5026, 442 FROM Dual UNION ALL SELECT 366, 'ctilmes', 5022, 207 FROM Dual UNION ALL SELECT 367, 'kutsu', 5013, 354 FROM Dual UNION ALL SELECT 368, 'Nkuvu', 5008, 484 FROM Dual UNION ALL SELECT 369, 'rovf', 5004, 927 FROM Dual UNION ALL SELECT 370, 'dwm042', 4983, 292 FROM Dual UNION ALL SELECT 371, 'mdillon', 4981, 338 FROM Dual UNION ALL SELECT 372, 'chanio', 4981, 360 FROM Dual UNION ALL SELECT 373, 'itub', 4978, 426 FROM Dual UNION ALL SELECT 374, 'pemungkah', 4972, 501 FROM Dual UNION A +LL SELECT 375, 'emazep', 4941, 37 FROM Dual UNION ALL SELECT 376, 'TheDamian', 4937, 250 FROM Dual UNION A +LL SELECT 377, 'ptum', 4936, 399 FROM Dual UNION ALL SELECT 378, 'dreadpiratepeter', 4921, 314 FROM Dual +UNION ALL SELECT 379, 'Dog and Pony', 4901, 370 FROM Dual UNIO +N ALL SELECT 380, 'guha', 4894, 163 FROM Dual UNION ALL SELECT 381, 'Chady', 4877, 482 FROM Dual UNION ALL SELECT 382, 'ar0n', 4870, 323 FROM Dual UNION ALL SELECT 383, 'Sidhekin', 4858, 223 FROM Dual UNION AL +L SELECT 384, 'TheoPetersen', 4852, 142 FROM Dual UNIO +N ALL SELECT 385, 'szabgab', 4834, 342 FROM Dual UNION ALL SELECT 386, 'spurperl', 4829, 306 FROM Dual UNION AL +L SELECT 387, 'bulk88', 4826, 587 FROM Dual UNION ALL SELECT 388, 't0mas', 4825, 282 FROM Dual UNION ALL SELECT 389, 'gopalr', 4819, 154 FROM Dual UNION ALL SELECT 390, 'punkish', 4814, 513 FROM Dual UNION ALL SELECT 391, 'shenme', 4813, 334 FROM Dual UNION ALL SELECT 392, 'wind', 4805, 620 FROM Dual UNION ALL SELECT 393, 'rdfield', 4804, 410 FROM Dual UNION ALL SELECT 394, 'djantzen', 4793, 353 FROM Dual UNION AL +L SELECT 395, 'bronto', 4786, 392 FROM Dual UNION ALL SELECT 396, 'pileofrogs', 4780, 527 FROM Dual UNION +ALL SELECT 397, 'antirice', 4777, 347 FROM Dual UNION AL +L SELECT 398, 'davidj', 4770, 222 FROM Dual UNION ALL SELECT 399, 'broomduster', 4749, 115 FROM Dual UNION + ALL SELECT 400, 'gmpassos', 4744, 600 FROM Dual UNION AL +L SELECT 401, 'jacques', 4741, 528 FROM Dual UNION ALL SELECT 402, 'keszler', 4729, 427 FROM Dual UNION ALL SELECT 403, 'tomfahle', 4726, 48 FROM Dual UNION ALL SELECT 404, 'Steve_p', 4720, 293 FROM Dual UNION ALL SELECT 405, 'extremely', 4715, 711 FROM Dual UNION A +LL SELECT 406, 'philcrow', 4713, 377 FROM Dual UNION AL +L SELECT 407, 'flyingmoose', 4702, 640 FROM Dual UNION + ALL SELECT 408, 'crenz', 4694, 397 FROM Dual UNION ALL SELECT 409, 'bmann', 4692, 214 FROM Dual UNION ALL SELECT 410, 'TedPride', 4686, 1009 FROM Dual UNION A +LL SELECT 411, 'wil', 4656, 119 FROM Dual UNION ALL SELECT 412, 'ChemBoy', 4651, 282 FROM Dual UNION ALL SELECT 413, 'danger', 4645, 280 FROM Dual UNION ALL SELECT 414, 'tcf22', 4643, 310 FROM Dual UNION ALL SELECT 415, 'Tomte', 4626, 369 FROM Dual UNION ALL SELECT 416, 'lemming', 4616, 312 FROM Dual UNION ALL SELECT 417, 'repellent', 4608, 488 FROM Dual UNION A +LL SELECT 418, 'shadox', 4590, 62 FROM Dual UNION ALL SELECT 419, 'Rhose', 4584, 98 FROM Dual UNION ALL SELECT 420, 'kwaping', 4580, 452 FROM Dual UNION ALL SELECT 421, 'hiseldl', 4578, 199 FROM Dual UNION ALL SELECT 422, 'Hue-Bond', 4575, 354 FROM Dual UNION AL +L SELECT 423, 'trs80', 4570, 294 FROM Dual UNION ALL SELECT 424, 'Paulster2', 4563, 142 FROM Dual UNION A +LL SELECT 425, 'converter', 4562, 269 FROM Dual UNION A +LL SELECT 426, 'fisher', 4535, 152 FROM Dual UNION ALL SELECT 427, 'Theo', 4529, 154 FROM Dual UNION ALL SELECT 428, 'robartes', 4511, 394 FROM Dual UNION AL +L SELECT 429, 'leocharre', 4503, 675 FROM Dual UNION A +LL SELECT 430, 'eXile', 4502, 226 FROM Dual UNION ALL SELECT 431, 'hacker', 4500, 287 FROM Dual UNION ALL SELECT 432, 'sh1tn', 4498, 578 FROM Dual UNION ALL SELECT 433, 'bsb', 4485, 361 FROM Dual UNION ALL SELECT 434, 'trammell', 4466, 284 FROM Dual UNION AL +L SELECT 435, 'deprecated', 4449, 232 FROM Dual UNION +ALL SELECT 436, 'svsingh', 4445, 90 FROM Dual UNION ALL SELECT 437, 'biohisham', 4441, 435 FROM Dual UNION A +LL SELECT 438, 'pKai', 4431, 232 FROM Dual UNION ALL SELECT 439, 'injunjoel', 4404, 206 FROM Dual UNION A +LL SELECT 440, 'Eyck', 4400, 197 FROM Dual UNION ALL SELECT 441, 'stephen', 4396, 286 FROM Dual UNION ALL SELECT 442, 'willyyam', 4395, 89 FROM Dual UNION ALL SELECT 443, 'Paladin', 4376, 170 FROM Dual UNION ALL SELECT 444, 'jeroenes', 4367, 439 FROM Dual UNION AL +L SELECT 445, 'jynx', 4358, 252 FROM Dual UNION ALL SELECT 446, 'Dragonfly', 4338, 55 FROM Dual UNION AL +L SELECT 447, 'stevieb', 4319, 594 FROM Dual UNION ALL SELECT 448, 'Kenosis', 4301, 760 FROM Dual UNION ALL SELECT 449, 'Ryszard', 4300, 434 FROM Dual UNION ALL SELECT 450, 'technojosh', 4294, 108 FROM Dual UNION +ALL SELECT 451, 'jbert', 4276, 430 FROM Dual UNION ALL SELECT 452, 'fullermd', 4247, 137 FROM Dual UNION AL +L SELECT 453, 'chrestomanci', 4244, 384 FROM Dual UNIO +N ALL SELECT 454, 'cguevara', 4225, 1 FROM Dual UNION ALL SELECT 455, 'john_oshea', 4225, 121 FROM Dual UNION +ALL SELECT 456, 'nothingmuch', 4223, 390 FROM Dual UNION + ALL SELECT 457, 'moklevat', 4215, 175 FROM Dual UNION AL +L SELECT 458, 'clinton', 4213, 405 FROM Dual UNION ALL SELECT 459, 'muba', 4201, 441 FROM Dual UNION ALL SELECT 460, 'Util', 4174, 287 FROM Dual UNION ALL SELECT 461, 'AppleFritter', 4171, 429 FROM Dual UNIO +N ALL SELECT 462, 'neniro', 4162, 262 FROM Dual UNION ALL SELECT 463, 'shriken', 4152, 15 FROM Dual UNION ALL SELECT 464, 'KM', 4142, 557 FROM Dual UNION ALL SELECT 465, 'sth', 4135, 80 FROM Dual UNION ALL SELECT 466, 'monarch', 4127, 453 FROM Dual UNION ALL SELECT 467, 'fenLisesi', 4111, 207 FROM Dual UNION A +LL SELECT 468, 'thunders', 4111, 271 FROM Dual UNION AL +L SELECT 469, 'redgreen', 4092, 25 FROM Dual UNION ALL SELECT 470, 'monkey_boy', 4076, 143 FROM Dual UNION +ALL SELECT 471, 'bikeNomad', 4073, 507 FROM Dual UNION A +LL SELECT 472, 'blahblahblah', 4071, 169 FROM Dual UNIO +N ALL SELECT 473, 'McA', 4071, 626 FROM Dual UNION ALL SELECT 474, 'gornox_zx', 4067, 9 FROM Dual UNION ALL SELECT 475, 'trwww', 4065, 186 FROM Dual UNION ALL SELECT 476, 'Mutant', 4052, 349 FROM Dual UNION ALL SELECT 477, 'iguanodon', 4044, 147 FROM Dual UNION A +LL SELECT 478, 'Biker', 4038, 253 FROM Dual UNION ALL SELECT 479, 'phydeauxarff', 4033, 201 FROM Dual UNIO +N ALL SELECT 480, 'frankus', 4024, 288 FROM Dual UNION ALL SELECT 481, 'The Mad Hatter', 4009, 384 FROM Dual UN +ION ALL SELECT 482, 'crouchingpenguin', 4005, 101 FROM Dual +UNION ALL SELECT 483, 'AdamQuark', 4003, 4 FROM Dual UNION ALL SELECT 484, 'Thelonius', 4003, 468 FROM Dual UNION A +LL SELECT 485, 'elwarren', 3991, 299 FROM Dual UNION AL +L SELECT 486, 'monkfan', 3989, 308 FROM Dual UNION ALL SELECT 487, 'allolex', 3981, 372 FROM Dual UNION ALL SELECT 488, 'Siddartha', 3972, 33 FROM Dual UNION AL +L SELECT 489, 'Elgon', 3968, 151 FROM Dual UNION ALL SELECT 490, 'valavanp', 3965, 68 FROM Dual UNION ALL SELECT 491, 'frozenwithjoy', 3953, 452 FROM Dual UNI +ON ALL SELECT 492, 'Tanalis', 3953, 254 FROM Dual UNION ALL SELECT 493, 'MZSanford', 3953, 386 FROM Dual UNION A +LL SELECT 494, 'rowdog', 3944, 187 FROM Dual UNION ALL SELECT 495, 'pelagic', 3934, 257 FROM Dual UNION ALL SELECT 496, 'igelkott', 3931, 222 FROM Dual UNION AL +L SELECT 497, 'zakzebrowski', 3924, 300 FROM Dual UNIO +N ALL SELECT 498, 'Rhandom', 3901, 328 FROM Dual UNION ALL SELECT 499, 'Jonathan', 3898, 217 FROM Dual UNION AL +L SELECT 500, 'ChOas', 3879, 168 FROM Dual UNION ALL SELECT 501, 'mifflin', 3877, 244 FROM Dual UNION ALL SELECT 502, 'NodeReaper', 3864, 57005 FROM Dual UNIO +N ALL SELECT 503, 'rozallin', 3864, 65 FROM Dual UNION ALL SELECT 504, 'sutch', 3844, 103 FROM Dual UNION ALL SELECT 505, 'Jouke', 3840, 279 FROM Dual UNION ALL SELECT 506, '/dev/trash', 3829, 26 FROM Dual UNION A +LL SELECT 507, 'BigJoe', 3824, 305 FROM Dual UNION ALL SELECT 508, 'Illuminatus', 3822, 413 FROM Dual UNION + ALL SELECT 509, 'tjh', 3821, 156 FROM Dual UNION ALL SELECT 510, 'fruiture', 3817, 301 FROM Dual UNION AL +L SELECT 511, 'OeufMayo', 3801, 146 FROM Dual UNION AL +L SELECT 512, 'lin0', 3799, 149 FROM Dual UNION ALL SELECT 513, 'geektron', 3797, 464 FROM Dual UNION AL +L SELECT 514, 'DaWolf', 3787, 274 FROM Dual UNION ALL SELECT 515, 'mertserger', 3780, 80 FROM Dual UNION A +LL SELECT 516, 'AgentM', 3779, 542 FROM Dual UNION ALL SELECT 517, 'kidd', 3778, 66 FROM Dual UNION ALL SELECT 518, 'defyance', 3776, 167 FROM Dual UNION AL +L SELECT 519, 'marinersk', 3775, 616 FROM Dual UNION A +LL SELECT 520, 'ariels', 3774, 238 FROM Dual UNION ALL SELECT 521, 'athomason', 3774, 187 FROM Dual UNION A +LL SELECT 522, 'tsee', 3769, 150 FROM Dual UNION ALL SELECT 523, 'erroneousBollock', 3761, 346 FROM Dual +UNION ALL SELECT 524, 'Jim', 3758, 537 FROM Dual UNION ALL SELECT 525, 'arden', 3752, 161 FROM Dual UNION ALL SELECT 526, 'tangent', 3752, 380 FROM Dual UNION ALL SELECT 527, 'hominid', 3747, 70 FROM Dual UNION ALL SELECT 528, 'Erez', 3743, 177 FROM Dual UNION ALL SELECT 529, 'haoess', 3739, 92 FROM Dual UNION ALL SELECT 530, 'mattr', 3736, 526 FROM Dual UNION ALL SELECT 531, 'leriksen', 3729, 221 FROM Dual UNION AL +L SELECT 532, 'dmitri', 3726, 242 FROM Dual UNION ALL SELECT 533, 'clintp', 3721, 331 FROM Dual UNION ALL SELECT 534, 'aaron_baugher', 3714, 584 FROM Dual UNI +ON ALL SELECT 535, 'DamnDirtyApe', 3706, 379 FROM Dual UNIO +N ALL SELECT 536, 'mce', 3704, 177 FROM Dual UNION ALL SELECT 537, 'elusion', 3703, 209 FROM Dual UNION ALL SELECT 538, 'Trimbach', 3684, 272 FROM Dual UNION AL +L SELECT 539, 'metaperl', 3680, 593 FROM Dual UNION AL +L SELECT 540, 'sunadmn', 3674, 103 FROM Dual UNION ALL SELECT 541, 'bluto', 3673, 322 FROM Dual UNION ALL SELECT 542, 'dimar', 3673, 261 FROM Dual UNION ALL SELECT 543, 'jarich', 3661, 199 FROM Dual UNION ALL SELECT 544, 'khayos', 3654, 0 FROM Dual UNION ALL SELECT 545, 'Lawliet', 3653, 411 FROM Dual UNION ALL SELECT 546, 'markjugg', 3651, 275 FROM Dual UNION AL +L SELECT 547, 'astaines', 3640, 77 FROM Dual UNION ALL SELECT 548, 'Eily', 3640, 290 FROM Dual UNION ALL SELECT 549, 'roke', 3639, 5 FROM Dual UNION ALL SELECT 550, 'little', 3639, 364 FROM Dual UNION ALL SELECT 551, 'eduardo', 3632, 159 FROM Dual UNION ALL SELECT 552, 'LD2', 3621, 201 FROM Dual UNION ALL SELECT 553, 'premchai21', 3606, 296 FROM Dual UNION +ALL SELECT 554, 'robsv', 3600, 32 FROM Dual UNION ALL SELECT 555, 'peppiv', 3593, 98 FROM Dual UNION ALL SELECT 556, 'neilwatson', 3591, 489 FROM Dual UNION +ALL SELECT 557, '#include', 3590, 18 FROM Dual UNION ALL SELECT 558, 'andyford', 3586, 286 FROM Dual UNION AL +L SELECT 559, 'newrisedesigns', 3585, 263 FROM Dual UN +ION ALL SELECT 560, 'citromatik', 3579, 277 FROM Dual UNION +ALL SELECT 561, 'edan', 3572, 355 FROM Dual UNION ALL SELECT 562, 'RhetTbull', 3569, 147 FROM Dual UNION A +LL SELECT 563, 'jptxs', 3567, 313 FROM Dual UNION ALL SELECT 564, 'mrmick', 3559, 195 FROM Dual UNION ALL SELECT 565, 'gam3', 3554, 319 FROM Dual UNION ALL SELECT 566, 'inman', 3546, 473 FROM Dual UNION ALL SELECT 567, 'JayBonci', 3546, 140 FROM Dual UNION AL +L SELECT 568, 'Moron', 3538, 903 FROM Dual UNION ALL SELECT 569, 'andye', 3535, 337 FROM Dual UNION ALL SELECT 570, 'teamster_jr', 3530, 104 FROM Dual UNION + ALL SELECT 571, 'mandog', 3528, 168 FROM Dual UNION ALL SELECT 572, 'cchampion', 3525, 144 FROM Dual UNION A +LL SELECT 573, 'logan', 3522, 169 FROM Dual UNION ALL SELECT 574, 'tomhukins', 3506, 274 FROM Dual UNION A +LL SELECT 575, 'moof1138', 3505, 32 FROM Dual UNION ALL SELECT 576, 'PERLscienceman', 3504, 49 FROM Dual UNI +ON ALL SELECT 577, 'mitd', 3496, 165 FROM Dual UNION ALL SELECT 578, 'cacharbe', 3493, 240 FROM Dual UNION AL +L SELECT 579, 'neophyte', 3492, 150 FROM Dual UNION AL +L SELECT 580, 'graq', 3492, 142 FROM Dual UNION ALL SELECT 581, 'jesuashok', 3485, 542 FROM Dual UNION A +LL SELECT 582, 'monsieur_champs', 3470, 187 FROM Dual U +NION ALL SELECT 583, 'waswas-fng', 3470, 725 FROM Dual UNION +ALL SELECT 584, 'scottstef', 3467, 116 FROM Dual UNION A +LL SELECT 585, 'renodino', 3454, 263 FROM Dual UNION AL +L SELECT 586, 'reclaw', 3452, 15 FROM Dual UNION ALL SELECT 587, 'lima1', 3450, 242 FROM Dual UNION ALL SELECT 588, 'Hofmator', 3446, 574 FROM Dual UNION AL +L SELECT 589, 'scain', 3430, 216 FROM Dual UNION ALL SELECT 590, 'pajout', 3425, 351 FROM Dual UNION ALL SELECT 591, 'sk', 3425, 231 FROM Dual UNION ALL SELECT 592, 'targetsmart', 3413, 354 FROM Dual UNION + ALL SELECT 593, 'ehdonhon', 3409, 329 FROM Dual UNION AL +L SELECT 594, 'moxliukas', 3405, 126 FROM Dual UNION A +LL SELECT 595, 'clemburg', 3403, 352 FROM Dual UNION AL +L SELECT 596, 'dbwiz', 3400, 133 FROM Dual UNION ALL SELECT 597, 'epoptai', 3397, 202 FROM Dual UNION ALL SELECT 598, 'socketdave', 3388, 98 FROM Dual UNION A +LL SELECT 599, 'perlfan', 3378, 393 FROM Dual UNION ALL SELECT 600, 'Dietz', 3370, 65 FROM Dual UNION ALL SELECT 601, 'crashtest', 3361, 159 FROM Dual UNION A +LL SELECT 602, 'eff_i_g', 3354, 273 FROM Dual UNION ALL SELECT 603, 'chip', 3349, 342 FROM Dual UNION ALL SELECT 604, 'pme', 3329, 203 FROM Dual UNION ALL SELECT 605, 'stefan k', 3329, 259 FROM Dual UNION AL +L SELECT 606, 'ZZamboni', 3316, 356 FROM Dual UNION AL +L SELECT 607, 'kyoshu', 3315, 16 FROM Dual UNION ALL SELECT 608, 'rdw', 3307, 24 FROM Dual UNION ALL SELECT 609, 'jerrygarciuh', 3306, 250 FROM Dual UNIO +N ALL SELECT 610, 'aquarium', 3302, 791 FROM Dual UNION AL +L SELECT 611, 'azatoth', 3297, 171 FROM Dual UNION ALL SELECT 612, 'murugu', 3293, 150 FROM Dual UNION ALL SELECT 613, 'bwelch', 3286, 57 FROM Dual UNION ALL SELECT 614, 'tfrayner', 3285, 65 FROM Dual UNION ALL SELECT 615, 'RolandGunslinger', 3281, 36 FROM Dual U +NION ALL SELECT 616, 'BioLion', 3280, 301 FROM Dual UNION ALL SELECT 617, 'dorward', 3279, 268 FROM Dual UNION ALL SELECT 618, 'screamingeagle', 3278, 154 FROM Dual UN +ION ALL SELECT 619, 'Jazz', 3274, 77 FROM Dual UNION ALL SELECT 620, 'maverick', 3265, 279 FROM Dual UNION AL +L SELECT 621, 'rvosa', 3259, 325 FROM Dual UNION ALL SELECT 622, 'Ponky', 3252, 6 FROM Dual UNION ALL SELECT 623, 'arkturuz', 3250, 178 FROM Dual UNION AL +L SELECT 624, 'wjw', 3234, 371 FROM Dual UNION ALL SELECT 625, 'Zoogie', 3233, 44 FROM Dual UNION ALL SELECT 626, 'CharlesClarkson', 3230, 129 FROM Dual U +NION ALL SELECT 627, 'petral', 3228, 321 FROM Dual UNION ALL SELECT 628, 'Loops', 3227, 352 FROM Dual UNION ALL SELECT 629, 'MarkM', 3226, 160 FROM Dual UNION ALL SELECT 630, 'ruzam', 3224, 313 FROM Dual UNION ALL SELECT 631, 'hok_si_la', 3224, 76 FROM Dual UNION AL +L SELECT 632, 'olus', 3224, 311 FROM Dual UNION ALL SELECT 633, 'Maclir', 3220, 269 FROM Dual UNION ALL SELECT 634, 'superfrink', 3216, 235 FROM Dual UNION +ALL SELECT 635, 'wog', 3214, 251 FROM Dual UNION ALL SELECT 636, 'gav^', 3212, 275 FROM Dual UNION ALL SELECT 637, 'jaredor', 3212, 42 FROM Dual UNION ALL SELECT 638, 'cees', 3209, 309 FROM Dual UNION ALL SELECT 639, 'amarquis', 3206, 202 FROM Dual UNION AL +L SELECT 640, 'tune', 3204, 173 FROM Dual UNION ALL SELECT 641, 'InfiniteSilence', 3197, 476 FROM Dual U +NION ALL SELECT 642, 'steves', 3197, 433 FROM Dual UNION ALL SELECT 643, 'Seumas', 3194, 80 FROM Dual UNION ALL SELECT 644, 'rbc', 3193, 211 FROM Dual UNION ALL SELECT 645, 'Daruma', 3187, 41 FROM Dual UNION ALL SELECT 646, 'krujos', 3184, 126 FROM Dual UNION ALL SELECT 647, 'tunaboy', 3183, 29 FROM Dual UNION ALL SELECT 648, 'tstock', 3175, 135 FROM Dual UNION ALL SELECT 649, 'naChoZ', 3171, 299 FROM Dual UNION ALL SELECT 650, 'bbfu', 3170, 442 FROM Dual UNION ALL SELECT 651, 'jsprat', 3166, 261 FROM Dual UNION ALL SELECT 652, 'Hero Zzyzzx', 3165, 300 FROM Dual UNION + ALL SELECT 653, 'punch_card_don', 3164, 373 FROM Dual UN +ION ALL SELECT 654, 'Thilosophy', 3152, 247 FROM Dual UNION +ALL SELECT 655, 'chunlou', 3149, 254 FROM Dual UNION ALL SELECT 656, 'dasgar', 3140, 524 FROM Dual UNION ALL SELECT 657, 'tinman', 3140, 82 FROM Dual UNION ALL SELECT 658, 'ruoso', 3132, 185 FROM Dual UNION ALL SELECT 659, 'swiftone', 3115, 410 FROM Dual UNION AL +L SELECT 660, 'mje', 3115, 681 FROM Dual UNION ALL SELECT 661, 'Jaap', 3111, 461 FROM Dual UNION ALL SELECT 662, 'wombat', 3105, 48 FROM Dual UNION ALL SELECT 663, 'been42', 3097, 41 FROM Dual UNION ALL SELECT 664, 'rnahi', 3089, 124 FROM Dual UNION ALL SELECT 665, 'csuhockey3', 3088, 122 FROM Dual UNION +ALL SELECT 666, 'creamygoodness', 3087, 234 FROM Dual UN +ION ALL SELECT 667, 'giulienk', 3086, 122 FROM Dual UNION AL +L SELECT 668, 'vkon', 3083, 382 FROM Dual UNION ALL SELECT 669, 'SparkeyG', 3083, 42 FROM Dual UNION ALL SELECT 670, 'naikonta', 3070, 417 FROM Dual UNION AL +L SELECT 671, 'Rex(Wrecks)', 3069, 238 FROM Dual UNION + ALL SELECT 672, 'juo', 3067, 89 FROM Dual UNION ALL SELECT 673, 'seeker', 3067, 27 FROM Dual UNION ALL SELECT 674, 'BooK', 3064, 118 FROM Dual UNION ALL SELECT 675, 'phaylon', 3061, 255 FROM Dual UNION ALL SELECT 676, 'saberworks', 3061, 235 FROM Dual UNION +ALL SELECT 677, 'mrpilot', 3056, 23 FROM Dual UNION ALL SELECT 678, 'c-era', 3039, 234 FROM Dual UNION ALL SELECT 679, 'pjf', 3035, 149 FROM Dual UNION ALL SELECT 680, 'lidden', 3034, 206 FROM Dual UNION ALL SELECT 681, 'jjdeterick', 3034, 11 FROM Dual UNION A +LL SELECT 682, 'hipowls', 3034, 227 FROM Dual UNION ALL SELECT 683, 'lvanhout', 3031, 23 FROM Dual UNION ALL SELECT 684, 'Sandy', 3022, 214 FROM Dual UNION ALL SELECT 685, 'damian1301', 3021, 232 FROM Dual UNION +ALL SELECT 686, 'cyocum', 3016, 92 FROM Dual UNION ALL SELECT 687, 'linuxer', 3009, 296 FROM Dual UNION ALL SELECT 688, 'Aragorn', 3005, 234 FROM Dual ), Divide(Quotient) AS ( SELECT ROUND ( CASE Writeups WHEN 0 THEN -1 ELSE XP/Writeups END ) FROM Data ), Categorize(Name) AS ( SELECT CASE WHEN Quotient BETWEEN 001 AND 009 THEN '1-9' WHEN Quotient BETWEEN 010 AND 099 THEN '10-99' WHEN Quotient BETWEEN 100 AND 999 THEN '100-999' WHEN Quotient = 1660 THEN '~1660' WHEN Quotient > 999 THEN '1000+' WHEN Quotient = -1 THEN 'nan' WHEN Quotient <= 1 THEN '<=0' END FROM Divide ) SELECT Name, COUNT(*) FROM Categorize GROUP BY Name ORDER BY CASE Name WHEN '1-9' THEN 1 WHEN '10-99' THEN 2 WHEN '100-999' THEN 3 WHEN '1000+' THEN 4 WHEN '~1660' THEN 5 WHEN '<=0' THEN 6 WHEN 'nan' THEN 7 END;
NAME COUNT(*) ------- ---------- 1-9 135 10-99 506 100-999 39 1000+ 4 ~1660 1 <=0 1 nan 2 7 rows selected.

FWIW:
NameXP
AdamQuark1001
valentin1104
RavingGoat1604
vroom1660
cguevara4225

Replies are listed 'Best First'.
Re^3: poll ideas quest 2015 (xp/writeups ratio)
by stevieb (Canon) on Sep 02, 2015 at 13:42 UTC

    I'm curious to understand how some people have very few posts, but have so much XP. I'm only singling out cguevara here because I saw they have only one post as they're on the same screenful of Saints in our Book as I am. However, there are other users with say 5 or 10 posts with high XP as well.

    It doesn't look like it's due to grandfathering from A Level Playing Field, as some of these users hadn't appeared here on PM until well after those changes.

    Can someone please point out why this is so?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2020-02-29 05:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What numbers are you going to focus on primarily in 2020?










    Results (128 votes). Check out past polls.

    Notices?