SELECT u.Id AS UserId, u.CreationDate AS ProfileCreationD...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

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 (3347300,977203,3717289,4110681,384670,2775433,3253883,5524020,1371683,3093936,989692,5526034,4396280,2689119,400048,3030737,2827406,297042,2960092,5519022,481617,3185727,1976647,5502148,5457439,5516271,5518959,171846,4260704,4693428,5530127,1236254,4919289,2081579,5531599,4330555,5142761,3445571,4723960,4160889,4480139,468896,5535144,5204481,5537289,5335054,3989673,5537316,5234642,4333992,5492321,3728995,654116,1380279,5428769,2058548,386338,2852568,4959471,5474407,5536366,3425451,5425698,4775675,4189299,3934445,5442466,4431839,5325381,4320131,1044650,4095942,3019024,5043280,3478959,5451437,1446091,688830,3043837,4622067,3457684,5545581,30900,4069616,5533124,2847781,5178298,5542531,1162978,5546717,5520728,4930328,5542746,5334460,4754875,3126139,5548246,191741,5537586,4603889,5371505,966823,4958037,4690683,916330,5552193,3100727,2624217,3670974,2936391,3545295,2860044,752102,4242304,5281930,5151362,712600,5126637,5557078,5557254,583028,3697365,2157055,4514936,1633204,3867787,5473307,1184054,1009994,5560981,5560976,5305938,2789351,3401058,2559085,1487547,4988247,1840348,5020728,3128359,5395136,5564198,4346545,5019879,3088349,2446799,5565520,1267466,5565852,1965994,72958,4249780,5471785,362158,5500613,2283642,1186023,4073891,2232432,2949071,1732772,1115277,4567228,4242821,5545481,3309701,3584034,3597797,4533946,4799193,3356508,5179909,1376556,1681580,5575858,2975743,3956460,2181614,1060408,1003886,4010683,922249,4538066,3871681,5189705,5580004,1085805,1086147,1473616,4030934,3472690,3895373,3847021,3670010,4835435,1940679,5131819,5467261,5565810,5584700,5584686,5191247,2178112,5585034,3506972,2115093,2290639,4838284,5398244,1915161,5586736,2965107,5587380,4801797,971382,3654181,5587187,5587646,3280809,5588344,4051559,3490546,4385141,3465049,5451071,5588128,5255611,4255081,2716069,4555644,3098364,3762311,4776729,5590439,1655025,3808059,4689991,5592045,5369950,4852614,5593072,5385006,577061,4971297,4048945,4368610,4727011,5005610,5596002,4871749,633958,3859419,5409060,5524625,2970104,1030436,5503796,5113478,2582298,2092844,2276080,5599268,5599388,5422034,4159081,5600708,5603105,5594539,5528751,4712199,2544222,5606206,5457693,2955702,4159447,5357260,3512779,5608320,5608472,4389984,3735010,2308211,5596030,5511339,5609980,4010409,4683464,1688414,205696,5192982,2468143,5062972,3232446,5379206,4457539,4889412,5042886,4799969,4127946,5608432,5615585,1667423,5615540,2225753,5607552,1374420,2125973,5564469,4004657,4176313,4576408,5574107,4692826,3633687,1882612,4391643,3158749,2991828,4944076,3240152,2840794,3512832,699814,5059201,2838606,5622964,206466,4808933,5553181,4112672,5625626,3670387,5626211,2804297,1858013,5479963,5627276,3949611,5225747,5627843,4178170,5628601,1919641,5402747,4250417,3411436,5629714,458130,5631360,5631659,4133947,5632628,4156550,5632914,851182,4169943,863967,5436054,5160,5533645,5635449,4072706,5590445,4460287,5134819,5514026,5637124,2312672,5295116,4687685,5761254,11545,1332148,5641603,5429777,5639696,2020476,2037446,4849556,4102300,5594698,3411238,3976714,5644153,3616026,4604142,4853571,395857,1997062,5218277,4765690,3357318,610084,4369971,4571036,4985092,1548486,2793771,987889,5265642,2175208,1830756,5652990,4517493,3431946,3267939,4933533,2333421,5556589,5423668,5363840,4332555,3609976,730366,5517049,1306892,1815190,5442874,2354783,5651619,5562500,4564746,5657257,5657655,5658938,5654154,4450941,5660223,4559315,3977383,5660975,1690108,5641777,5661389,4931763,5660877,1903674,3721335,680,1819452,3809938,4770099,3490850,5665408,4620080,1833218,5665647,4308646,604388,1055637,3141240,5645641,1789097,5455373,2335246,1924308,5649278,5667764,5668339,1250977,5211345,5646977,2910074,4891910,4687224,5025261,4241498,3119875,3433489,2076774,5569713,3765319,4864253,5471347,5478552,2196985,3838430,1950274,5673275,1988693,79891,5674955,3703199,4664790,1787331,5255596,5322822,5675786,5676462,3080362,5016201,2278394,3336204,1923833,4798562,1172155,3610508,3621898,1849188,5666138,4951106,5505723,4648386,1309431,4713868,2724910,5681936,3618643,3068684,2622146,2127826,1214547,3007265,3367369,5683968,5568111,3209478,5657695,147075,5634086,5686495,4496060,5138726,5583602,2521118,3660066,1771712,4262568,5691031,2349589,2441401,5577495,5604831,2752185,2824448,652101,5692145,4227232,2200497,2741079,5692285,2998084,5420052,2515724,1061430,656592,4856683,4575945,5696632,4754011,3308310,5640318,792613,5213448,5698050,5698134,5530736,5693739,5698779,5367377,4805219,3010682,4480868,3467,4325010,5618473,986184,5700895,3512854,5702031,3413586,5702696,5702749,148962,2419960,5453134,1058323,2802911,5704636,5704834,1058541,5683579,5704953,3421980,2963099,4289529,2842549,1367462,4773966,2366125,4142251,5021401,1564252,1163561,5608223,5709813,104775,3529642,2916610,5710820,5543084,1608705,1377912,188081,3979290,1671269,5709239,1898842,4415245,5715071,5310795,5328805,5211467,5707568,5716216,2159301,5617603,5589194,3128926,5451765,5701053,5718597,5718648,5426661,5719646,5362886,2992191,4347691,3830367,5720148,5370850,5340808,3389585,2369865,1422163,3973851,2676680,3940690,4483695,1464191,4991888,4493265,5715402,3314476,416972,4474740,4147379,1248377,3093561,3387122,5727427,4736423,5234667,4464570,2754673,867073,5728440,2209232,3288645,5729080,5263943,4528786,4690466,4550110,5731511,5729960,85248,5704734,2489327,5570970,968149,152122,2137680,3184968,268075,4272816,4414765,5252003,5512856,1494637,4595030,5581182,5705883,5635159,3419487,3580621,2927983,5736799,3053195,4019986,2623793,2508770,5732119,1848109,5738873,3723306,5739024,5212963,5627010,4317138,5740429,5740962,4602561,5741495,3349443,5741913,5210362,3041068,3902701,171433,2018509,5743569,4795693,5612092,5741536,4233809,5745142,5216360,2293877,5734818,4068257,2424026,5747400,3519842,3580785,3552561,4308,5119420,5442654,5748822,1167086,4357557,4936024,4563044,5749173,4606939,557534,5506141,4307646,1699651,5371821,5649575,5751316,1313793,5686221,5008381,2737316,1299853,5143860,3961271,2514250,1121150,5641978,5403884,5091537,4521495,5419668,4425123,5521525,1041110,1044858,5542954,5759429,214849,4037927,2476920,1323607,3424212,5689425,5760984,5372815,3285575,5658306,4809777,786238,3821872,5763817,4417490,2979741,3466508,5685150,5765300,845532,5642643,5406725,5332464,5767493,4289592,4906746,491708,5770221,5085347,3475799,3734222,4720383,2093984,2086449,5726453,5480179,2113996,2179427,4686933,553766,1894566,4888655,1995613,5703564,3908919,3350284,1538290,4049331,3478500,2035884,3709678,3032469,5222061,2205404,22404,4562395,2374138,1654519,5605294,1406016,873472,3581485,4447390,331785,3383318,5785691,756809,2045016,3681265,5498857,5788762,1664599,2467747,1945881,1315897,2987400,1562764,5300521,4458792,5792520,4035478,5792707,5793086,1702343,5793521,5793913,5794097,5794378,1683902,5793714,1610950,2783836,4454299,1937872,3443889,5678778,1194167,5387592,766708,5789103,4232462,485058,2315997,3703079,3858260,4256498,3370070,3821012,5800752,3921848,5786150,1315320,3696238,5708952,4820266,4225081,5078465,2609301,1662258,374358,792699,2983568,3209681,5806666,4725622,5725479,4110915,1976453,404099,3187217,999329,5719967,1097977,5778697,4341456,2303594,5813907,5611065,5808787,5814350,5678299,2138562,5814122,5812744,2270563,1494214,955693,4444135,5334433,2851704,3861804,5290534,4250464,4851633,4857033,5819066,5735573,4168044,4283997,2760433,5212827,2807723,5301167,2338595,3257288,2268721,5808574,5806689,1430655,4434960,5823771,5823890,5824046,3561871,5812696,5761392,3725989,5547342,508654,3919542,1347008,3240902,5827167,1125315,3587075,1658328,3417476,5578439,5828815,4068013,721768,4345946,5111439,5484133,4644882,3910269,4703273,5831074,5603891,5434336,1958219,918417,5779007,3484350,5484626,5834095,4783222,5401890,747371,5831456,2096048,250917,806620,5822162,2980246,3313834,5839326,2825656,4589803,5377424,5537307,5834548,4283850,3883621,2471256,714733,5697891,5254941,5376316,5817405,5843098,5166145,1266985,5162964,4734410,5287832,5071951,5828098,1970053,1342006,2882619,3596212,5604430,5666011,4337643,5795333,5848297,5848940,4534743,3669730,876325,5120502,5383066,4548474,304957,4544662,5798015,4534183,5603856,1023638,1803526,1677045,2922909,3738680,5537065,3179537,5646563,4753072,2155789,5539115,2015911,5177763,3723031,4450717,1762276,2116712,5390159,5860391,2670818,3146132,475673,5543269,989275,5408344,2503185,5207198,5862967,5806095,4910386,5348256,5430228,1055323,5865593,5723441,5865725,364429,783608,5866885,2807083,1706058,1887101,3810333,4821890,5786999,5777317,5046537,4464936,5872090,2318926,5452994,4471121,991559,1227860,5079019,1507325,2644170,4078249,5378022,540154,1567340,4169892,5873177,4866484,1389110,3779140,5878975,4453433,388033,2645833,5334582,4665670,4617233,4862881,5881850,5881886,3979148,4049851,3410400,5080709,3470496,1621907,975798,1431711,3252512,5857263,4591604,5700376,3285138,5094035,5809511,4309225,2288848,5890415,5891939,2111986,5833849,1779743,5892993,4557803,5893560,5613914,5893877,589601,5894034,5515093,5894074,1939803,5668727,5289784,3112936,656804,3680874,2535518,3610183,4097118,5719671,83501,5765904,5868082,1041639,3578521,5325333,5183217,5097561,5711256,1643465,5899439,5899128,5518272,5374541,3267920,931760,2647475,4472674,5463060,5635959,2075651,3533365,2128723,3518613,5903094,742775,4320915,5903797,913167,5082337,5905707,5692838,5419139,2010369,5865569,1998316,3704054,2861459,3426125,190467,4767895,5908487,3530081,5173258,1875682,2118055,2148845,1998248,4417088,5910046,5901486,4810850,5755324,3492125,4186862,2571738,5609462,2613774,5801970,1284262,585617,5915149,5915165,5802410,5915607,3909898,4942417,3421913,4289170,3839756,5775567,5917053,4261776,5906448,184379,2567859,5795727,2948844,5920325,5364226,4658613,5920900,5922118,4994312,5551979,1423320,5921662,5923091,3904168,5838859,5807440,5920674,2326911,2209904,5924068,5356747,4257569,2468113,1171845,5600745,2379736,5587990,5818969,5928165,1354784,4888150,5929278,3052382,5584661,2361573,5930328,5635993,5930930,1403546,505990,1421553,5931809,2056180,5040972,1599117,5875837,3342823,5593968,3604973,4064675,5786339,4863925,3247800,3721259,1053944,5938759,4432916,4877405,1113063,3814267,550471,5917581,3005903,5857949,3603502,4980397,5520747,3846175,4819485,4442850,865188,4516171,5067835,5941309,1435711,5429585,5468068,5937050,204693,5925085,3522401,2560641,1848489,5763459,2287611,1644261,2913563,5949599,2645857,1120186,5480995,3466052,1697459,3993731,5342566,5731488,5945674,120541,5520173,5562385,5132826,1990758,5452648,3058029,5958541,2191979,5433168,5958900,3375135,1926615,5875620,5959746,5510623,5738194,5923537,495745,5961741,1786107,5962668,5251962,5699025,2500161,2397327,4995940,2777454,4809113,5591643,1221244,3589054,62245,5334741,4975177,5637605,5492296,1449565,4446818,4111612,5406239,5685655,5973064,5134102,5742524,5799850,5930645,5118165,5147701,5810332,4417685,3765278,2011802,805420,2862231,3813522,3748498,2525633,280980,2971795,3104485,2016319,4283749,5859124,5234940,3576946,5809690,3176705,1218087,4474068,5945396,3354384,2310408,3062391,4852771,3280538,2274819,1447908,4854766,2534357,4722773,3810748,1313296,2988569,5450006,4334730,3087783,4642046,386703,1059036,4804346,5977597,1330394,5879405,5267743,5870537,4051719,4378582,4047104,5989894,1583225,5256207,1391625,1751578,5634263,5212693,4954433,4199313,4778627,1160997,3810906,5992771,4348372,2210667,4569326,5877891,5978527,5993758,5969526,5820788,1414786,1178689,897709,4236377,5570924,3696632,3302563,5794622,931036,5842755,188002,3981789,4444452,3078129,1238392,3765806,2363393,2000124,4139651,4679727,2188396,4716488,5201562,3964789,1347796,517558,3918612,5852162,6003911,1013393,970312,6004516,5556298,6004945,2655975,3804906,5956841,2727444,3289157,2322576,5982633,2271492,1719885,5931026,5974722,5807810,2954587,1713185,6010463,2311141,5936627,5047467,6011203,6011157,2180139,6007960,3961641,6012637,4444110,5816334,2246127,3882859,1937681,579692,5053187,6015873,907921,4668550,6016666,6016500,5413116,5596281,5353877,6017789,6017946,2572010,4544687,5476045,4178623,4522447,5961091,5943025,4946819,5311083,5875420,5948804,1787841,1692706,4037348,1078521,1789782,1909485,5655880,3071234,6023926,5471063,6024120,3453023,1354649,2859238,1666547,3975668,6019943,1896016,4187181,6027178,3521918,1231230,6025132,6027860,6018646,882697,4788605,1131491,6029558,1133766,2954187,6031904,5395342,5916927,6032460,2857014,2768797,5486389,6033784,5591105,765965,6034295,5379533,1925037,3750918,1644186,6035099,2294360,832218,5380027,4691279,2998050,2316672,5963434,5899836,5908322,3910195,2045668,1653693,2220500,3749797,5370788,6041579,5844092,5758649,1113108,1334774,6044446,4838189,3841581,699606,6045737,6045903,2443944,5881274,2572994,2996407,6047238,3211391,4524425,6002782,5076218,6045605,1068947,6049611,6049460,6049680,5571531,522382,6033440,3780573,4375888,5748878,3546827,1163723,6053406,6054279,6054522,1121002,5284162,5426743,5382192,1748640,5565684,4749675,4246446,6053440,2255071,2543622,4811421,4391911,6020796,6056453,4936657,5346311,5445318,5818618,4629038,875527,4913732,5976002,5757546,5932451,5960542,1015608,1513629,5209693,638041,4481947,6056435,3211736,2090166,5906882,2134466,1504247,5016460,2296609,5859170,2731314,1609428,6065249,3453182,5987506,6066747,5671816,5017928,4031604,2863665,6068023,5143361,3150206,6069434,2173372,6069583,226142,5326558,5735500,4364321,1581229,5538060,6072010,4015449,6064431,4177774,4195013,5293837,5463160,3293881,3608005,5117502,6073931,258834,208808,6074973,736808,4040423,6076169,6063478,5618524,5679221,3453250,5714544,4280848,5936817,1397262,798076,6081064,6081342,474819,4661264,6082315,448145,4502433,3746784,4644843,6047579,4387251,6086133,6084262,5881795,5632162,986711,4892753,5374123,2697831,1425689,6090597,6060412,4887279,2708608,1388597,5052149,1926708,3399063,4163955,6070997,2529428,1134753,4134881,2017550,3573403,4973720,3786485,1397218,5671313,4969045,1915547,981497,69433,1764881,779444,6053019,6101186,5984107,5807749,4382098,5435868,342882,3426308,1185254,108374,1565050,6104994,4809390,1234623,6105582,1760339,982824,6106675,3785114,5413035,1467926,5636283,3230694,147673,442542,5729511,4696268,2029602,6110898,6111193,1520277,562697,5464787,2543577,3568904,4773996,2271641,392589,3940080,6007803,3148448,4404190,6115660,5565497,3811872,2781271,6024751,3879955,1726997,4598704,5326103,2481961,4856774,6116921,5027851,2866665,3927887,6118707,6118725,5484771,5311984,5698517,4733282,2544036,6119068,6120230,5235069,5432982,5635270,5736484,5993216,4044816,2927848,5715121,2181263,6088363,4541624,6123785,5873937,2804820,5865871,5853072,1246159,6125722,5244870,449007,6091165,4888649,6118100,6127250,5315802,5271376,1567205,5523649,3925648,1119250,5666098,6131901,5006639,6132185,6023578,3064609,6129822,6033840,3136936,1007084,5901578,6135157,303612,2278623,1039545,98692,5953206,6126838,2247550,447023,3505167,2522688,2581720,6041774,5467973,6057744,6139941,3663875,4247599,3335514,4557453,5986981,6140618,4190713,2105563,6100888,3880038,769262,4658174,1307974,3424452,5511389,3963900,5431681,6043858,2500952,5808083,6145984,4541374,6146036,4315619,2924421,5859798,4910495,3800106,5537977,6147822,4790948,1616948,1314508,1674908,2800591,5802069,232416,4439956,6152440,4404777,6148321,1431308,3903827,6148179,6155110,4694807,2920614,6155861,1256821,6156992,5075026,653724,335713,6076911,5964750,5525590,673526,4133641,5626605,4415329,1780284,126357,1140338,5237917,6109654,1660325,5090110,6161785,5495976,5649016,6163364,6163519,2655623,4309730,3609407,1727703,6006801,5686597,5308185,4365003,4027853,4605629,1268104,1475161,5041806,5776868,99904,5486321,6169961,3825755,6171441,3890386,2675431,1773534,6172086,6172067,1064923,3067055,5721368,5873843,4930231,2301185,5338119,4811897,1219368,4932340,6174669,5793675,6174953,5208349,6175353,5349222,6176794,6155111,6169899,6014659,2612941,3238231,1229490,3735796,3709199,5822535,2748984,4126542,6159584,3343130,6182995,552450,3912849,4721115,5667136,725009,1043761,1763461,1395973,4118839,4220821,1179689,1837779,6188323,573240,1845654,5896372,4003747,4198218,6190279,884447,6190401,4267929,1037405,5925259,5289692,5640201,610668,6194204,6069572,4775738,6161932,708221,3517480,985030,4318128,6196575,6196861,834219,3898725,6133130,5281179,2884046,1331036,5453843,5962391,5380901,4791829,5111794,6142109,1688698,1901458,5006939,4332304,6201231,6164065,1440861,3220901,5999533,6202258,6202899,4482493,694417,6100314,4253317,5856591,4882506,2457160,4805056,1496972,6169238,6206039,2900738,1860030,5434226,5377667,6206602,4689558,905791,62361,1872168,4202134,5948671,4832048,5590985,1092663,6115510,6180587,6158158,5329657,6119465,4817828,5885293,1355185,5231637,2508818,4960325,2080298,5883971,4158375,1915274,5549107,5681020,2450382,1698273,6205029,5767600,4567996,5403074,1421381,2165601,5331502,1828637,3613500,6206106,6216991,5455538,6080346,2179965,4206467,6057824,5216445,3610381,4239526,5812436,5915915,4006969,4551832,4600588,3294894,2004860,6207778,6222540,6223957,5349584,5581369,2343439,227927,5445025,6227205,4225383,5222040,2997109,6004936,2128168,1526773,1350852,6229649,4969588,1875256,6217355,1046657,1462283,6214125,4421872,1777820,6232189,6208900,5833954,6233475,6233040,6015888,6218704,1020139,4375452,4611027,6235321,1087370,6235841,6235899,3150947,4597827,3489985,5502471,1614478,539465,2722870,2783317,2401255,6238234,6149402,2217749,6091897,5604013,5343235,6153537,4937528,6244804,3083031,6245130,6206043,5681765,5650012,6085968,1852752,4602856,3281844,6179448,4486167,5325354,6030639,4495233,4159566,4282756,6247790,5970267,2419382,6138470,4766749,5339325,4918756,5624879,6134744,1334073,5675147,5743976,5454620,2012314,1871717,2747265,5771655,2754623,866631,5893834,4350573,572769,6255239,2987285,4445781,5302690,3974475,395028,6089806,4552363,4819945,6258531,6168841,4096377,6259416,2682200,5474722,6260003,1682761,294737,5080347,4945494,3553826,2142422,629019,6263999,5194977,5808291,6249179,1549192,5368173,613960,6266112,6266172,5633356,2814057,5839456,3024933,5839090,6269024,6268796,5159029,6269921,1936325,5959720,5716176,5963569,5663886,6100438,1662033,1988021,6272406,6272636,6272824,2050637,5699447,64911,6273646,1122270,6274426,2623004,1183628,6179704,6275089,6275216,6263517,2291632,5694480,3413468,6026573,3716478,5998892,5741664,1451346,4820655,3772876,1059328,4695605,3558819,4068338,1516220,1225744,5529322,1514225,2970979,6265160,5836291,5698871,4975918,6282795,5824118,1560570,5110843,6271126,5931445,4100574,6235738,6287647,1938803,6031804,6275167,3758556,6289193,1776367,6289633,3984824,5704842,6260873,6290841,1460448,5948280,5087599,5141702,6292205,1676147,3667089,5174379,6293954,6293905,1220493,4457024,6278657,1863415,6296332,5752030,6292850,1149566,5931754,5554185,2252182,421121,6298662,5264680,6227680,2870687,4112136,6300205,1031218,4007642,1663898,1300035,6301898,2900791,5183439,6201755,5922935,2392664,3897212,358121,6059114,5612956,6281308,5133042,1453536,2817266,6305143,3337688,5608965,3102952,4677126,5723681,6092804,5994334,6308448,434551,1662372,1293013,6250837,5708022,2174726,2824115,5875389,4250120,6312207,5307098,3403621,5975905,5995917,3928184,5216720,1470957,5540504,6271800,6166748,5424335,4469336,4194446,1461309,5896179,6190440,5748193,531984,1293039,5874704,1833723,5875839,6319249,6100903,6308369,2848117,462047,6322176,1642344,2419274,790387,1587003,6012315,4439369,3629229,3766751,2736367,1729795,785048,5572712,2974780,5080246,93191,2900138,1263578,6310968,3100538,1566194,821720,4348401,6278150,1291637,4808582,6150378,5885795,4833933,5787287,4399146,6144802,6332613,6332563,6332893,5031518,5639756,3592564,6334244,4057790,6335454,1476297,6335190,6255040,5552503,2913347,6139704,6336375,4221970,5816046,4950126,4596616,2819871,6336503,6256797,6337613,1209159,4764408,6338771,4818853,5041408,3883263,1721571,5959512,4442140,3558559,6268892,6340814,3215799,1551801,6343089,5325696,5535593,6318580,1185474,6051922,383264,6270653,6228073,6345383,6345930,1068889,2331649,1802693,6349474,2530921,1064171,6310851,3826468,1021675,5594372,6240872,1251950,6352986,4450986,2326449,6356271,6301319,1845974,5525271,5799481,6356678,2277225,6130456,886393,3722415,5477126,4309118,6059780,4976737,4729166,2275956,5956880,2293464,1982536,4367371,4270890,3040695,5721482,5905790,5884558,625114,6364295,4515030,2537335,5909776,6345958,2626000,5473669,6356251,6363013,6365534,6088672,6161315,2269968,6335101,3922976,6286298,2270993,6265623,5943956,6358810,6369074,5400394,6369897,1912227,6355502,857194,2343952,6351449,4987285,6022281,6044359,4696152,4380945,5914359,4621142,499567,1209583,5400415,6375291,930734,6166262,1303432,4965021,5360005,6326005,4467714,6035548,3817390,3639557,2900872,5400814,5161414,448810,5033662,6381800,641887,6218072,4331291,6318208,5032190,6301990,3220762,2302651,3671879,6379884,4928269,1613383,1343979,3579033,267719,5244942,6387220,6387618,5182362,3975247,1319147,5817580,6255958,2935870,6202499,1448001,433814,4928430,2826871,3954500,4446574,6102255,6372236,5419846,6394549,5627951,6394645,2728105,1004737,6349517,4678628,5252562,3951920,1802974,4695752,1892348,5502785,6242642,6398576,5384810,6212717,5640802,5429050,3397298,5040228,3416349,3394132,6181297,6401285,6180055,5441932,1972074,5870331,6015236,5511209,1427663,4670315,1051671,993325,4682839,6405595,6405662,3885512,1519523,6292802,6406697,3216976,6408199,6389707,2511404,3033296,6408999,4834736,249615,3132103,3380102,1295561,3756824,4979733,6392465,6367882,28324,6413766,2999349,6414604,5615653,5854402,1638938,6145247,6165798,4451095,6417069,461319,4640238,5651542,2826194,3188750,6406318,6420471,1888722,2031025,5879036,5449456,4183666,861795,6310668,4459595,1851977,3177536,1461078,2829044,5012509,5355995,6105278,1827903,5889127,4336119,2871096,1948834,2316641,6096847,3106011,6428235,3104022,3933629,1122463,6429161,6429527,5735820,6361393,612192,819330,6430896,3464212,6352108,4213264,6268780,6126498,6433076,5923757,6433660,6393309,2965000,1574221,105445,3217457,6360994,2817183,3895858,2034787,887669,468725,4314069,6380370,1566626,3157855,1028589,5284728,2146703,2386083,6442308,4077004,227426,5834219,1189783,3706900,4894383,6313962,6167336,6083015,6442547,5422891,6292114,6447021,2230844,5059083,6157197,4101364,6449275,2322754,6019603,5720821,1905944,6185262,6251867,4477680,6452837,6453117,4700433,6382885,1435820,6443967,3586112,5665568,4542928,6453684,6453688,4135691,3832655,4471085,320460,6454387,1121167,4858874,2562647,5731947,6299918,1211620,1659543,6459854,2633803,6212875,2879626,2783871,6300197,3086956,6461582,4608513,6436577,6423291,6461915,4333793,314548,5160493,5085064,6439229,2515354,5666386,5984363,4756320,4842671,5545130,4440692,3349850,4312349,4502212,1967800,6419764,3583842,1338194,6175308,3612949,6470191,4388512,3037747,6470607,6441594,5117173,2789717,4039881,2455730,4344140,5343790,6383930,6207849,6405628,3273885,3055219,6475454,5331493,6450390,6451754,2962328,6189524,5131950,6411982,3203246,1807982,5441163,1790795,4832100,6279481,5410783,2387291,6185991,6301451,5658353,4215464,6367601,6453273,885318,2610955,1461837,5056575,3781180,2556555,3349545,5797188,316891,6486615,1999271,3671704,2131563,6487809,6477086,6488875,6488894,5504978,5404220,883572,1305706,4697411,6412468,5075122,1287593,6491416,1274169,6491893,1525147,3264821,5010944,6252815,6135922,1376887,6440073,6440702,5278806,630160,2778722,3845747,3099091,4498110,905938,1075186,5575169,6377200,1061968,6498993,6497101,1128088,6126386,4077611,6423458,6451565,2826926,3781614,6032836,3903329,5561898,5927986,2599052,635622,5670306,6117914,5811628,4807041,5389451,4545702,2006725,445908,3747241,6113211,4422996,5338469,6510197,4852706,4342786,6180200,5130114,3108967,5118821,1696972,3719857,6357360,3613919,4671881,3993997,2279116,3890625,3837778,5304320,5249647,4237181,5828950,6164460,5801126,2605262,4971970,6478284,6517682,6484617,6517863,6515846,2738994,5053357,6500243,5859331,5723000,3957774,6522297,6024047,4218036,1281658,6512773,1262566,6108030,6514486,6513313,1869059,6523686,3810313,4456192,6185089,6524489,5983092,6446837,6525145,6513717,6526162,3766172,5806196,1787919,2400333,5481074,3635680,6530664,6530905,3085644,4575328,3601158,5532582,4596596,3224218,4114093,4777353,6466880,5686452,6473096,6243597,6533974,565283,2354117,4411615,6375025,112795,5371224,2951367,6284997,4933747,6488203,1951387,1088373,6496762,3990858,5757964,6540081,6311311,1370834,6382244,4536207,6510497,1086109,3917540,6544004,1774391,6544473,6544803,5738485,6544922,5795475,6310620,6497083,4880023,6224885,2815551,2791336,1464780,6544850,6513520,5231043,6547086,1640116,5975568,6539852,6094393,6552506,5456160,6553165,6063,6548351,3821783,6090490,3707607,2878241,2507028,5084994,3323733,4062881,6555716,5854239,2527680,5330175,4337437,5867869,6206263,5364202,4837377,6549656,1191068,5803538,3990767,3738813,1488207,4574306,5655414,3808882,6531726,2939850,3234803,1483663,6560487,5124697,5714638,6495460)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results