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 (6566449,4001804,66051,3957314,5303992,6568451,6120970,2122201,3814829,438581,4952130,3719755,6034456,6536676,3170141,543913,5003309,6572729,5875023,6573045,1517782,6418841,6575676,6186703,1676032,5562814,3856609,4133062,3336062,4260166,6579298,6549963,1957167,6581027,1164012,637987,6582671,6583452,4744624,3388684,6585384,4674337,6448088,6586626,420156,6347799,5793208,6587243,6544527,4601554,6303121,5541599,2398705,6495072,1348438,6529181,2997021,6056985,6591022,2624896,2057414,4806247,6591916,1181387,6579048,6592523,6592920,6310441,6593882,5088152,4124087,4805737,6440793,508175,6146749,6564494,2100058,144140,5071195,6484130,5501963,6483314,4795896,6597333,4817704,6568758,3096837,3870545,6497131,2287486,5288867,4920189,6571958,6600260,3087952,3697536,3827970,5755872,6325358,6278404,6602374,5867542,4110709,5299823,1427397,5407699,5022032,6433447,1672161,5072964,3046322,6608212,645924,6574959,6608597,4720030,4264267,2957677,2741060,6611044,5880405,4379456,5639688,9447110,6580781,4551608,1297364,6275562,6448607,4028271,1434693,310487,432358,6615860,6616149,1125649,6616932,5697437,2726596,3510043,4716794,6598248,2198457,6619877,2641059,2216720,5858557,519531,2159739,6428796,1379613,5033983,1206117,6622314,414939,4345348,2805305,5603956,6626038,2297484,4380967,5612301,3671969,4290581,3529205,5922300,2893839,2812721,3858162,6353181,2193049,5148363,6258866,2714568,6631902,4799172,1841181,2175897,4738027,2202989,4698846,6312037,6633503,2855675,5666810,2482570,2894720,1112259,6538621,4982754,6549517,5359586,3623808,6639288,980296,6639991,6564138,3960034,1195412,3271237,3749393,2950135,1914263,3136323,3477651,6184193,5674163,3864475,2752305,5039939,3015986,2251420,5736091,6649323,5679662,6639877,2415272,6650660,6650857,5687779,3484538,2232367,4907247,3518291,4699617,5446219,4653451,6381121,6654469,6655142,2359561,6041062,4646968,5770965,3015449,5545287,556899,798879,604114,2488540,6057372,4685152,6659226,6634260,5851595,5711393,4448549,1291716,4483094,2562552,6659790,3733989,6660929,4499252,1755265,6033643,2462759,3313367,3894761,6663289,1797738,4723732,4051653,1494754,5722159,5190208,5563414,1475478,1112283,2670216,6626012,6669091,3845851,6117559,3781974,6671748,6671955,6672764,6673006,5432806,6649635,3801980,6673674,2167332,979102,6606312,6498121,6676982,6663521,6593081,4654001,6148543,5352633,5021010,2173983,3777390,4580217,2217057,1694918,2967857,2193738,6681001,6681006,5531628,6681747,4129592,5271506,5301852,4513969,3644960,4660229,4484294,4065216,5863101,6685332,3526204,84196,6623284,1004589,6208741,907897,6687375,6623277,1210814,4666023,6688528,6143363,1710784,5486078,1381750,2516551,4998243,484489,6692138,6692472,1281826,4434808,5253595,6668271,4569506,300978,3493239,1984974,2625772,3687426,6469077,6059393,4244759,5082720,6696339,5966230,1866183,6697168,5039933,5672345,221802,1518555,6113094,5361456,6394122,4033658,1212028,1579605,5755122,3671995,6661574,2700914,1636521,5831538,3845853,1204843,6704094,5640575,6704356,696492,3370533,5675164,949374,3873220,6707071,6670067,2717128,6602112,5640663,6709407,2133814,4578091,265570,3002339,4681729,4159570,5503451,222529,6685889,6713337,3976647,6138589,6714455,3101139,5769812,5651579,6018898,4731101,6716226,2155399,3585463,6524161,1246275,1192542,6718710,6716030,6667934,5866424,5921058,1519716,5653538,2765757,4315420,3133604,1388943,4285532,499839,4857132,6723319,5055936,3492180,3956711,181406,2141344,5860784,4870827,6726946,1682131,5112446,6317210,2859991,4745008,361762,4277360,3298823,2758198,1270058,4922211,5291308,6673688,6732182,6563384,802365,3214987,499200,5589613,1778038,5917087,5289209,5945712,2438177,1932934,6226567,5186897,2203108,2646526,3304903,700998,6411816,6395151,5094841,1025691,2568851,1869531,4723282,5041684,1280289,4390961,2540331,3943306,4194025,1303478,6129636,6744815,6744920,4897034,6718785,1312320,5851098,4496671,3187901,1292212,6747333,1475297,6526901,1868478,3218438,6077021,6663632,4882196,6365587,3080189,5529403,5896888,1820644,1739008,89851,4749297,6753972,1094119,5978953,6416033,3898160,5533301,890815,2259187,836087,1118347,2457485,1090051,6761403,6078959,3527398,533738,4037364,6763600,6764555,3683029,4359986,2154768,6765132,6529874,3526271,3148807,6765929,2885559,1467941,6389660,2828480,6085786,488539,5164079,264632,862948,680519,3127121,800056,409315,6334309,360144,2281318,6768362,6664895,5853521,4135581,6771779,6320717,1782765,846316,6773814,5016432,885650,6775340,3324670,6776546,6776849,3677652,5875680,4299348,2478195,6777965,4690320,817019,3476147,6779366,3902100,1268003,6781312,2000189,4199253,6782484,2258406,6783344,1559401,261239,5828320,6386155,6629073,4772588,5313508,2957232,2019549,5697037,6097842,5955399,2294667,6761168,5546950,283837,3264049,5858564,1658072,5826932,1866177,6788579,6053599,5758666,6714635,6790227,6790321,1609367,5460458,6550904,2875005,2924453,3277533,998423,5156517,5378910,2204230,4113109,769771,6009002,5501198,2223579,6485510,6304205,6795607,6499773,3887183,4047127,6796831,5586782,5872512,6297414,5437543,6605781,6798623,6798873,3992990,6798176,5479258,6800934,6765548,1042090,6200418,6405419,6381778,6182503,4762159,2605112,3960140,3955586,2643602,857741,6805497,6498069,5610655,2747920,6447007,3429032,6607734,7586,6809242,6201072,5310630,1804549,6811375,6630454,2882541,6812321,6804026,6808710,6612896,6332958,1672027,6815238,2208726,698876,6791790,6816776,6816843,2039111,6426203,6364639,4171734,6287935,6515129,6819515,5908638,1423157,1560265,5480929,6367629,6625543,4631974,2888468,6186347,6822694,6501094,3865495,5913134,3824663,6567166,4792367,6824277,2212968,2673243,6819587,3198960,1995781,3292436,6825633,3239417,4589065,6285880,243919,2923413,6827269,5737116,6828207,6689201,6829274,2714606,1249519,6747174,6705114,6267843,5306524,5203407,6539416,1146713,4335937,1984039,3192795,1129682,1540501,544779,3377122,2968894,6600319,6836778,5904272,4457767,2368836,5214897,1688072,4247632,1809445,6272325,266198,6840953,335794,5304035,4812809,1267124,6672266,4261434,6844043,6844430,5706596,5642454,4873593,6603368,5314946,6788480,2461398,6785719,6567904,403360,6686229,6440904,6782587,678093,4657037,1787075,2869667,6849746,894028,5664573,6842950,5485334,1589440,5983936,5346470,6850694,1763641,4819186,5015683,5201757,3314925,4305712,3177669,6762188,574686,6609272,6026557,3292642,6853448,5765101,1274106,2262635,3366831,6723149,2593900,6416660,6787804,6558575,492642,6741497,6214911,1287480,4697754,6382903,5550721,2445413,6840957,5839942,5472865,2605210,762845,6860738,5558901,6595905,6858710,3833701,6862030,395785,196094,5640127,1298357,5015569,183662,901311,6788266,6866729,6448179,4351764,2259618,5075446,5849020,1462608,4808130,5847311,4390557,1809507,1384471,2080764,1634460,72075,2743833,1394953,3778989,3316461,5601039,4245098,3244583,6757245,1103412,6215521,6726592,1603055,6876228,6218571,5657298,6459111,4714326,4306556,5951401,2885231,1826041,1928597,6879608,6884569,5307233,4729700,1049521,6494804,6889099,6674404,6819145,329194,4836753,6750410,5606545,4256703,3170087,887420,6300005,5749801,1723606,3932908,6894717,6771384,5623302,2723850,4595474,4268081,6420605,6541687,5470135,2386710,4768284,3905554,2888098,3034718,6901151,6901161,1387713,6125751,6223328,6371447,4067986,4913451,1112324,6650275,4202314,6149787,6215571,1006915,4642234,5323344,6906493,6906979,5425438,1427340,3687068,4739919,1433483,5510530,1920178,3419726,6123349,6906863,5540253,2539562,6509205,1788656,6829310,6909617,6394099,4936150,4762075,4417545,6912196,3038741,6453996,4592081,6147506,5584148,2143819,1790412,5765771,4016131,6915585,3552844,1092688,6850282,6563592,3435610,6918211,6217203,5205157,6122034,5690845,6920367,6921171,6921221,3766079,5785319,1298499,74184,1398915,3435810,4625713,4013522,5176433,2410062,5773793,4363434,6926711,6731733,4960521,6928456,6775754,5348913,1241445,3814425,6473795,6930499,5859808,4358977,5753034,4617144,6335770,5947166,5655688,6836874,6557651,5419901,5986686,1298378,3077173,4312489,6495761,3291067,6156834,6935744,3647254,6932572,6937071,1064229,5365770,3853296,4215176,5174370,1639049,6756754,6536442,6939142,6325994,68231,3828443,2601512,6739178,5879215,3960850,5609686,990996,6654763,6543463,5807606,606730,6153683,6943697,3891339,3323253,5382318,6663801,1515517,6765759,3643303,6460344,5263639,6746211,6947518,6239732,4080911,6414606,4500441,5386290,6115144,5283978,2034811,510688,3079259,5730960,3672914,3561285,6820344,5876856,6952831,2110665,229860,3390213,4653045,6999324,3098299,7002388,4051982,6383960,5769707,5893331,4137194,4117061,5018591,6171804,3129183,202913,7008069,3795828,328161,4301248,6719911,4127481,5445329,5043548,6718260,2737948,6577070,5132207,7011596,6210978,6033289,6037103,7013914,2670775,4177142,6392876,5884319,7016058,1296554,4855780,5847849,5637738,5830067,1681681,6308215,4063770,4078549,1367658,3501476,4991509,7021137,5227232,4589702,5352025,7021545,6610601,3585557,1349340,4956567,1595380,5106032,3044500,6743588,6541601,4211173,6457193,6947703,4737001,162702,6166977,7027219,2407231,6832851,4717996,5240945,4471178,366658,3383301,4017816,4781985,6428488,7030073,4621047,6842543,6869232,900683,2258585,6379348,5416395,7031744,4531460,5241479,4018081,7034396,6291459,300037,4151472,7035529,6470235,3689186,7037392,5168204,6900329,6835437,6715681,4293755,3089214,1448063,7039917,2951933,2344024,6840794,5119700,2357956,6225259,2882881,4895482,2182650,6682602,4605946,1475412,1421332,4621508,3965778,2507710,6817276,6783387,6615901,7045869,5329913,6882497,3133418,4321796,1967496,4472627,7049773,1521679,6399069,4693190,2349358,2033252,7051056,3782306,6327246,7052479,312323,6437899,1735729,7052778,3286134,6133876,6797779,5287735,6776040,5709404,4697547,6846223,5568637,6693256,2316068,7055579,6264060,7055974,2099297,5738064,1371389,5232161,3079439,4035677,2321515,7059507,6069410,7060042,7060213,7060348,6904175,2953724,6449766,6950277,2301349,5739111,406896,7063093,5345612,523460,1126159,5417327,6023693,3080893,1280331,4866543,5462145,6667992,5852046,551588,6738072,1972493,2876105,2710160,4088652,4594620,2943957,6673991,1410512,2667686,1315480,3916445,5445380,6117337,6920968,3592609,6628655,2962678,6457404,5840353,7078390,3959613,4618880,7079573,3218482,6824513,6853584,6234263,2001229,4606294,6678309,6860052,3955593,6210705,5672740,6200146,490473,5759359,1695258,6310854,7085402,4950769,6855485,6804412,1159579,4805955,2909076,6222908,5452368,6833632,6446166,3663469,7075754,1476075,16582,7087119,7089962,3720307,4642090,7091126,7091569,6336921,4806970,7090281,7091492,6455328,6728958,6943839,7020118,5437864,5831212,6892783,6690664,6444586,5882886,7027736,5425530,4322363,2922968,1444227,1529127,4358721,3098768,7100940,2461808,547365,6164252,1642131,3969168,7101998,7102008,7101292,1830334,2881205,5335013,2364163,3496580,5961780,6515001,172729,4258909,3631118,6181189,1408193,5474700,1282310,3197684,5622743,4121134,3838142,4621761,5059058,2046408,271955,7110439,5487839,3511987,7111695,5642332,1382970,7066047,5194362,7113928,6293961,5887653,7116155,5080068,2300646,1833945,866716,7116388,3373381,7117586,385326,6216950,6450386,4388099,5240642,3745677,7106164,5265210,7106568,6365633,4383494,3699999,3720890,4856945,1680166,3259146,4499822,4279424,7123966,2102106,2136139,7123932,6681609,4649762,5042140,6205304,5729579,2788381,636625,4338301,7127433,6271086,5961999,6524336,7032678,5666965,4135151,6770116,4108345,7095230,5892825,7132609,6629474,6835952,3654508,7119534,6910269,826203,3250799,4237893,6773088,5421751,1968203,3373796,6671981,3556757,7137395,6638859,5411115,7137796,5423612,6625002,5282956,4350650,6914562,7126347,1729567,789213,4720710,7015346,6798113,6461020,152544,5464291,6168162,6365181,6942690,1592124,7090961,5233149,7091498,4878793,7147453,7147570,6445776,7027370,5619430,6366259,14467,6861864,4816518,580488,4707214,7149567,7149580,4348709,6539857,7150677,7117623,7150986,1362058,2868071,5157484,7011552,5666290,7144047,6839532,5910006,7152555,7148506,2489715,4532892,6092916,6023039,5129128,6567801,7050691,4002290,1039747,5478458,7135871,7097949,320881,6574982,3334020,4025983,7157311,3102599,4346687,7158216,5592286,4797414,3220058,6658389,4515743,2400257,132728,6069557,7160932,1779227,2777063,2491685,3521882,7162433,2388231,271760,5437611,7163292,5132876,6769622,4775890,6494594,3550480,7033940,7154237,5587436,71319,6232204,6870354,6775601,6298516,6845974,6758862,1670951,7168178,3008394,6673695,6200193,2123555,5505266,5036160,2924323,6067842,1658296,2992672,5255597,6362844,7002974,4110466,1061726,1159107,6885046,4299833,6613365,5655766,5422457,4216714,2426223,7122854,1525241,6745741,7181511,1826207,4055236,4449154,3547851,7183100,6437223,2958935,3549345,6666894,4140007,4226806,5456923,5282243,7185154,5042484,7185862,7186143,6645332,4607134,7185378,1080804,3850720,3588876,4234315,1901265,5890677,5025845,1603480,7188335,6375860,7158113,6103162,5559226,7190162,6722715,7064740,3579415,7116920,6597644,7191622,5260732,6376299,5304220,7192925,5512051,985296,7194862,4591251,4555249,6072681,5240026,7039444,7195989,5020064,6177883,4996365,5775668,6217526,5770664,1742659,7130124,5081479,5611897,6868910,5821508,4862250,2849016,4962172,2883338,3787248,6685357,7173069,5906523,5811234,6715147,7123262,6106321,7044494,781723,6944883,6162224,7202747,7202997,6064384,7203632,5990875,7206427,1457093,4511297,2296145,6275781,6055277,1377127,3123297,5609523,5920499,6688685,6382969,7207146,5017954,460825,6456319,7211349,5724435,6071971,245858,6279845,4230272,6698508,3624766,4659467,7064606,6516387,7210663,3757407,5325953,7216447,3490880,7217020,4275496,213042,6637405,7166684,5533954,7098881,7219999,7133051,7205698,7220875,7221031,5666899,7144327,4129494,4312730,7222532,770023,6595255,4380411,2376071,5645528,7224745,3807793,134824,7189967,6279535,7226886,5564574,5799790,6828504,7227963,6062551,7165757,482899,7229767,162414,5423850,6923832,7233997,3499258,4309485,2848854,6904573,878891,7214686,5990717,4712324,5625096,6589870,3049658,5050477,7237881,6312119,6604502,6492939,2447533,7090211,2164770,3937462,2965781,3409988,7241712,954721,7115761,3621464,2896045,7163625,5857223,2091951,7244189,6714426,117544,7242673,587406,5052772,5994596,5726823,5893128,1226568,977145,7247068,916142,2605604,7007558,1882526,5935291,5208406,7142899,7208610,7248408,784519,6220585,1185576,7198142,4773372,1170296,6418343,7252936,7253044,7202421,7231540,3605245,726872,1677264,2021647,6775681,7230090,2072444,1087908,6398129,2050155,514156,1228633,104969,6850627,521097,668624,6385598,7151892,6033855,7262258,7219948,7263116,3063482,7237823,759468,3757475,5826609,4532872,2635418,7266081,1223454,6593789,6349931,4982821,7266898,1459266,7269494,6094348,4422740,1823368,4819595,7273299,2198103,5696551,968270,7213670,7274562,7238873,3551483,7275794,1126238,7276018,2671940,1672429,4200867,7154103,7276435,7213402,7278326,7016410,6935339,757853,6744207,7281598,7281638,1129783,5740676,5893106,216112,5720167,7019069,3628270,6731604,4252837,7287619,5119275,7223566,5993854,5586995,5413522,1557119,5680950,5693597,2457744,7223246,757550,7294493,3658307,7169745,7195672,2567513,2333607,6783942,3907875,1666676,2010012,6018651,2924905,4368816,6711162,7299631,6902388,7301197,7301993,7276093,4780662,4165235,7214316,7303177,5615120,7115946,7304752,4740456,7203701,6244739,2394026,2682394,4960901,7246792,6054350,6021172,3422229,7085056,5672455,6543373,7298296,4425633,1136062,7311327,7032374,3058905,4034353,6949361,5832771,7114933,4749631,7312744,3322222,6183919,6245546,2208370,3880680,5660134,3827134,6191920,3244591,2837598,6208862,4441764,7317563,6906471,2075215,4058774,5387972,5679818,6527887,7319442,3786813,7108418,7320734,6890089,4138583,2805344,1344550,7324186,3776604,3682535,6460881,7114716,7193177,7326387,7152488,312896,3545596,746100,5184616,4363539,6913568,7328162,9431020,3591946,1297072,5902309,5404811,7330685,5711134,3083022,7331405,1250094,306155,7332300,408628,5756373,2439199,4930565,5740498,6941970,2360316,2810330,3830694,279218,5862813,7244579,6853939,2762432,6631944,2013403,7338587,7338507,839793,5526942,1277495,6354721,6099025,5234908,4554971,4102371,3007613,7212024,7268658,2707428,5323084,7341724,3822090,2662946,4437812,1957846,5121002,6535460,7229276,6531645,4312138,7131474,6372270,7312809,5431826,9642,6805169,4070124,7335557,5566910,7249456,2640105,6534957,3833985,5479704,4899308,634042,7184494,6516752,6880413,1245951,5009753,5389133,6903761,7314848,1002613,7035740,5571606,6650713,7355693,7120293,6144372,4397868,7125675,3887847,1454378,7358387,4657326,4194655,664806,7335194,5491023,5812330,5665302,6802375,5285232,7055379,7095330,7358887,3956909,6454857,6877651,7361100,6259193,962941,2562564,6443412,4578449,4916475,4875916,2758652,6870414,5730923,7366461,7363294,5433806,5446216,7368294,1693725,7285616,4662094,7369890,2191737,3809977,6242580,7234536,4591364,6618700,6775017,7361276,7365867,774907,3034415,7374720,5599580,4333199,7375043,4830524,7366369,4001432,6916919,2743956,6899309,7377131,6751599,6042739,6741013,6567153,7378292,2614378,7065051,5432234,7379284,6520579,3552459,1878788,6326429,1292914,4351817,2578823,2918227,2054279,6067158,5962961,6326148,4677943,7384122,6459626,3826115,7386160,6655725,3182733,7387044,7117360,993191,4140278,6805576,452414,6250385,6543956,6244640,6549309,7383498,2959325,5891398,6457176,5928534,7393401,7393665,4776477,5010286,6501116,6474793,7395676,598392,7396306,7396576,3002290,7399361,6401656,4597686,5244022,7371347,171520,7215450,6621346,766834,7163889,4934398,5562072,1055786,6474426,6146965,5700633,7406611,2631204,2028119,4558087,6181680,6910451,7154604,2298278,5058027,1408512,4667959,6485649,6813899,5117137,4031815,4396171,2564106,2226401,5051754,5427155,1693143,7414861,7415009,1973227,7126308,7415768,6944972,4363958,5718020,7417921,6008656,4697136,6854832,967522,5752343,5447492,7420364,3949639,6554754,7182178,6735185,7421824,7302801,4214184,4058889,7422799,7329357,7307285,2934716,3630431,4049087,7423724,6821434,6738184,5472278,2990310,7421488,6523946,6076985,2873994,7427232,7427395,6802023,6833276,979517,7215600,7429773,3806426,7430086,3879981,2658266,4116969,7224221,1213961,471384,4441941,3704652,6520425,4134359,7338173,2525694,4331486,1651758,5082294,7400399,2305545,4770829,5719638,7436370,7387560,7333443,5473412,3386257,4322034,6690233,7299698,7439005,5740336,7370522,4493366,4649258,7416055,228031,6723229,4136240,4039431,6759606,7444285,7328815,182740,5494365,1168041,4157666,7447711,998043,4126177,6269044,366528,3508752,7251198,6683995,4884178,4769653,7450484,6659144,3473161,6640606,3549539,6580050,5106932,6450624,3616854,7453929,2939212,4298143,4287267,782034,6080081,3681199,6576252,1373317,2580474,1093448,5242775,2452210,7038972,4427777,2722057,1398499,7456546,1566975,3859238,5731930,14894,7394384,3201403,7456367,2406799,7460138,3364220,7460677,7460974,7461183,7462066,2230051,5726764,5394898,3568092,7463772,1154018,5149859,5757159,902012,2559094,6511941,3077963,7440094,3668541,7469225,216431,7469977,7470094,7318343,871914,1930329,3561975,7459656,5858904,7354719,155684,6502832,4116955,5011384,7475009,6179342,5603667,7316411,2586284,6101115,2356619,1150912,2114683,7477425,913559,6528585,3895131,5405823,3597478,7260608,1447257,4143644,2229533,6631751,783071,2598546,4385310,1164228,7482114,7483589,3972773,7419960,4903298,4838425,765890,6099429,5864667,6526722,4121347,6874714,4304677,5904789,7093182,3273991,2675058,7437225,3893550,4136777,6575585,6542660,5589094,7303656,4533917,7124963,1045595,6852587,6561572,7495192,3571444,3716049,7496751,3267763,5420466,3479629,7498496,7287267,7489649,3635887,4538129,3081118,3572842,1684046,2819605,5440379,5152497,1933152,5947269,443259,7474596,4549682,7503638,7503881,5285349,7062483,3338246,7476648,3080082,6442566,7507308,7507791,7481459,7448578,7073125,6545042,7509742,4408364,6849546,5843797,7492275,2038464,3307007,4881419,4106681,5104016,7384984,2616222,4414359,4389456,3102993,5764105,4266459,6029053,7338285,465053,2028058,3891756,7523605,2043980,7523120,7513473,6834984,1665240,3212904,2217617,4110059,1382763,6556960,3785280,7148508,5531420,3818229,2604522,7476668,4448393,1581512,4104008,1340152,7489015,4618910,7529491,4817075,6388233,5757171,920599,6782244,7455150,7531677,3706950,5137570,4047333,4247543,6762043,7128498,2141098,719416,7535142,3525798,4033913,443602,4798660,7191426,4352312,5638477,2968765,3972132,2630326,6002830,7342249,1302888,4337809,7535954,215553,5852891,1383378,6147732,4736249,344344,7277846,4937775,7543758,4370921,4031891,3822376,3286661,5345089,4836867,1281217,6341488,2573069,5131829,7499702,5902006,7547999,3147185,5916457,384816,7548371,3373622,7524964,7095377,6819009,971229,5071355,7090389,7550788,7552277,2697246,7483265,7105094,4927657,5698216,7554856,4541915,1666768,7415912,3221432,2893856,7396899,7559829,7560248,4710294,2307200,3817184,7047768,7563198,6909014,6275663,7563370,6179153,2774417,5910746,4915070,7567813,5257891,1564730,7568997,7272186,1130378,6140482,7570431,3822467,7391812,7105973,854183,2521423,5952691,7016050,7573043,5681423,4940366,7559561,4486954,5598376,6126654,7003379,3618354,5006067,2662168,4575605,6534813,2974642,6261602,4718049,3561198,4636182,6141142,7070779,7206585,2176572,7375520,7581833,7582019,7202664,578739,3317706,7584010,6070462,5794637,1538049,4297337,3858689,3473184,5896065,4258928,7574487,6557633,6130828,7584654,5080787,7540143,1329019,4900415,6569301,3676373,3611787,6411264,3751721,507078,2122672,7388196,7591106,2885518,5359449,508328,5611863,6532324,6020556,2350423,2318977,4880927,4764736,5712903,3412376,7092612,665200,4198782,4766535,7033405,7602107,4866796,6418150,3100768,5798473,7605229,3976246,3545219,6850579,7606086,507721,6335624,7020730,7606861,6169365,4722429,7585055,907576,2719118,7608023,5028363,7059096,7099935,4285699,1971254,7417870,2274267,850569,3356356,7092198,2205067,6216039,5269483,5402619,1417670,3223657,1041958,6684959,5191069,6092128,5088335,3456764,4629008,7516960,5624634,405326,7619820,7620853,1016287,2202537,2596937,7207473,6188210,5931579,5278594,7281291,2809177,7622741,7366928,7623483,1995933,7623708,1078391,6504068,7103758,4686330,1057443,6719320,5998360,6168532,5280598,5215536,7170863,3922769,2563443,4503016,2295847,2721160,7630935,7299782,5132816,7444781,2926992,7631744,5578087,7619378,7632699,6776757,6412861,5867820,5327391,7627198,4884293,7238979,7509698,3741876,6277670,4871899,7152961,7362470,5668543,4540571,2879540,3729508,7642635,7642618,7643283,4530440,6820122,7644126,7616989,7632116,4072611,552942,6569253,7245569,7631550,7646934,2947765,7647267,2793551,620382,4576805,7231645,5965525,7620889,793468,7638373,4494940,3418479,6769195,7655380,7375173,6276360,7205767,7657546,7659257,7195769,51167,4934640,2426635,4667931,4363391,1747752,3007581,6056528,7662231,4219404,7638008,325118,2283083,7102736,7271625,7594068,6195965,2474220,4598590,6948424,6530695,7533039,6224646,1911755,2336502,7533608,2921557,7511861,4451566,7418793,4607131,6535798,6293672,5348713,7669460,7669508,3352675,3682813,6892452,4745239,7661855,4366482,695397,5847118,3080432,7137438,2930156,7673962,3983304,5672339,2685907,5573294,5357085,7469119,7254782,3249323,5117258,6306884,7209911,4375107,7679687,4775128,7679696,1208379,4455630,6198736,6914800,3819117,557576,3770392,7370474,2650174,5538830,4020980,7458027,5118326,2755279,7688737,2622513,6617318,179520,7614941,1273678,7689896,5857399,2110961,7622212,7560554,6372192,6500681,1751162,7116109,4962585,6316356,5878145,6831093,2566773,4588128,1625534,5738561,6515166,7696627,4011116,4334685,5073365,3656855,7004196,2444400,7700284,6042898,4395064,2704032,1640892,5955871,6271199,6787168,3765683,3173214,7667281,3573626,1532474,7558576,4210546,7685484,2855231,1353549,7704517,5889533,7704753,3658843,7223965,7706581,7707193,7649471,7121735,6720559,801951,7304770,7478771,6758743,5185442,4086194,5954086,7710482,7491660,6939031,7438158,7046249,2315212,1066820,7714884,7701381,3714404,5102631,7716049,6187792,7132474,4455806,5568399,1269634,7132713,3505704,7718778,3218902,3521109,2844093,1358684,1403788,7648922,7721818,7337867,1296166,946635,5790802,2478392,3969976,6361089,5937452,6263895,645212,7724503,715287,6807424,4592533,6928142,805502,5493611,179446,5921576,2462652,345342,3908838,4844323,6487017,7726738,3196822,4349666,7656887,7731318,3358678,7502180,6276279,7570590,5207490,7183433,3453510,7727885,7733185,6042663,5194223,7733890,7734185,2181526,7073063,3216913,4244808,7735186,7733947,5511220,3274085,3627550,4031918,5685796,5357729,2829073,1411975,1443606,6929831,6856524,7737718,7503585,6857153,4859472,3229534,7740715,7740946,3451457,7730770,2879539,7742532,2951976,3547132,7677133,1316967,7745095,3214911,7667132,7744397,7095078,4382972,7747324,5030124,4206663,7680355,7021841,7748633,5614455,6204900,7618120,4696553,7750181,7203651,6876654,3696412,980153,6217326,3905832,5480599,5838209,3902493,5533941,6704736,5571327,4790121,6378237,1126021,7129312,7757350,711061,4053082,7740365,6142754,4132916,6670200,7590142)
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