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 (10437985,4817479,184730,7951907,9101805,5154538,8898639,5865411,2051959,10522672,4596428,10522734,7605240,160937,9668567,9985995,2445065,9512406,2797746,3733436,5107827,8027729,10528097,3174668,9090508,10530196,2832960,10530718,9856092,4459180,10531464,880601,9138830,10473625,9867215,1965074,10205110,10531241,8947088,5484374,6289878,9629771,9163968,8767839,10426057,10536824,10536837,10445919,4260303,4763333,7944277,82383,10534113,10540021,10101628,5829906,5493076,8376147,10497569,2877133,10544060,3361908,8943246,10545748,9235328,7484393,6951419,10494651,4296850,5914034,4907188,3704026,6543170,1355504,4320288,10102864,10398750,9352997,8778802,8765448,2668182,10458971,10558528,6636896,2624866,10562128,5727643,5580841,10563991,1498200,8482467,10464077,7458561,10566843,3310774,7322425,2446435,9409795,9816518,6281250,10197090,8492057,7846936,1940417,10567330,8772751,6224975,5447204,7025662,10122561,3840147,6908603,10574766,7679136,3585934,239582,8757494,6054099,10410829,7840090,10578340,5589427,2444805,6330985,6047114,9047195,6923127,277434,5404109,268721,7970547,7868376,8916210,10132403,10569991,9177454,10093744,8792060,881216,9609778,5563086,10587417,10587397,10587433,294317,4115477,10589178,10589437,8292178,9450564,10591762,8452731,10359629,8716080,2915960,7596051,4651471,5235412,10555265,6853893,7746905,9386974,5252492,10519853,9318769,7184947,10601826,9582127,10584388,10486772,10532020,10603186,10603180,10603274,10477051,10576559,3516720,4104387,7371784,10604069,9937356,10604825,10600897,4956217,4883694,10567900,5428490,9709986,8271518,7774163,6290230,3988931,5441299,3805509,10609283,10611322,7773783,9502177,10613104,10614728,9209920,855151,5682802,3057742,10615322,8521524,4569596,10383658,10616278,10618643,10571379,4619193,1002758,4788612,10280472,2548965,4287407,8509499,5394438,2711026,10383587,562117,10612795,10622513,2029188,10524264,4697769,10523324,9864814,10318021,5471637,5165530,8614595,10141391,7731167,9566965,3934988,2527327,10512905,10626609,9951217,10627789,9908169,3940829,10629168,2104088,2887203,5864207,10632137,10632432,8692853,7853291,1996547,2466685,10575855,10137281,1932379,8993294,7817512,10102452,8448091,8563717,10634449,4059524,10071966,10636117,6141147,4445219,10637526,2435020,8147876,5808464,10640986,10641070,3794981,10639468,10623992,10642122,8922507,1604099,10642241,298225,3363228,1552260,1636139,9070206,10645468,9630486,1014809,8981425,5701704,10518822,9012175,10618020,8120300,10642263,9723616,6751597,1947873,6774444,9003475,81419,9965058,10566626,3210353,7185283,6653385,10654426,8876034,5143667,10655519,4549226,5513323,9344164,2499597,9706893,6442447,2060396,6063708,7801160,9827376,10133187,10559800,5936469,18858,5225745,10653565,10666991,9081056,10332586,10667857,2751808,10576445,10500802,5319837,9770494,10595783,8930189,942589,9955661,10671474,10304307,7823016,4476908,10672827,2074779,3126402,6261823,10673963,446206,4988651,9080594,1602555,8052668,10088084,6905299,10347057,4994701,7089187,475727,1400880,10387008,7823264,9179416,7214559,6062598,10669066,2680640,10355846,10516096,3960426,8719785,6853912,4308444,5931333,7805600,2339405,2016602,8920003,10689054,1302444,10623583,10245370,10690174,5502056,6006473,10466752,8582361,4106573,10692179,4789269,10605454,9018595,10605742,9135209,2623749,10537683,2111897,8643555,9780264,10339589,10698317,9930891,9646384,10699483,10623375,8679511,1804901,9119913,8590312,9214895,10703302,9068627,9589242,10703473,10704062,10561367,3425890,7462597,10704432,7641442,3972499,7798124,10706317,9710966,10581547,4247806,7701071,5076631,8664336,9504329,9429907,6069518,1260939,7716351,6109920,7762061,5945814,6945866,4090483,4272051,10676072,1602160,10713717,10713760,8387332,3752986,6210860,7677413,9999814,10224590,10502472,10716952,1144943,10716998,7023199,10577142,10718474,6903787,5377973,10719134,10719566,10719740,10720911,10720921,7122082,10720723,5226215,9351199,10723590,10058906,3729797,1944458,10039549,4402577,7577438,4409975,6548980,10726037,7662147,4652493,10727149,8896653,10729056,8386878,6511348,10582056,2092392,5037202,4325354,9646947,9581412,5592463,5217293,10009287,7481458,2389887,9182866,6475107,10217002,5925094,9636505,8391698,10735433,10047777,10263903,10243644,2576152,9438809,998248,10410598,4811085,5927073,10741864,1300440,597384,1910216,8482565,10389165,10311868,10684382,4296857,10442122,10745694,10746045,3053953,380331,3755166,3354696,9095947,5530407,6583953,4469840,10749184,1035438,4983983,7400254,10627118,2629858,10501858,7728767,6741838,10748996,9183094,10752432,4898720,8161586,9438347,4366358,4311829,9409602,10754874,7058823,3586610,6174623,10757067,9831523,10757624,5459321,10578627,10743124,7034458,6039995,10759642,9766032,7810784,5856554,3945863,5914259,5058488,9071172,7811188,4966881,10503530,1085263,10580989,9645799,6307484,10174059,275330,3192423,7321545,10335258,10737242,3159792,5407270,10771775,10725256,4076366,9473729,6254883,10455312,4854348,9452004,6676148,10776457,10267434,10776954,960404,7169628,6679016,10288790,9862964,4742074,9851475,8785756,10497994,7954504,7210893,9797162,10713244,6744597,8947312,10785453,10784780,9267728,10253196,9885747,7822426,5556491,10627863,9886094,1353933,6651490,5120376,1130266,7779939,10449931,5511336,1791646,6623689,8286029,2815937,2644424,4993840,10446949,10782054,10794826,9213069,10653347,10797018,7485621,1940607,10797563,7355534,10456960,6840039,551273,7981674,2633673,3850200,2014762,6650328,9251443,8599142,10679907,10382764,4756227,10708282,2186597,6676215,10538713,2282248,10436424,2183035,3081406,1475029,4081949,10810319,7775275,3254859,10699208,8168374,8366805,6904888,10424309,6243129,10763539,10789574,4784262,10816674,9736193,1351452,6809520,7327379,2685938,2715948,8170368,10529862,8565455,10538841,2303356,10823017,10824053,10795444,8852281,3461397,10816611,3172879,7769282,10147834,10643026,423318,6244855,5185376,8525899,10829728,6866762,3853248,5713272,6759850,5718253,4749225,7409519,3700111,8364914,9817488,4192366,3022574,1434083,10660137,10837445,9965369,1519920,465834,10491012,10132053,10612823,4887383,8351647,5502009,9231010,218284,10841416,1638596,5405998,10842140,6079395,2326160,10221163,8549135,9156037,10766014,9150638,4228196,5198133,9075805,7426373,5896312,6840733,8804476,1924261,10852907,9875090,281617,10854985,4931135,10854790,10856885,9780666,5055251,10741173,8014671,10537788,10770955,10859097,9368760,10859983,10431634,10232513,6861838,1608467,9282694,6474249,3717483,8153017,10864897,2652759,4719432,7435872,7955376,9668634,9783827,9417937,10611983,4183557,2722919,10868888,8979422,6906431,10623338,10872257,5036740,7652936,10704050,10874674,7632941,10534647,6741352,5478114,10498153,10877852,9507429,8295671,3223326,10593551,7738843,2258883,7400533,10735035,10704167,5252560,741395,7307241,2909574,10883306,2325010,6444605,10853930,7691324,732221,261783,10886164,10267022,2259701,10888861,2687611,5443758,7903952,7571171,3394241,7520067,10891160,9159433,10257651,1487138,10892699,10672704,4224925,10891599,5931677,9003947,10895504,10700421,7805308,10577043,2910468,4028614,10897543,1234376,10898324,2023728,5067053,8861637,282155,7489270,2138274,10905701,2381544,10148715,972648,10908972,10595865,3622286,3755632,10584948,3755786,8549230,10734069,10808073,10855531,7418254,8040466,8164191,10795024,4909449,10858292,10539345,10917662,10846949,7036957,9491002,9327857,8156652,9175353,1200994,10921035,7660962,7131092,10922235,10922723,4547130,10923912,2997657,9662948,7577274,9475322,10667499,5299417,10928893,10928772,10929971,9073842,7888000,10931841,10504742,8860408,8323650,10933465,2828977,9800981,4852976,10272521,7886651,10869858,10936234,10578052,6021420,10936742,10743303,10359930,7455967,9371645,3660832,10938666,2267132,10930683,7659822,10735976,9892092,10939289,9268082,5451945,6003112,7114479,8867581,10922373,3525723,10863367,10945671,1058584,1521347,7311722,779912,3225026,9617279,207062,2132649,10950261,6327663,1897055,8840568,10775485,1597290,10693964,9378581,9265595,5316867,10953978,10832457,4366515,10000061,3225309,6827344,8107351,10960608,10644550,10961697,5547422,799275,7017641,10963418,10429891,10963704,10394047,10245686,9515617,10964308,4102381,10812981,4988397,8545722,10965504,1278682,10801844,10968962,10968770,1853141,7822245,10969490,10970395,9369414,9072947,4567523,3768871,9204909,10972438,10973085,10970966,10972005,9627640,10975628,9745700,10696411,10478079,10035141,3083171,8700131,10539128,10898663,10878072,1594823,6891184,9422122,3670765,151150,8388437,5132740,10986555,7421002,9724750,4410536,3442759,10629530,3228230,4167457,10336284,4971859,10460681,10943704,1061562,246206,9362747,6479555,5803049,9172369,2129212,549246,9354531,11002138,5652620,1248219,1895939,5355343,10354180,8309944,10416862,5321842,5659402,6407935,9148822,10514075,2346131,11008168,10114862,9137657,7228127,11010224,7376796,1157605,5282154,2210256,3021357,11013391,10591515,11014578,8406780,6885572,3064626,2802669,11016724,11010804,7260261,5169360,1659442,2136502,1293563,5954825,4081971,11020521,6545859,5740397,11008454,3062659,4947708,10966989,9403787,9509346,4677807,10722187,3431327,8929814,4749742,9016872,10500415,11026123,11026757,3902859,11028546,2660520,10872748,11006962,267955,850227,7118242,5655042,10685202,11034501,2229039,6589158,11035046,5012352,7716943,5350363,984786,5489190,4721004,1925240,6017248,10642145,5990430,7758318,9174413,9341189,5158805,6112864,11044536,8091705,4356313,4548629,1936752,11003168,10288469,8457833,9965155,539047,3003659,11013635,6784475,11052197,9079461,8863172,11052820,11052852,459391,10480032,10109315,8242933,7564115,10982908,8795104,11055666,1662546,10686914,10979304,11056935,11058365,11059848,7076615,9029007,11060580,7546355,8701661,7574860,8156497,11061614,11062427,7708172,10991255,361455,11063661,11030896,5846481,10505738,8474432,7201076,10166663,10201510,10868147,8796007,10995326,10893050,9829108,176410,11027091,5822767,11072113,5496085,10081871,10045133,3573995,1397946,10975007,5966620,7372418,9213093,8105838,11017789,2187506,3370504,2040509,7149996,1846228,9680352,5014959,9160454,11078441,1435702,8876715,10614693,3183321,10746588,3454889,9538424,6666008,11082553,1940765,1926753,8010396,2140065,4832499,7429447,10390718,5832768,11086532,10486504,3901216,11088231,10798572,8376011,11089180,10937844,11037901,9153605,11091512,7919624,11092741,9990901,2244021,10053589,11095529,9138660,2219415,11096006,6117426,8065972,9734355,10581494,11096197,1517447,3500874,10772851,11098582,11100335,10159681,7631505,9380597,9431057,782400,11103815,6446850,9822065,11031361,11105701,10204937,10766868,7841980,10445732,9162902,5651487,4569045,11107623,9137728,6631153,7138517,10553582,10005787,11018701,11101525,958209,10665648,4577708,2584427,11111609,827225,8205133,5555782,3355561,11107063,3317535,4515010,5079217,5861873,2950346,9592917,5336236,10660386,3627975,4592959,10733401,11120564,11120817,1669844,3254071,7751588,6668663,11019273,8754410,11117526,10149510,8831819,756589,2426955,11034978,220255,11006577,11130889,10701430,3756506,575284,11132767,7373646,11133317,7878485,5513678,11134893,7313637,4767618,3256651,2977500,4683175,11076383,7643028,4102479,7514438,9988553,4978779,5426509,11140279,9505291,2529107,7160479,7212686,8478944,9940760,11142591,3055346,10869739,9574048,9924147,9790270,10795485,7138098,10159474,10225958,11145420,9134945,10982701,11019241,6086057,7133479,7778713,11149634,11150232,5496117,11042683,8326055,9485951,11155168,11112262,11154818,4302544,274610,3124200,3592668,9434763,5785385,1558028,9203291,11160954,5060792,10405363,11162444,11163440,6741051,4593846,7053357,9630907,11164750,11044989,9268300,9854782,8971390,4526336,10285864,11007266,11166330,11167479,9154384,9009470,6935577,11169701,6741384,7505201,8477066,4970104,10867696,11172237,11033904,75846,6212364,3388005,11179201,11174964,10826591,9713583,10452831,11149375,7896089,4288725,5207979,893185,2246218,3501283,11177552,3580058,1744657,10708920,11179606,11179805,5484208,5364144,7068954,10572038,10535329,5698535,3705709,1791812,11184449,244385,3771755,1110049,8901259,10884964,6413592,10852424,11186786,8005521,5054359,5307432,3428261,10654238,1551475,8488169,11190317,2557909,11190811,11190971,9279421,9670777,6033934,8882173,4651652,11077964,10511907,1071416,11196694,10631085,11197329,1782792,8511319,4521552,6323796,7968525,10897535,10927002,5136955,7581565,2547215,9548907,9852082,532054,11204631,2697032,2683573,8801429,11205420,11206160,11202729,5383760,7392626,4212922,10999933,4976799,11207887,11178211,3752992,4903751,8968397,2869791,6775087,10766704,10257580,7468538,977345,11213550,10111567,10985418,11215328,9309329,6998334,11215713,11215956,7493840,5959326,2825988,3100526,7852473,10580157,7068559,648874,10969858,11220615,10872342,347884,6105177,11112728,2813334,11223875,4513062,11050796,7248917,3831948,10847184,2197820,10028830,2107210,6467512,11229615,9808952,1791317,8618880,10539733,4480164,11232818,6911509,10627267,11235208,7629381,9287300,11231088,11235873,5905103,1037094,11028909,9242571,339698,4939287,8156875,2237467,5754168,10498948,5092123,8172166,6005455,11200216,10917090,1152044,11139846,10719719,2936170,8242587,10332991,2626813,8095827,10575386,11228393,6450039,9503633,9355495,11249094,9336582,11082866,10954592,7334162,1371666,3496846,6919963,8624708,10567693,11154387,6929371,11211576,10470685,5658251,7154017,5830331,6770376,11254322,6723450,7712038,9582533,2459228,11254641,9070372,5932433,11257834,11216502,2134711,10415695,6423716,9664654,10410243,10698499,10252243,8700261,11058450,1066234,11262001,9617451,4802156,1210053,11260946,11263859,4556761,1198379,9967433,11264948,9776046,6165326,11265420,8143616,6151222,1842286,7169288,4385565,10410363,9442094,9254010,10841252,10438719,8426238,7305135,3643544,11073618,3332470,11158162,9954104,2047359,11274051,11261453,8112896,8882513,3597039,11236493,9851762,5380897,9541574,10638608,3052119,2091247,4499836,6057390,11278859,4051748,11251865,3928099,11280215,10700072,2457962,3759528,8452931,11282672,8550083,11282962,11283093,11281324,11283307,9882714,10138526,5430852,10045255,8755877,1566187,2959471,10202232,10861222,10678863,9118924,10516686,7303061,4024057,11261495,4385342,11162165,11299478,10492800,11153160,11301530,7225905,7360831,11301960,3424572,8277688,9074175,11239422,10460211,10809264,11303276,4682302,6941400,1541012,3801744,11304426,5563153,3145178,3638319,7948061,1385039,6674213,11165835,4858209,6601614,1214905,11132439,11308225,9571479,6695082,11309140,1223975,11144990,10745091,8415711,11305809,7269646,1779863,11312130,11053828,8046232,8660264,11313792,5298791,1825410,10686070,1082308,10353987,9545908,11317049,11233164,442920,11318248,11140821,11180895,9785313,5531761,11320049,2679086,9403338,9424625,759349,11279755,8363043,10402385,9778602,10449299,5875052,11324573,10941276,10565873,7810147,11325692,4924866,11222844,5020152,10809273,9885236,10478016,9329341,6194518,11331252,10724702,10795935,11210476,3186274,11303413,8858776,2103918,8023474,9654520,7167076,5974057,4510954,1832484,2090474,4478968,10852334,7501485,7211701,500590,11195989,11339393,1964489,11340366,9834214,4261132,7012554,10420711,10604378,11344740,6457732,3456351,11101574,10664048,11340395,10734452,10984178,10314409,7742920,10385242,11278878,10217152,10839541,10991321,6246219,10762057,4716122,10290546,11314266,11352312,11353803,10562,2292621,10777577,11241708,2429966,11020429,5247453,10929640,7725295,1019814,11339882,11019750,11359070,3892828,8951274,8672138,9456080,2593699,6746612,3080828,10261715,5872677,5233151,9770906,79111,11363104,10222708,8280073,11364364,4438463,11119825,2962931,8439042,8737897,10989902,6081163,789299,7532015,10622517,11348543,4459027,5155833,10769706,3697903,11373004,11131523,8406937,1384608,6581983,10502511,11376572,7877309,6851828,11371182,6167321,436560,4012913,10588471,11041438,5543529,7360447,11380765,4707886,8098004,6718936,10613162,7967976,7945060,9917640,7721600,10693298,3697643,3749926,11152289,11384370,10671347,11389293,11389069,6642089,8183900,6890446,5391052,11390672,11390780,11376759,11391477,834003,8577452,2504762,11289672,4640363,11340382,11107238,11398202,7785996,10155229,8831033,3447634,10232988,10793067,1311089,5222115,11074577,11403583,9233881,11403723,11403859,11404047,4951026,8669253,11208804,2136965,11282814,1924235,9501391,4484867,9728120,11410257,7942194,9103693,10026122,2321195,11405466,11287199,8960351,11405455,3904783,4586806,11266559,5491192,8015829,11415784,8138226,6471247,11416497,2965799,11416962,10597010,5699060,10793746,3789200,2258873,9935932,10600123,11070782,11249030,3978009,10529876,11422204,6932234,11418610,10636761,2069120,6661711,7096730,288174,7685469,4790099,10563900,9515210,3301113,6803164,6941941,10883427,2479173,7913830,11429029,5531969,11430221,11377206,8174131,11430839,10227103,11413239,8342910,4022272,2709770,9150520,6896604,6001133,11217049,3346661,11142761,11436671,11438310,6452332,6500276,4178510,4791668,11439481,11440052,5554751,11056050,10465916,1333623,5782230,6472523,9500701,10011538,10997067,9424052,5108665,6323497,11440372,6804547,8532951,11446130,1376472,3537677,2961558,8923882,8149553,11019660,3003703,10861035,3574579,11304604,11452800,11413691,6715153,9094353,8638267,10210746,11457365,10800562,11321569,11458872,6608222,7822225,1757149,9728657,9055733,5963847,9778630,439407,6541472,8875434,9086231,9599852,11374983,1628353,977799,2089899,8762084,11467951,7008190,7529256,7305572,5111128,1497597,6302033,1936946,10186451,777716,476410,11461995,10724556,11473326,3376800,9504009,19761701,9785459,11257266,9654834,4331739,3941400,10836483,11156248,1175614,10048661,9373110,11131391,10560140,9492965,11483365,7645770,11361988,2373304,11484569,1644444,11485274,11485424,2588788,4835426,7049266,8002074,10845685,11486657,10593828,10572727,5432164,11480962,10358568,6181260,10656061,11488944,11489139,11485923,11488162,10793493,6164776,348851,6769077,11449564,11225631,1042646,11471637,9275885,11495271,4672035,10864824,11392116,5686712,11226508,6793328,564814,6583790,11499770,11499980,10419605,5223992,8834483,10073233,2187053,9785024,6026545,2084209,11293797,11502210,7267866,966344,2320456,10907391,9879210,6596251,6567467,11362151,10109962,5693642,9874393,2244917,10010688,11509875,5944585,7370233,630971,7873792,11103289,8426808,7183519,11158388,11464394,11260180,2888180,10624056,8388005,2207618,9739007,10361608,9182436,1175080,3120842,9136850,9806268,11519598,11158240,8199745,6661222,7187074,7475879,11522105,7756971,9640709,11001876,11192966,11525115,7766158,11527682,2804385,8041658,11530177,10417608,11458889,9905185,5411259,11533258,11533276,8451849,11534407,9477777,2601663,7164279,1351543,11536504,11538158,11164799,11538796,3881394,8865176,10537235,3491987,11509920,8767418,11537523,8003443,11030903,1868793,11544677,2284240,1574054,4059056,675738,4042267,11539008,8628766,7218871,3445825,6860886,10543129,7846700,4321082,8493865,11302633,11554434,7795205,3474961,10129894,7350859,4467558,10356612,10601377,11353265,4002204,1753517,7256594,7400903,4172807,3023559,11557710,5045787,6667905,7386830,11186083,11359368,11559275,3509337,1460353,11454699,11517037,7185318,9056430,3738152,5434756,1798717,9859165,6053327,3414943,9945307,4573444,11110509,8595693,11571329,3748410,1143539,6022365,11416986,9744779,7371707,11577501,3740279,9758338,8025382,4616299,9798664,11045998,7561001,10821210,9367095,4499249,11583155,2346897,851200,11521909,7769691,4225199,11220076,10584964,9302611,11250152,4806587,11303965,7245003,11333664,670816,9078799,10899969,10669010,10761206,1580359,4981298,11321180,10593130,11436239,11321559,11595529,269867,4593791,11117750,11597907,11598532,3059665,9882573,7920494,5289712,10198568,6415979,11352278,7595643,11532153,9081354,2950325,1709708,11602730,2122995,1572283,10738077,7026806,11604561,4366027,11098911,7644011,11605538,7327411,8307005,9844382,6616874,9751423,9548264,11607845,4781349,10389478,2099318,11454595,2286254,8413106,8520280,10460081,11322178,11600565,11590152,4008828,11614610,11615099,10174039,4414667,7934786,8290699,11143190,11622291,10823533,11622735,11623498,8945885,11500420,5359328,242814,6068850,10948109,2551705,714618,8897646,11601118,11078666,9956007,8889938,11314252,10492635,10359505,1187067,11030941,11602239,11019779,1046010,251276,1298426,629530,8265525,7122567,9027057,5067233,10475068,11620141,8196801,9022307,10630092,1676685,256007,10532989,3910919,5697,11378690,5079359,4338770,10060417,11593615,6378626,10550472,11652518,11619448,11556612,11644589,1088107,10617383,11654769,11388135,11654988,2999946,8107977,5181631,11656194,11656398,9145521,11500610,1218704,11659257,862288,7085315,8616760,11657627,8786375,2184517,10148688,9887329,11662815,5890981,6230304,9063139,10624591,9191947,8240510,10232932,11659532,11286307,7629588,5097539,11397331,7136123,3426338,5824843,6075482,2886411,5318931,938126,10863369,7186129,11672569,11673206,8836365,6456586,9167585,11676466,11012175,9992341,3362420,3610141,10028014,10987027,11676567,10853066,11678191,4044412,11673163,968707,6180444,6025994,9414906,9177337,272118,8049220,5799283,4185276,8374032,10305444,10184550,11240574,11633735,7294900,9051372,11271975,1424585,11100340,11584353,1402526,2965177,5418087,11684819,10497165,2403176,8318666,11161537,11692035,1541660,10161884,6722684,11688885,7083099,5847473,320726,5769506,11630864,5040440,7326457,1028039,11695862,11699339,9684149,4157305,7435733,4854204,11624789,4701558,11704986,11705111,3862378,11495073,2582137,11705780,11706226,11706946,2235468,9442142,9152764,4055506,8196066,11711003,7217963,11673062,10786450,10291120,11585779,830905,7117296,2486792,11603524,11287000,1596433,10999049,11717010,10913998,9999114,7002858,7389060,3112666,9648041,6871667,11719853,8286652,11257588,9825224,1811914,11234942,4359492,3412998,11725805,1418618,11311650,11728795,2986984,10512986,8964122,8157187,3074508,5593661,10989043,11733146,11666049,695498,6245314,8855010,3047822,9683118,11736110,4879929,10225537,8076618,2281101,1653998,11722678,5346054,10960095,11740191,11344294,11740576,9378230,523146,2939594,11742919,6326004,4107144,11720369,5980655,9288117,5565079,40868,9119869,6810253,9244795,11124934,2182900,10910863,9968553,9383084,4759182,10750643,7514722,10323425,10995842,11748395,9926715,3108768,6189601,11750051,11751737,10671200,11743156,11744890,2300299,11754644,4962322,11442062,2443145,8184342,2013954,2594392,11757986,7708168,11759265,16827,11760352,11723533,11637906,5486553,10488206,5304915,5675033,5675437,8809992,7355454,9909444,9815465,11559426,5381580,8440939,9057272,7938152,1841823,9756816,11771855,2840680,11216083,11617202,1029059,3592078,7582534,6584998,9433569,10779317,11776951,6539544,10370985,11781314,11782203,11782547,10670381,5960588,11663865,11778516,11784052,1151874,3670161,5955102,10435242,5005659,4059914,9515114,9158309,6202013,1282773,11791894,11738041,9467636,3293164,6583528,6660373,9820346,1552080,10640283,4602248,4305096,8262928,10852013,11793387,9548036,10555033,11795433,10610632,11797196,11688161,6150284,5636805,3929990,4087512,11800290,7097867,10109647,11802766,2979441,6757475,9636803,3375487,10491778,7636421,6651940,10987894,11806162,10309342,9819256,5836440,10310461,2369808,11799369,10155936,11799855,11325867,10817032,3577482,8238231,11812151,11661542,7253178,3233017,11813393,3678998,11814603,10846806,8860764,1130864,2119737,10464334,242042,7188099,10042533,9730327,11075181,8460904,11439936,8469236,3215929,5052008,11042994,4863700,11579989,10836364,10845015,11822605,5660086,11035850,1725377,6655005,6800513,11682975,9570526,10405895,5297307,6619979,1620746,10924889,9593249,10542491,11640471,9786129,9476917,11787970,6658209,11830581,11661915,11777557,10465707,9866504,2614225,10100642,3958643,11014800,6665916,11786923,7225485,9708904,7619260,5632865,609201,10963032,14817780,11822427,8419835,4060667,7934489,11646935,5620758,10932802,11150592,2862901,5556776,11628162,11843077,11843345,11799709,7899374,9174015,9047633,2449656,4788144,11846982,7314988,5709159,11848172,7151494,1812633,7158458,7023095,4281872,2256630,11066596,11768006,8014874,7683925,1257084,10756778,11855288,8374202,8313965,5427006,7662977,4743630,7601962,11862210,2533082,4306215,5655783,11866249,11634815,1594810,11766199,3462602,995033,10245723,2096683,11750318,3160007,9965966,9323635,7101842,1333320,6793637,11878340,8076386,4199776,6401782,11880659,11880728,11881166,11849187,10409093,6084964,11883580,8167026,1178000,8400129,8981716,11885056,11884978,6179988,8522675,11885423,10683888,11667210,7620783,6235363,713659,563231,11887829,4222629,10594994,1072825,8353611,11889240,11733309,6942861,7859769,10767572,9889218,11890291,8327468,11848917,1802225,9711734,11111174,11693343,4582220,8354083,1938107,8796244,11895332,7548175,11897287,9586740,7329742,11558108,8419823,8736236,11015597,7276107,11901970,10753968,3691980,828548,1448906,11907136,8596503,10522671,11909479,7156476,6209301,11073788,11110587,11912393,9875493,10937650,11794506,8860610,10076884,8508907,3831776,11837213,366064,11731851,7574729,11918459,11654569,1203511,11789229,11313121,8383236,6016143,11803676,212215,10820944,5627599,11593249,11919008,2514535,9074679,1706864,11409776,11153062,8897762,6719353,11813316,5113514,11931039,10944752,11931104,11221451,11037396,5386338,11854211,11633045,11933257,9886630,11934379,465509,6485674,6457374,9012487,11932885,11824543,1548432,3018377,11939297,11619839,2485292,10722739,9146784,3453041,11862956,8622829,7554407,11751646,11885530,11818138,9183824,707618,10912105,11947069,11940315,5112772,11890665,4450330,6025718,4402433,3305293,10839752,2358165,11169057,8449612,11010992,2957945,11431007,11886435,11954971,11955634,11633355,11958610,9948089,5302440,11812409,11961415,10623342,3805060,1884520,5994990,8256328,9773651,8020018,11966213,10190084,11968537,3403809,11732342,9305398,6678549,4416304,10115296,3252401,8185618,11683640,7026958,11794404,5954371,537566,7158603,2578962,11847170,11969942,2079418,7644243,11921418,9863446,11894839,10721563,10104839,10145167,11496631,1157368,9440732,10215770,2688207,11992637,5386006,7696590,6904782,5699679,11848625,3768552,1652327,11597637,9080200,7477522,11996459,11941232,11997358,10023966,4690023,2502091,9297539,12001628,9546732,12003447,10536169,7048409,9188188,11838115,3077801,9621700)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

fork query

edited may 25

created may 24 anonymous