0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
    u.Id AS UserId,
    u.CreationDate AS ProfileCreationDate,
    u.Reputation,
    u.Views AS ProfileViews,
    COUNT(CASE WHEN b.Class = 1 THEN 1 END) AS GoldBadges,
    COUNT(CASE WHEN b.Class = 2 THEN 1 END) AS SilverBadges,
    COUNT(CASE WHEN b.Class = 3 THEN 1 END) AS BronzeBadges
FROM 
    Users u
LEFT JOIN 
    Badges b ON u.Id = b.UserId
WHERE 
    u.Id IN (12398748,2881548,15143474,15143847,10641790,15144743,14053575,12342293,7209444,11375063,12822979,9966601,6921370,15148146,15149290,14241245,6244094,14294514,14897605,14741935,14627650,15152883,5066080,5970903,14905794,11652374,110852,10385214,14717763,15155646,15159358,14914490,14897745,14086906,12825232,2754688,7015191,4495790,5451495,9293989,15163003,4860775,184491,10975865,15165330,14723421,15163813,9462570,14569842,12675457,9169532,561678,12877988,10479804,5932667,11844406,1213186,5597242,13338996,14836680,14810048,292106,9694570,14597834,13298339,8537816,14897725,15029547,13289551,9918623,12056694,15160379,3324932,2285214,15177996,15178251,14592589,6484367,15179192,15056716,13401945,9673040,12080090,14476690,12124994,15182475,15184586,14362262,14898394,15143059,14947239,3260199,10033727,7033724,2778906,11383504,15188406,7758452,15189077,12487621,13753885,12768260,8167565,14211008,12783261,3692615,13947464,10135899,866171,14557221,12980644,15101067,12645056,3086871,8171079,12234006,15197127,14779926,15200152,9582195,6304597,7507702,6303451,15013708,14469061,15203055,13974914,14117609,15204183,12921107,9806019,9170938,6813564,9592263,13074474,15207222,7197956,7321251,14341278,15208263,12769791,12078810,15210322,539490,2603139,14784198,15212268,10859450,7318120,4075155,3302016,12931525,13061806,708979,15215077,14707657,11375031,1934798,8661327,14661706,15214605,14667683,9868137,11078150,15007400,13965278,7148863,5719396,2137653,1683139,4297539,12924397,12343465,428724,13741975,9891095,4226045,11858772,10580661,14816366,15230392,13125193,13874745,1023580,13674740,15234086,4214094,9626790,6114651,5057022,15131390,15237589,15171221,12499505,15240325,9279902,13906061,13246035,1644810,12442419,8744146,14557026,14417341,12840031,14841220,15248298,15248826,1841545,13118200,6402286,10862518,15252651,10255609,12596230,15253446,8252267,11800092,15254288,12895136,6848931,4556597,10082024,12035916,3994249,13628901,5345662,14395273,988469,13482659,12214332,17413,7185727,15224849,11396195,7629384,7916823,2142577,15264309,15264336,11846763,13966135,4659211,11485718,14566662,3670097,15268733,10677134,12825525,14484330,13749290,11036017,13561449,8865568,14636386,14320591,4251336,15276484,9033739,15277707,11710948,14924811,13938995,15278446,13211127,15278845,13474389,15281255,8859356,13969690,4642925,11390687,11200182,12856596,14742134,12949388,15286598,12116486,10845377,15281212,4661692,10081454,12134355,10800072,14726018,659223,7789984,11186140,453538,12119223,14590375,14924649,10375310,14150679,7717583,13353974,15255077,15302593,3331037,11794286,9287711,15224310,9052998,9630366,6497191,9112151,11796986,14668761,15310639,13759387,10697213,5504061,8676754,14579492,2657817,12854411,13362681,13015877,15319480,11909393,2626093,4907950,11235511,13687100,15322414,6914481,4750980,5935863,11404653,13904557,10775595,2902769,15286891,12846026,13062735,4844789,14733247,2057783,15048298,15190242,9513183,15333027,1955673,7129076,12489487,15334467,10955806,11691180,3639702,15204049,421049,15337918,15338377,8776586,7242490,9007785,10447470,4391305,221270,8947614,14964722,1335384,15345529,15347233,15347236,14459020,14463983,6215467,7345423,15348607,1821450,758986,14297384,15234244,14701895,9095117,15352294,14788634,8063541,14239550,8753810,15354334,15191176,8932440,3413414,15354810,4792229,11472469,1663614,2844716,12955644,10897255,4045358,15359600,15348317,3952424,15361936,14394522,10689209,4846660,6232665,10002825,8417524,10144881,8437546,15365977,15367202,9234006,4224108,11588707,15369594,15319349,14468532,15372150,15373472,10594079,15375059,15375228,15153036,14892272,15376078,15206206,12749028,15212193,6540440,10380766,6304086,8852102,8309941,14962727,15381080,15350822,15379526,15381971,9884322,12782054,11180583,13653441,14591200,9110646,10745758,5482187,12705918,15385685,14542975,15386471,8587732,3733276,647092,14555778,15389545,13483796,14776719,15012599,13257217,14362056,15032847,15393344,8866279,14682160,14751354,15170101,15187524,14564531,884444,14796997,15396469,15387220,15062511,14536767,15369665,5645209,15401962,12291628,814438,2889297,15005487,14043741,13949974,12171016,12937208,8773741,14762087,13528314,11197957,4046105,14896462,15408634,11062555,14913466,15409444,14586658,13057251,15298132,912744,2938321,7239453,14849100,9016028,15109208,1726260,10625845,13660589,278391,9198920,15248155,15418098,7186921,15417929,2333145,13223848,15272015,13431617,4344935,15423413,15424013,14713356,15067451,12838566,11240382,8839958,12091517,4230468,13904063,5860388,15103176,7518617,12281027,2095719,13576580,9632940,15434156,11406452,6180286,15235039,14587292,14936622,14366872,15093079,15438033,8188060,12445333,10862936,1883795,15440676,15440693,12881003,12051766,15436369,2365711,15441533,11102385,9503559,15232030,15444733,11874188,2300622,9016734,15441315,5250832,9928908,4863162,2718777,15408176,2649051,13103887,15451973,2950931,13240504,15454584,13577182,14033717,9755070,15456066,10976198,6789615,9903770,15459753,997606,7379787,15461662,14720496,11705004,15303058,12938030,2976116,15465419,15465557,15420001,12420884,14450593,15469143,10457357,12661268,14963242,12283181,10386345,333350,2265998,13024743,10744730,15455926,15479096,12334528,15473437,194813,10015567,14798004,15482343,15304709,13010462,14701560,9274977,15484877,11434501,3286975,11759663,14100972,15489835,14620817,10625273,15408303,6541082,7350992,15494787,13775115,14722363,13177568,2609653,2198293,15388613,15500170,15500486,7807893,14636746,7817954,14948342,13694078,3863660,15504455,13863557,15504418,15264192,15505696,13704922,15321056,7829297,5716914,11794402,9525277,6744259,2647106,15511801,11131258,14253781,12695448,13690852,2224727,15514483,15515713,471861,11719508,15370323,12325896,15220214,7616592,13695375,15523926,9375838,7227136,8605448,13160154,10294080,4858253,14138677,7848820,11467639,6248683,15292554,14013091,10166399,14526164,13811372,15536981,3450691,15274173,6760497,8011495,4826487,5422386,15542475,15542738,13749684,14220911,12702964,13174070,6503670,15041992,14385918,8425685,12309808,11025822,14058564,7485582,12741360,15365769,15246186,15396553,15552225,7929660,1412765,14159635,15276691,14327863,9278669,10067858,14933947,15553203,12250893,899271,15560458,15109915,12941578,7853765,7225856,14132801,15557614,14283021,15562514,15467240,6061863,11617040,6815335,15570007,14598215,14399345,12978861,12114675,9784499,15290570,10319271,15498100,1838527,10894456,11698825,15167762,6830459,10870255,3892213,9623580,15545705,15567537,7827432,3934100,13831730,14790453,15476042,15580266,14427533,15582383,9940782,15100013,15584027,9105549,15583132,15583528,15585096,15585609,7106766,9359783,15586774,5793587,1775706,15590227,6423160,15591292,8247976,1792676,15450208,13186127,11060020,13237485,15450962,11838160,15599773,12292254,11471385,6017598,15601056,13084116,15008911,15602682,5777945,15603744,11646579,15604419,15604519,15605062,12336032,12399372,12968673,5860262,2805083,5519228,15527965,15609336,1169741,12564187,15612211,10461550,10856905,15614380,15578744,12964107,7951709,6025198,3832802,10634518,13656177,12034620,14588151,11673590,13072818,2949897,10459336,6595656,15624772,990750,12818089,13383185,14409419,15629603,15277335,15634498,7764533,11961242,15636656,2978904,14939783,12139914,11488279,421178,11402435,14357736,6840713,13444876,13678259,14092720,2747609,12019306,11415690,5094006,11083136,15654891,11481959,11480142,6507095,5410001,2674538,12587580,15378974,15673152,4465168,14188342,12063167,15278333,15671749,11877543,9822149,15376573,13482676,12916761,9601960,6398512,15683690,13269636,15684879,1492229,11103557,10129270,7555448,15632874,5972844,5228065,10567768,11044457,11796421,10491248,12172927,9745091,15186364,15695182,14151705,7969213,14716469,6724628,12037963,2319794,14556734,4132144,15067175,15598537,15328223,12912943,13294120,11732975,14356557,15705821,15696595,15425383,14480191,6777053,13908676,15713090,15715394,15384170,6796061,14997717,15578198,13765816,10986973,489838,13617486,15341600,8066064,3881814,5728812,11088078,3786740,14630621,15735904,15008609,15735826,8271708,6516970,9541868,14679439,3305822,15738782,644566,5878647,9165263,9185253,15748831,11426538,15749112,8223154,12985315,8792159,15751985,2290389,15643716,11241788,15752509,13708378,13835971,7966156,4002842,12589738,2113950,15594461,9250490,13870146,15761761,13651510,15217754,6748772,15690317,6647852,11058704,7185743,4383027,6065008,15578599,13807079,5466636,11152653,13389627,15591210,1820480,15769101,3100284,15769989,15418966,13014864,15773890,11689458,15276863,15537109,12198552,15775125,5081328,15495499,15772456,5131623,15778152,10598418,2693474,11640416,7357850,6368243,13286624,14863770,9733228,10389307,3743369,15786341,11501326,7626018,14981771,157397,6798649,15793886,4616157,7141320,1975053,11462302,10425982,9048995,15795928,13187389,15797881,6667653,15801875,14923227,3938025,9373723,15803409,15285276,14833143,14994085,15008861,15807727,15808091,15019300,9027598,705876,6557487,4797507,11749933,11217003,15220864,15032928,4675794,14567418,6515793,9276999,8367357,13525444,4195212,14274894,13735173,3270037,10221835,15824834,11656425,2251968,15826071,14383028,6328032,14236622,15829392,4734216,12814772,7466533,12937971,2013399,15833847,15834107,15498235,15809491,15052184,15358162,13658560,1261959,12058369,12682568,2560213,13537336,15843044,6470472,14418938,1770012,15845130,15845151,1168308,14015832,15849260,2039808,13858175,15834370,7573304,9259357,15409228,13227628,15855753,15857730,15228258,10385582,15845253,15119409,7168098,13654153,14585049,10565084,11698568,6793742,12192463,13781254,4067683,10808565,15872320,15873977,14521464,15876023,14304728,5221625,13083268,15115301,15880286,15872164,13907568,15661358,15532034,4476840,15175378,14396002,11955584,5494625,15881937,8779395,14045676,5791008,8119664,4390160,9310154,14629701,15890878,8728804,1545658,10636599,6652703,15869277,15078580,2426195,14200659,14089179,7162827,15897156,9869811,12110409,15902105,9249572,6672247,14558148,8306644,15907195,14807716,11110340,12711820,13419278,8790126,15520113,1007503,4317058,12642103,13483057,717290,1197719,2806971,2776779,15920702,14309001,15921763,15119551,10467407,14970415,13941965,15288561,4039074,13041458,15928111,15928332,15927226,15922402,5507535,13076369,15929892,10000968,14684741,9558747,15329314,11504150,14517943,3436831,15674506,8162281,15935100,11771479,13569852,15770551,5322358,15936202,14094169,9979051,13054511,15540194,6239096,13457596,15942071,11650513,15943796,6130345,15944934,10779494,562389,15949270,13850694,8443371,15828701,10609947,14951957,11173364,15792344,15953935,15954283,888715,9885374,9623925,9497072,15954007,9568619,15962200,15837255,10573817,13022820,14441642,15703084,15888703,13453736,13716686,15756682,15976095,11800011,15396261,12605239,15980370,15981046,15983329,15299685,4142405,13418156,15984349,15917973,15985127,15907814,15976091,11087632,12348862,13227401,2175012,15112914,14933981,15683412,14349078,7138899,5207457,14349010,11732976,6422790,608576,16003002,15955523,12108599,12525206,12970389,13322278,8641766,4126814,14997682,12508248,15986006,2305815,15005395,9246694,15947989,12057138,1754927,14557971,5769868,7442823,16015121,14529596,1042817,12265465,10793061,13503512,4201149,13937418,13454063,13698294,16023810,13074756,3820991,15111791,12493545,6609678,3308553,3250120,8493157,3727771,16033598,10425214,12091689,16035692,15832223,4278393,6722117,15751315,11801511,7507337,14951027,8301998,16004356,13596996,16043395,16047458,14974783,11753385,16047500,2948684,15841556,15594306,10274964,10016471,7390391,15530206,8061298,383689,16059405,13411545,9984384,4991138,13805529,15538765,13110605,16069561,16061199,12685016,15495302,8354414,16072384,5435218,16066583,8957019,13825398,15393744,12970235,16076068,16076505,13497903,3577419,14127776,16079852,1159192,15609738,10797401,13211975,12859533,8900739,15842860,15165962,16086601,10514991,16089006,15109450,14376217,7485317,11497009,12506676,3877029,11442410,15839694,16092844,827251,8144973,152128,16094446,16089600,16096609,2210282,2045438,12395951,14301911,1234419,12247577,11673733,16101821,13297192,430083,13557241,13804551,8991698,15475635,10454874,12221580,14789046,15234476,12230864,12267956,10062377,16112406,10117285,12744113,16012297,15652011,15157423,2045185,13356847,11693292,16107919,5959175,5249708,14261610,1708864,16125383,15992173,13559474,11907166,16126666,14934348,13342246,11070440,16131116,15464167,16132396,14969251,16110551,16134636,12516704,16134939,4576095,16135903,16138976,368691,12325824,13798770,16005658,14265021,16128341,13885384,15769359,11704106,7885656,5291529,12429781,10577273,16150767,10319808,15566511,16153182,16079601,11871696,1698143,7362960,16157032,5220832,16158802,16159349,4681098,4052745,16161550,16161571,7256570,15116103,10658140,5295778,14808299,11780744,16089447,7949574,2482123,16042341,8916734,1539139,16152356,13100162,9235000,1382647,11094041,5714363,16178574,3815000,16179262,15288054,3854185,14497821,1803705,15775322,8542257,1208923,16167121,15800903,15338095,2735044,13905998,14962347,13037272,15716588,16195731,12200406,15658660,5836933,4723383,16184402,2437278,13933287,12319355,12652313,14030353,16206178,16207259,13549586,16208926,14601334,16211259,7369112,13417270,16143085,14221822,14518811,14896806,11295516,13758294,14664961,3761560,8164366,14802118,16220065,16220260,13161402,16221659,13518126,9213402,2403221,16168284,16225124,11348652,751231,15898209,16232405,16233924,16235914,14991694,16237470,3051389,8655868,16241544,15634543,16211114,16243063,13031114,14658051,15290960,9015962,16245405,16245589,11030253,16139327,5486298,730584,13803295,9363736,3405113,13437125,16248827,16250895,11378877,16196777,2029198,16044983,12109241,2497334,16254055,2296226,2733981,16256485,8614742,9844236,9071943,16257503,10346788,1251918,9406474,14442795,16268350,13929058,9454716,7745173,3666302,8416640,15673147,6939848,13788747,16063289,11001493,14052333,4205720,10257611,3378652,16036538,15963455,7070798,11747697,2526794,15039038,15722432,12720020,15293048,16293294,16292414,14710026,15921762,16269182,14512961,12295553,8795140,16298687,8106255,12455457,11070439,14752193,15173384,9632613,7346898,16232045,15408069,16239636,13836903,16309170,1848526,3239842,7579012,16244131,9320823,16312955,13651057,15506606,15281534,12911698,10189759,13709317,3634630,6300467,16317813,12013152,5256563,11039712,9238733,15937793,14554135,15419682,14181512,15061951,9681732,16014809,12984137,5726675,5450305,8956445,11238057,16243980,12472317,13826039,12104825,1904755,16303827,14481226,16332159,16332313,12342425,15982124,12387764,11771167,5486232,10217740,16336830,16337234,16281516,16340503,15248009,16224401,9051177,2545449,7875842,8926894,16345297,16345601,10082297,16339667,9511034,6877936,15542251,11680965,11637921,7006570,6650769,6790069,2336165,16353128,16353305,16354946,16355140,3720792,9482302,16238148,11016458,11969403,8365922,15847775,7598378,14361968,14941832,14387696,14441956,7809471,16349825,8081555,7253302,567595,12169560,3620725,13530950,16368260,15304775,16369336,7529549,9611374,7450491,14948234,12706995,14256633,1418670,13766948,12677136,15542722,11750108,16072877,6720274,16317118,5011113,16244642,12476965,847773,13428182,16381970,13020647,13963370,14290458,6552428,11500177,16316878,16379820,12021183,11343154,15262464,11276515,15866445,16388821,9555517,6747238,11769441,13667070,15485820,16391965,116983,16393910,12744365,7511904,6443822,14485046,11703015,16399104,16014729,16401011,13758610,11014335,15349296,2216953,79878,16404369,15776341,13823485,15209841,8311330,14138883,16239990,14259165,12378060,16408963,3487441,15343004,8849755,14184021,14868619,11001157,14839573,16417958,13964141,16418917,15392195,12152331,11608946,16421212,12788169,11130128,11481419,14378316,16101304,16422333,13869654,12756076,4292114,12016688,16084581,5025885,16202205,16426351,4605359,13529770,15999380,16330041,15023361,16429860,2773206,4406222,16421564,15803650,10158066,5655202,16436642,7312527,13246559,13882425,14764352,16441005,16442005,12469120,14373020,15542346,13932711,16273835,16177461,5132456,16446094,15236296,7664147,7553842,9462472,14017263,2491725,12218599,12250028,15170813,13365886,16446535,16454615,14511862,14399584,15200705,1418533,12314856,2802340,13404927,8209489,13898570,10742101,869455,8791366,16420381,13289778,13477535,14834563,11539762,16468764,9764089,11940924,11885241,13434118,10463875,8638440,16472472,7750402,16473232,16473354,11807587,16071676,16475737,12677635,15943282,11971528,14352208,16478195,4879877,1810877,13101871,13231192,15194529,1867093,16479595,3030776,13827133,15394304,16487195,11566804,3585723,803745,16490996,16299863,16315718,12946736,15800667,14501177,12973147,10068131,16496149,5646269,10901520,16455810,12707201,14713900,9160712,14670778,12365499,6016132,16504752,14856250,12388712,10075437,4354017,10632336,15992512,2614250,16511859,10310738,14729777,3486243,15578536,13482179,15695071,16488031,16516767,14697934,4694533,10033765,13374463,14190718,9910316,14837746,9255360,15981366,16518075,13740164,2246239,9992976,16523704,16524483,13229196,8259352,13169925,1593298,16528709,16529082,16028339,16043061,4012887,16532902,5530553,12146671,16218952,4431554,14718642,10289090,14314304,14718355,10181987,16420723,16443220,7401463,2383766,14869598,11043658,16547586,13604707,16450225,4014834,13539732,16549377,15967829,14177883,16472820,11353092,10398264,16527259,9898033,7093073,16436177,16556601,13993723,13430481,4581287,5942721,8028981,15632299,16307944,14930858,13040732,2970409,13354617,16564428,16552047,14740055,12289244,16566697,15758658,16566994,13068247,11861874,4150861,7769738,7225236,16569250,10168791,11441825,11039170,5376071,15998494,10732825,16574064,7974115,10401287,16171946,713777,12066677,1605859,15507166,1678770,10034632,16582872,4688595,16047994,13648745,16586273,7871676,13027192,12879917,13883724,4883598,12208072,9762930,15967967,5866297,16081039,14145740,14918058,12338760,16389692,15447313,16595906,11105619,4429539,11424626,5524761,11254744,14937446,16601544,14971720,13927490,8035804,16442172,5075778,16338548,14457692,16606223,9127614,16594653,12350431,77273,4360756,16612034,3641618,11718370,14668349,15199888,3361121,13461260,1859744,13375249,12714507,11249501,9773625,11938399,5676949,12107089,13349320,15884758,13949231,15972567,12875409,10581944,16317644,16257452,13256890,15087483,14329083,16631125,8873813,16300199,6138564,12946359,15200522,16635945,11044215,12158252,12852544,1860314,16642644,12003833,15405159,16634205,6059213,16359523,5618856,15068411,16370054,11685381,16650665,1785661,9345991,16653847,1136982,16655343,14617228,15496564,10275029,15983623,501557,5725589,11763939,16660994,10506380,16662520,11258729,5447280,14475291,15013119,16096585,5924373,16330083,2758471,2631934,14508019,16672233,13574537,16660763,13662551,13769660,15145256,16378078,16652509,14656699,15882009,16680240,5844628,16682523,9916514,6524788,16658832,3859913,12374339,5947073,16688925,16632694,857620,16689093,6279152,15946731,13963537,2291036,16084423,11210924,16102698,11142816,7590303,10442232,16707673,8809543,9560002,11138439,7283995,14207187,7205131,12263917,15973729,9585397,3285787,10671866,16475052,16722579,15472073,13386449,15017904,16724334,14398732,15253757,16559296,15584820,16508872,16713556,16730709,15320579,14482885,3316009,16735134,14731559,1436508,13213262,2220328,14598792,7540393,10223580,16608456,5782092,16695086,11032665,14250883,15452880,10470218,8954799,15153508,9952960,14729430,2454869,14409562,10251555,3758396,16751925,9140632,1942603,16753934,16535529,15774401,16406196,16758207,7301656,12319705,15454039,14686226,10189237,6531633,12055581,14424785,9854895,16197542,279738,12163005,1714496,8386378,7910488,15339613,12949186,11204570,15826946,16774374,15623133,523079,12350716,16778090,9220998,15039758,6763963,10341337,13674384,16388591,9356563,8211228,11355536,8277273,5735036,6151409,13707032,16787979,1678467,14624651,14348290,15261101,13326684,3748541,4074980,16765762,16796250,16796460,1137388,7529022,9916154,4601598,12223162,14180392,16568826,11487696,3451681,413023,16246317,14661813,7022038,12980102,11522973,14641214,10617622,9825559,14381081,15475014,1583274,12848149,15707025,16813448,10311197,16814392,11758183,16468370,8414280,1277239,6792833,8256347,11015596,3547456,14739866,14247751,16280618,14236237,15236072,14567080,16824435,16035232,16825503,6309785,4133609,3953137,13191920,10402691,14848796,10413624,12709848,14707182,6495910,9194639,16837837,16838085,16590189,13864836,12774896,14241210,11930252,6833801,6510836,13566458,7042795,16668311,14642785,16844721,14127281,16846644,16577541,12200248,9628788,10800115,5722339,16842816,10909363,16851334,16617186,15514998,7366657,13834173,12416654,14644020,13825658,16862640,16844893,8044045,16854893,13836955,15840394,1315599,9900375,15777187,13091039,16875462,10907711,13826047,12543827,10488313,6402174,15649322,16224660,16844277,16881230,13916295,16208930,16885749,8812124,13541056,5614052,16888943,9676381,11592386,10667703,11712834,10260806,16063957,12977239,16898608,16877006,9702817,10847096,6286882,16867486,11145988,9010895,1469261,14277368,3416199,16910689,988061,12199212,13566993,10773877,16914146,14533390,12902027,16710993,12758565,16915588,8953274,3013633,6111726,7420665,16918637,12819882,8466292,2324690,11711137,12280257,12667594,8807575,14088215,16222530,8681249,10923697,16826988,16929734,15020124,15630298,839846,9064356,13645324,15951465,10381983,15952224,15285102,14323795,15952169,10059652,3012421,16466741,16937328,13100320,11225013,16939820,11550788,9042297,304522,16893481,8889824,16942885,16946530,11985806,3772506,13787721,12063969,15835112,16900362,14336933,13822182,16954409,16955377,16957100,10361787,13249082,16963351,16963798,14755530,16965112,2271360,16559524,7453683,5559681,15770448,738794,5848607,16456459,5689191,11930716,14298113,12650894,5727849,15938774,14279721,4918971,15431652,6384676,14913806,16931006,4343563,16824394,7365826,14615758,10383068,16980740,6862189,15525319,744221,1907849,13057903,4093051,14837548,16126789,16831430,16986697,15912833,15532692,9794882,8162546,16990337,7694859,16491055,13119067,12409303,15178375,11762349,6688801,8708364,11484177,17002136,16931387,6649786,17003975,12389586,7741097,6387233,17007542,15219831,10017417,11095027,16521679,8009481,16462842,11248612,11348816,17011915,17012359,16983458,12752199,14530348,14347880,17015069,17016603,13340814,12068948,7051888,11736994,14804492,9807081,14565024,13296968,3145373,17023717,10352328,14451464,14437399,13150580,8853390,14733252,14002836,15889782,17033022,12552861,12220263,13100783,12541277,10671769,11361401,11503677,208890,17043321,14851554,13038831,17045664,17046596,12956960,17047293,756639,11568337,17050764,2875641,58678,7998522,15909890,17056008,7252065,12027725,17057841,17059823,1209853,15449934,16040844,15431330,7342980,10597836,17066487,11645172,13468128,16335399,13552294,11204560,8242205,11233910,13689775,13399075,16650865,4303027,17083590,17083942,230571,4847841,3848398,12897204,17087862,17091076,2712045,13886907,13631591,17093392,12962823,10053379,11963834,15439132,17096557,10873171,12519771,13947115,17090386,16815064,14360027,13257400,11748680,12826670,11716441,17103593,3911495,14564370,7757415,2371987,14677896,17108410,14450676,6892837,16435498,8953562,8165301,17113008,11677095,12948877,17031784,2009377,5387794,3552975,10973736,12417458,15147738,7150454,13852041,13785243,16837967,16897043,16740729,10618890,13828865,13766078,13062858,2063755,12705988,1692924,7652202,16933400,8531224,17125122,13896374,6319067,9222161,13332448,13555987,17130019,5059265,4843390,16253841,17120183,10356717,6696948,14725315,13756061,17099341,11725268,11721935,14770901,17072696,14945694,14183379,6474055,16827591,15826005,12269587,10131284,4198688,15136558,1088468,11129502,3017771,17148768,16456664,17150388,11245255,17150558,17152483,17151753,32914,15767889,14932716,15800148,12846524,17046741,2241241,10061212,17162466,14166523,11137562,10343711,14113678,17166724,6672893,14468860,15749704,6805982,17168501,17135390,8208974,15398219,13334044,5478528,12383492,15403678,10030931,17169047,17047853,8755974,17175411,17175920,13834503,13177703,17178984,17179598,16017416,2449161,15753188,17185711,12470764,16769086,15240109,17188365,9572292,15027098,17100165,17188857,706962,17183625,6212252,16530656,17192763,17060730,14735526,11058930,15031671,15309895,6334082,17198253,17076909,8921969,6118858,11821310,13660249,16143377,2074831,15957910,7439761,11813339,17170341,4539787,974925,4859602,17059658,13709089,15465206,17134711,17211421,4017206,4063139,15548363,9727617,2801589,147632,7814201,9484595,4465440,13927375,13258153,8642144,17221279,14807865,15011104,17223523,17205633,15429371,11272758,11909827,13053656,14085940,17031344,11780625,17219844,16854761,9461258,17230379,13407686,1268941,17230688,3269485,14428944,16363897,283553,5449789,17201453,12577316,9448540,15087903,17235420,16417189,5193945,16218760,17240083,15806697,11509611,17242590,17209469,11500602,6867232,17244425,11037926,4807042,17247910,477055,17144248,17248701,17251385,17252448,10331491,16939052,3310801,15979321,15817935,15368187,10303199,1300757,2304409,8138340,17040976,12293384,8847596,6539714,2482149,6769885,10822996,6909078,17265696,425104,13729265,5428643,11629229,17271694,10625718,36590,11816224,13834264,17273401,14066170,14422079,16504203,16095527,6822340,16930381,9111244,1192861,17278904,10375568,15680552,16104284,16437084,15284241,14119863,6570365,7375639,11481590,9506566,17292830,15714628,17235625,3147156,11148666,12268764,10285413,2720256,16542616,13611738,16980613,13774794,9177079,17299351,232017,17299916,14027701,11886802,12410318,6329005,15945004,1420929,11170269,4023392,12308324,17306410,17307660,12344862,17309250,11646766,4861613,12068277,4488970,6288248,17244669,1851006,9796650,16398170,17313144,9360751,6073463,17224399,6950159,13032644,10289507,14141469,5901629,17320870,17322426,14159854,16060441,17325996,17326721,980515,14339712,17328137,9567894,17327558,7625095,9410484,17333381,17334016,15605274,17310522,15219102,8709603,8433044,17336490,9256127,11171152,10507405,11840564,4098607,16965892,17338596,14522638,12543122,15612010,16436500,7191473,14326071,17221142,4989243,17342320,3344920,12966170,9068493,2278037,3491364,14286825,10371732,14074435,1907376,12615902,17331557,14619073,14453043,11302931,15939839,10616820,12102246,17356937,16792330,12472832,15725706,15944582,5423576,5100166,1036405,11785824,13125581,13503517,13546832,12027869,3727308,15566755,17370717,15995551,2433679,6775986,17371985,4773213,14954139,7027346,15478306,14560046,2359593,16674436,546678,17382906,17133273,16755045,10194999,14223108,17386970,11228630,17371060,13324349,1058292,17389049,9206735,1720743,16369817,17390143,9444084,1526836,15324798,16504687,17396507,17042361,9449938,8238204,11326537,1591156,17397688,2698407,17392022,13776511,16071567,4279446,2998077,16882937,13701706,13170981,17406923,17408871,17081736,9594794,12626886,17384310,11225660,1788771,14656530,14938670,11771418,14316709,14749889,17413363,10470363,6036772,9084937,11270332,8533621,16636054,7842934,2245024,16995565,13419202,17422578,15198571,17047946,16188928)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

fork query

edited may 25

created may 24 anonymous