SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, ROW_...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, ROW_NUMBER() OVER(PARTITION BY Users.Id, Date ORDER BY Badges.Date ASC) AS EventId, Badges.Name
FROM Users, Badges
WHERE Users.Id IN (22063,22070,22081,22088,22091,22095,22115,22116,22128,22134,22153,22162,22165,22172,22178,22193,22209,22213,22215,22219,22222,22226,22244,22245,22254,22257,22259,22262,22268,22276,22278,22279,22284,22291,22303,22311,22319,22323,22325,22328,22332,22334,22335,22336,22339,22343,22345,22350,22365,22380,22384,22387,22400,22407,22415,22416,22418,22431,22437,22439,22446,22456,22458,22461,22463,22478,22485,22493,22495,22505,22507,22520,22522,22566,22573,22577,22588,22589,22597,22601,22613,22616,22636,22650,22669,22687,22688,22690,22693,22698,22704,22717,22720,22722,22725,22731,22733,22747,22772,22784,22785,22789,22816,22841,22842,22843,22859,22862,22864,22873,22875,22877,22883,22884,22885,22902,22905,22907,22911,22931,22939,22954,22959,22960,22962,22985,22991,22999,23005,23015,23017,23023,23028,23037,23044,23051,23054,23062,23064,23065,23070,23084,23101,23103,23107,23114,23117,23123,23124,23132,23135,23136,23137,23146,23152,23168,23169,23172,23173,23184,23192,23206,23207,23226,23229,23237,23249,23250,23255,23260,23276,23282,23288,23317,23319,23327,23333,23337,23340,23341,23350,23362,23363,23366,23372,23376,23388,23394,23405,23409,23416,23417,23443,23445,23457,23458,23459,23461,23468,23469,23470,23471,23474,23491,23494,23510,23520,23523,23538,23546,23548,23549,23555,23556,23566,23568,23578,23586,23588,23597,23601,23618,23619,23623,23627,23645,23650,23655,23662,23671,23676,23677,23700,23704,23706,23708,23709,23713,23717,23721,23722,23723,23725,23742,23743,23750,23753,23774,23783,23785,23786,23791,23793,23797,23810,23813,23819,23837,23866,23870,23880,23884,23890,23898,23901,23903,23904,23905,23908,23915,23916,23924,23938,23942,23947,23974,23985,23994,24008,24026,24032,24037,24055,24065,24072,24084,24089,24097,24098,24107,24116,24123,24124,24131,24134,24139,24140,24159,24160,24175,24181,24182,24187,24193,24203,24210,24214,24223,24230,24234,24243,24262,24263,24276,24290,24292,24293,24305,24312,24320,24323,24344,24351,24355,24359,24373,24387,24418,24420,24423,24425,24427,24439,24447,24451,24452,24456,24464,24465,24467,24485,24496,24499,24504,24512,24519,24553,24555,24556,24558,24559,24561,24563,24564,24582,24584,24585,24595,24598,24605,24609,24611,24619,24632,24639,24640,24649,24658,24668,24671,24676,24678,24701,24704,24706,24712,24714,24717,24744,24748,24771,24792,24793,24795,24800,24804,24811,24813,24822,24831,24832,24838,24845,24859,24869,24872,24874,24875,24876,24881,24886,24887,24893,24901,24908,24911,24918,24930,24934,24939,24941,24945,24946,24958,24969,24990,24999,25004,25011,25015,25016,25027,25031,25033,25035,25043,25046,25053,25055,25056,25058,25070,25089,25090,25091,25093,25100,25105,25109,25111,25115,25124,25125,25126,25135,25139,25142,25143,25148,25150,25166,25171,25191,25203,25204,25205,25210,25217,25220,25224,25239,25243,25247,25248,25253,25257,25258,25268,25276,25295,25296,25298,25300,25304,25309,25314,25320,25321,25326,25331,25335,25336,25338,25339,25360,25370,25385,25394,25409,25415,25423,25431,25444,25445,25447,25449,25514,25518,25522,25528,25545,25549,25574,25584,25585,25586,25590,25591,25592,25602,25606,25608,25609,25623,25632,25657,25662,25679,25698,25710,25715,25725,25727,25735,25739,25745,25746,25747,25748,25751,25752,25762,25773,25781,25789,25791,25800,25805,25809,25815,25816,25823,25825,25827,25838,25848,25874,25888,25892,25895,25907,25915,25928,25931,25933,25941,25965,25967,25974,25983,25984,25987,25992,25993,26007,26008,26011,26018,26022,26038,26057,26068,26071,26092,26093,26103,26106,26111,26114,26126,26137,26146,26152,26194,26198,26200,26201,26209,26217,26226,26238,26242,26245,26248,26250,26259,26270,26285,26288,26298,26299,26323,26324,26326,26331,26337,26338,26351,26352,26361,26371,26384,26391,26393,26394,26410,26422,26428,26431,26435,26446,26451,26457,26465,26469,26477,26479,26481,26485,26490,26496,26499,26500,26510,26512,26518,26524,26526,26539,26543,26550,26557,26564,26569,26580,26593,26596,26616,26617,26627,26630,26633,26642,26644,26652,26657,26664,26665,26668,26673,26675,26696,26707,26732,26739,26740,26758,26763,26777,26786,26790,26795,26800,26810,26831,26835,26842,26845,26847,26851,26855,26860,26869,26876,26882,26890,26898,26900,26908,26915,26928,26929,26932,26934,26940,26941,26955,26956,26961,26963,26990,26995,26996,27027,27035,27046,27054,27062,27064,27074,27088,27102,27105,27106,27109,27112,27113,27115,27124,27128,27132,27150,27155,27161,27164,27180,27181,27189,27198,27224,27226,27228,27241,27254,27263,27266,27268,27270,27280,27294,27299,27308,27317,27329,27330,27355,27361,27371,27373,27374,27386,27387,27390,27403,27404,27433,27440,27445,27453,27457,27470,27471,27479,27483,27494,27510,27512,27516,27518,27520,27523,27531,27535,27539,27541,27553,27559,27560,27573,27584,27595,27606,27608,27609,27612,27629,27654,27662,27666,27670,27674,27692,27704,27737,27740,27742,27743,27755,27761,27763,27772,27781,27784,27788,27791,27793,27807,27823,27828,27848,27866,27883,27895,27897,27899,27903,27921,27947,27952,27953,27955,27959,27960,27966,27970,27971,27975,27978,27980,27981,27984,27989,27990,27997,28014,28021,28022,28026,28031,28036,28046,28050,28051,28057,28081,28108,28119,28128,28132,28152,28157,28158,28170,28171,28197,28202,28207,28211,28217,28219,28221,28222,28234,28238,28239,28242,28250,28253,28272,28274,28286,28289,28292,28294,28301,28306,28317,28322,28330,28335,28337,28339,28345,28353,28363,28364,28368,28378,28387,28393,28395,28405,28408,28411,28425,28428,28431,28447,28452,28459,28479,28507,28532,28563,28594,28606,28609,28610,28616,28617,28619,28620,28628,28630,28634,28645,28650,28659,28661,28666,28668,28673,28675,28680,28693,28694,28717,28719,28742,28745,28751,28762,28784,28792,28794,28805,28807,28812,28815,28816,28820,28824,28843,28846,28851,28855,28864,28866,28875,28879,28889,28900,28909,28922,28924,28927,28932,28933,28934,28940,28942,28951,28972,28973,28978,28979,28983,28986,29002,29009,29011,29019,29024,29026,29029,29033,29040,29057,29076,29088,29095,29102,29110,29113,29116,29130,29139,29140,29150,29154,29156,29160,29168,29171,29181,29188,29199,29206,29214,29215,29222,29223,29229,29232,29238,29240,29241,29246,29260,29266,29267,29277,29282,29285,29288,29302,29303,29313,29320,29327,29329,29330,29334,29336,29341,29347,29356,29362,29366,29369,29372,29374,29383,29384,29386,29397,29402,29405,29407,29410,29416,29424,29432,29442,29447,29451,29454,29456,29458,29461,29463,29466,29467,29492,29493,29507,29514,29518,29519,29524,29528,29546,29547,29551,29555,29556,29566,29573,29577,29585,29593,29602,29606,29608,29616,29620,29627,29630,29639,29647,29653,29659,29661,29662,29665,29669,29673,29676,29680,29685,29690,29693,29697,29707,29711,29714,29734,29736,29750,29759,29761,29770,29773,29776,29778,29785,29789,29790,29802,29810,29812,29829,29833,29836,29838,29840,29841,29842,29844,29855,29868,29871,29879,29896,29902,29903,29914,29929,29944,29985,29989,29990,30001,30007,30013,30014,30019,30020,30023,30040,30043,30071,30074,30082,30091,30094,30098,30105,30106,30118,30121,30136,30139,30141,30143,30151,30160,30173,30182,30183,30199,30203,30227,30241,30245,30246,30262,30263,30272,30285,30289,30291,30296,30299,30300,30308,30317,30326,30336,30346,30347,30360,30367,30375,30379,30380,30387,30388,30396,30399,30402,30403,30409,30429,30432,30439,30445,30455,30456,30460,30467,30468,30470,30474,30482,30488,30500,30507,30511,30530,30533,30546,30561,30567,30577,30580,30582,30589,30593,30602,30633,30635,30637,30638,30640,30642,30649,30651,30657,30663,30667,30668,30669,30679,30680,30685,30690,30692,30705,30708,30711,30716,30722,30723,30724,30727,30740,30749,30758,30768,30770,30777,30786,30794,30797,30803,30817,30823,30828,30839,30840,30844,30854,30870,30884,30889,30906,30912,30944,30946,30955,30963,30974,30975,30978,30985,30994,30996,31014,31015,31020,31026,31041,31046,31049,31051,31054,31062,31069,31091,31095,31099,31100,31103,31105,31111,31112,31115,31141,31144,31154,31159,31194,31196,31197,31212,31229,31263,31270,31274,31278,31292,31294,31299,31300,31308,31309,31311,31323,31326,31328,31352,31365,31369,31381,31384,31386,31388,31407,31417,31423,31434,31442,31445,31451,31452,31455,31458,31462,31484,31532,31544,31549,31554,31564,31571,31575,31580,31581,31585,31595,31604,31609,31611,31615,31620,31621,31631,31638,31640,31644,31652,31653,31658,31662,31667,31677,31681,31683,31684,31687,31693,31695,31702,31704,31716,31718,31735,31740,31744,31746,31755,31757,31762,31768,31770,31784,31789,31792,31800,31803,31821,31830,31844,31851,31852,31859,31866,31871,31872,31876,31890,31896,31911,31915,31924,31932,31943,31947,31948,31954,31971,31974,31976,31977,31988,31993,31996,32023,32037,32038,32056,32061,32065,32075,32081,32094,32108,32116,32120,32123,32126,32131,32132,32149,32152,32163,32165,32170,32171,32178,32184,32186,32195,32199,32200,32210,32216,32231,32239,32240,32251,32255,32272,32287,32298,32331,32335,32337,32341,32344,32350,32360,32363,32371,32372,32375,32378,32382,32383,32390,32397,32419,32430,32439,32442,32444,32450,32454,32463,32465,32467,32473,32474,32483,32486,32505,32511,32527,32529,32540,32563,32566,32573,32586,32591,32597,32600,32601,32613,32631,32632,32645,32658,32660,32665,32679,32681,32692,32704,32715,32724,32725,32737,32738,32743,32748,32756,32768,32773,32774,32779,32793,32795,32805,32808,32810,32833,32834,32836,32843,32854,32860,32861,32876,32893,32898,32904,32920,32937,32949,32953,32959,32967,32968,32980,32993,33005,33026,33033,33036,33039,33049,33055,33057,33059,33063,33073,33078,33081,33087,33095,33106,33115,33124,33130,33131,33139,33150,33152,33159,33171,33177,33183,33185,33207,33216,33229,33235,33239,33243,33244,33252,33253,33256,33274,33276,33307,33315,33320,33338,33346,33360,33361,33383,33384,33389,33392,33402,33407,33419,33425,33432,33437,33445,33463,33468,33472,33496,33497,33500,33502,33512,33524,33533,33540,33546,33550,33560,33562,33564,33577,33583,33589,33591,33610,33620,33624,33626,33627,33628,33630,33634,33635,33642,33647,33657,33679,33688,33693,33711,33728,33738,33752,33754,33757,33758,33763,33771,33776,33777,33778,33781,33788,33792,33806,33812,33824,33834,33836,33837,33845,33850,33862,33871,33872,33882,33890,33897,33912,33913,33914,33919,33922,33934,33938,33941,33952,33960,33970,33978,33986,33991,33992,34015,34028,34041,34067,34079,34084,34091,34092,34094,34096,34097,34103,34111,34114,34116,34122,34125,34126,34127,34134,34152,34156,34157,34158,34165,34167,34174,34186,34188,34200,34201,34211,34221,34234,34237,34239,34250,34268,34279,34289,34296,34310,34325,34335,34342,34358,34365,34384,34401,34415,34426,34430,34431,34435,34438,34461,34465,34471,34487,34495,34505,34506,34507,34513,34535,34538,34543,34567,34570,34580,34585,34587,34592,34593,34599,34601,34627,34628,34630,34639,34663,34664,34674,34679,34682,34683,34685,34688,34692,34700,34706,34707,34713,34718,34720,34727,34737,34747,34755,34785,34786,34794,34812,34815,34817,34820,34821,34838,34842,34845,34856,34860,34862,34867,34868,34869,34870,34874,34877,34886,34889,34895,34912,34913,34920,34936,34964,34972,34973,34974,34989,34995,35007,35009,35014,35026,35030,35034,35044,35046,35053,35058,35070,35085,35090,35100,35127,35129,35130,35131,35135,35136,35155,35161,35164,35167,35172,35183,35185,35189,35192,35201,35208,35213,35220,35232,35236,35238,35240,35260,35262,35286,35293,35298,35300,35306,35319,35325,35328,35330,35335,35342,35343,35346,35354,35358,35364,35366,35369,35373,35380,35399,35412,35434,35461,35467,35484,35486,35494,35496,35503,35525,35538,35556,35570,35578,35580,35590,35591,35593,35605,35610,35615,35623,35625,35644,35653,35666,35669,35676,35681,35688,35696,35700,35702,35705,35709,35715,35718,35729,35739,35742,35756,35759,35765,35770,35778,35784,35787,35789,35790,35795,35807,35812,35813,35816,35817,35818,35820,35828,35842,35845,35861,35862,35870,35871,35875,35883,35888,35899,35901,35924,35929,35938,35939,35950,35957,35965,35967,35973,35979,35991,35994,35997,36004,36007,36009,36016,36018,36027,36039,36040,36057,36065,36078,36081,36092,36100,36103,36104,36106,36113,36119,36126,36128,36134,36147,36161,36165,36179,36180,36193,36196,36197,36198,36200,36205,36212,36215,36222,36224,36247,36250,36258,36259,36275,36276,36282,36309,36312,36314,36331,36339,36343,36355,36367,36379,36383,36389,36397,36399,36412,36428,36431,36442,36445,36456,36463,36482,36483,36497,36505,36510,36513,36521,36529,36530,36531,36535,36553,36556,36557,36559,36566,36578,36581,36584,36589,36602,36605,36620,36622,36628,36633,36638,36641,36646,36648,36653,36670,36671,36674,36679,36680,36683,36685,36688,36701,36707,36715,36718,36725,36732,36733,36735,36736,36749,36750,36754,36755,36768,36779,36792,36802,36821,36827,36830,36834,36841,36845,36847,36849,36889,36896,36908,36914,36926,36931,36951,36961,36969,36980,36982,36999,37000,37004,37024,37049,37053,37055,37083,37096,37110,37123,37126,37131,37139,37143,37148,37165,37168,37174,37183,37187,37196,37210,37218,37229,37232,37239,37251,37252,37255,37260,37263,37267,37270,37301,37312,37317,37320,37333,37336,37352,37353,37359,37364,37369,37373,37375,37381,37388,37393,37396,37397,37402,37403,37404,37406,37414,37419,37420,37443,37445,37447,37453,37458,37464,37468,37484,37493,37501,37506,37513,37514,37516,37536,37549,37560,37569,37581,37597,37601,37628,37645,37648,37652,37660,37664,37665,37674,37677,37682,37687,37702,37704,37706,37709,37749,37751,37754,37757,37762,37763,37766,37771,37777,37805,37811,37826,37832,37833,37846,37849,37851,37860,37873,37876,37879,37880,37881,37884,37892,37899,37914,37919,37931,37932,37934,37947,37952,37963,37970,37974,37985,37987,37990,37991,37998,38001,38010,38013,38030,38034,38043,38049,38050,38060,38062,38063,38071,38096,38104,38107,38110,38124,38126,38136,38162,38164,38166,38172,38189,38198,38202,38203,38209,38210,38218,38220,38224,38225,38226,38228,38229,38232,38241,38261,38271,38279,38295,38303,38306,38308,38311,38313,38314,38315,38317,38324,38331,38337,38339,38346,38347,38351,38361,38373,38381,38396,38409,38420,38431,38442,38443,38449,38461,38469,38472,38481,38483,38488,38495,38499,38503,38508,38531,38534,38540,38545,38552,38557,38564,38569,38574,38577,38579,38584,38602,38603,38604,38607,38611,38614,38617,38626,38631,38633,38635,38636,38639,38648,38649,38652,38653,38655,38659,38660,38662,38665,38667,38701,38703,38731,38752,38754,38765,38774,38775,38777,38779,38815,38819,38823,38825,38826,38834,38836,38862,38865,38897,38905,38907,38935,38942,38947,38951,38955,38956,38978,38982,38983,38987,38988,38993,38999,39009,39019,39057,39071,39075,39080,39085,39105,39107,39121,39122,39124,39127,39128,39129,39144,39145,39162,39163,39167,39194,39210,39212,39233,39241,39250,39252,39254,39257,39263,39282,39285,39297,39307,39317,39329,39332,39333,39345,39347,39349,39350,39366,39377,39385,39391,39395,39403,39406,39409,39431,39436,39437,39441,39442,39464,39472,39485,39499,39509,39519,39520,39523,39525,39533,39534,39535,39537,39538,39543,39551,39558,39568,39570,39573,39580,39602,39609,39616,39628,39637,39642,39651,39652,39666,39671,39676,39683,39685,39689,39700,39709,39710,39717,39718,39725,39726,39728,39731,39735,39748,39752,39756,39775,39780,39782,39802,39806,39812,39814,39823,39829,39834,39850,39866,39872,39890,39892,39896,39913,39917,39933,39934,39938,39946,39948,39962,39965,39967,39975,39982,39986,39987,40020,40022,40023,40031,40034,40039,40042,40052,40071,40073,40075,40080,40090,40092,40101,40122,40124,40130,40138,40144,40161,40169,40173,40189,40204,40205,40227,40236,40247,40255,40265,40267,40270,40276,40280,40301,40304,40309,40318,40321,40325,40326,40327,40328,40329,40330,40334,40341,40343,40344,40346,40360,40365,40366,40367,40368,40371,40374,40380,40384,40386,40388,41400,41408,41413,41416,41420,41422,41428,41437,41455,41481,41495,41496,41500,41513,41527,41531,41532,41541,41542,41550,41563,41568,41580,41591,41597,41608,41609,41612,41616,41633,41637,41645,41655,41665,41686,41697,41699,41705,41719,41726,41735,41768,41770,41772,41778,41780,41782,41792,41796,41797,41806,41814,41818,41832,41842,41844,41857,41863,41867,41876,41877,41879,41881,41887,41892,41894,41904,41914,41918,41922,41925,41935,41956,41958,41969,41970,41972,41975,41988,41992,42004,42012,42013,42019,42023,42029,42033,42035,42037,42038,42042,42043,42046,42047,42051,42056,42058,42063,42069,42082,42083,42084,42093,42094,42097,42098,42102,42105,42116,42121,42123,42131,42139,42143,42144,42147,42153,42162,42163,42166,42171,42213,42232,42252,42259,42261,42266,42270,42273,42293,42303,42309,42313,42320,42323,42332,42345,42353,42359,42362,42368,42377,42379,42397,42399,42401,42410,42414,42418,42427,42435,42436,42447,42453,42455,42458,42482,42493,42499,42500,42502,42503,42510,42511,42512,42542,42545,42548,42564,42577,42588,42591,42596,42599,42603,42608,42613,42624,42642,42653,42659,42660,42665,42666,42668,42687,42696,42697,42698,42716,42717,42723,42724,42729,42736,42742,42743,42770,42771,42772,42776,42778,42796,42817,42823,42827,42830,42834,42835,42836,42852,42855,42859,42861,42880,42885,42898,42913,42919,42922,42923,42933,42950,42958,42959,42961,42967,42976,42993,42999,43018,43019,43020,43023,43026,43039,43044,43056,43069,43089,43090,43095,43107,43110,43125,43129,43130,43133,43134,43138,43162,43168,43176,43178,43214,43220,43227,43229,43233,43241,43244,43255,43258,43278,43284,43293,43295,43305,43308,43310,43317,43320,43321,43323,43339,43343,43345,43350,43351,43355,43367,43372,43373,43378,43382,43386,43389,43402,43406,43410,43414,43417,43418,43422,43423,43424,43426,43431,43434,43444,43459,43467,43472,43484,43488,43503,43504,43524,43530,43535,43541,43551,43553,43560,43563,43566,43575,43576,43577,43582,43594,43599,43602,43606,43618,43625,43641,43645,43649,43670,43688,43703,43715,43716,43727,43733,43750,43757,43769,43778,43789,43806,43815,43816,43828,43845,43848,43859,43865,43879,43884,43900,43913,43921,43922,43923,43932,43939,43950,43966,43978,43998,44005,44010,44015,44018,44021,44040,44044,44051,44063,44076,44078,44087,44106,44133,44135,44148,44155,44161,44173,44177,44182,44184,44198,44201,44202,44214,44217,44219,44237,44240,44267,44273,44277,44284,44294,44302,44305,44307,44325,44328,44333,44334,44342,44350,44353,44354,44367,44370,44379,44381,44385,44386,44387,44389,44399,44411,44426,44430,44436,44438,44439,44447,44452,44453,44473,44477,44478,44480,44481,44489,44501,44521,44522,44530,44536,44546,44548,44557,44558,44573,44574,44575,44578,44597,44605,44613,44620,44631,44633,44634,44636,44657,44669,44678,44684,44688,44692,44695,44707,44729,44740,44748,44764,44767,44774,44782,44796,44801,44802,44810,44816,44817,44819,44823,44840,44846,44847,44866,44872,44883,44888,44901,44907,44914,44922,44926,44927,44930,44944,44945,44953,44973,44987,44991,44998,44999,45003,45008,45018,45019,45034,45038,45043,45064,45069,45072,45087,45089,45092,45102,45107,45110,45131,45132,45137,45139,45140,45164,45167,45179,45183,45191,45196,45197,45200,45202,45208,45233,45240,45254,45266,45272,45274,45278,45280,45281,45293,45296,45301,45306,45313,45317,45318,45328,45329,45346,45349,45357,45363,45366,45373,45377,45382,45397,45424,45427,45430,45449,45450,45451,45454,45459,45470,45473,45482,45483,45493,45496,45507,45525,45528,45533,45541,45546,45552,45569,45586,45591,45599,45604,45611,45613,45622,45630,45643,45652,45671,45673,45693,45696,45709,45715,45723,45748,45757,45760,45777,45787,45788,45791,45803,45827,45835,45839,45862,45869,45885,45903,45904,45906,45909,45943,45950,45964,45977,45978,45997,45999,46005,46016,46027,46040,46042,46063,46064,46078,46088,46099,46100,46101,46110,46113,46122,46136,46140,46145,46151,46179,46183,46195,46196,46198,46210,46225,46232,46238,46241,46251,46266,46268,46274,46282,46283,46287,46294,46304,46313,46321,46325,46326,46336,46368,46369,46373,46379,46380,46386,46394,46397,46409,46412,46425,46430,46431,46445,46450,46452,46455,46458,46460,46476,46480,46483,46491,47499,47500,47501,47502,47509,47515,47521,47543,47544,47554,47558,47564,47572,47578,47584,47592,47595,47600,47602,47606,47612,47621,47642,47652,47653,47657,47658,47661,47669,47671,47679,47687,47689,47690,47691,47694,47695,47710,47714,47716,47719,47721,47736,47744,47748,47759,47763,47764,47765,47773,47775,47778,47784,47785,47789,47790,47797,47801,47803,47805,47808,47822,47839,47846,47849,47850,47863,47876,47882,47908,47915,47933,47937,47940,47949,47951,47972,47977,47989,47990,47998,48006,48008,48016,48033,48054,48056,48057,48070,48075,48084,48087,48088,48101,48105,48106,48115,48118,48123,48126,48133,48136,48139,48150,48160,48178,48186,48206,48208,48218,48219,48221,48227,48228,48236,48244,48245,48248,48255,48262,48264,48265,48266,48277,48288,48290,48315,48343,48347,48350,48352,48353,48356,48367,48369,48381,48387,48390,48398,48409,48412,48433,48446,48461,48462,48465,48469,48490,48499,48513,48517,48521,48526,48528,48535,48539,48541,48544,48552,48556,48560,48566,48575,48577,48579,48585,48586,48590,48595,48597,48598,48608,48612,48632,48633,48634,48641,48653,48656,48657,48660,48669,48673,48674,48675,48677,48679,48684,48686,48691,48703,48705,48707,48719,48725,48735,48744,48760,48786,48791,48803,48807,48808,48828,48829,48830,48834,48835,48863,48869,48870,48874,48876,48893,48894,48898,48904,48908,48914,48916,48926,48929,48931,48943,48944,48946,48947,48957,48968,48974,48979,48981,48982,48987,49004,49007,49022,49026,49027,49029,49032,49033,49053,49057,49066,49068,49070,49086,49087,49097,49101,49103,49104,49111,49114,49126,49128,49129,49142,49163,49179,49182,49184,49189,49253,49257,49308,49319,49326,49329,49338,49360,49368,49375,49378,49379,49381,49385,49386,49425,49437,49440,49448,49455,49466,49468,49490,49511,49528,49538,49544,49545,49550,49558,49575,49582,49590,49625,49638,49640,49648,49654,49656,49660,49663,49671,49674,49676,49677,49684,49690,49703,49750,49751,49759,49762,49785,49786,49795,49803,49812,49817,49820,49821,49840,49842,49843,49857,49868,49872,49876,49879,49883,49894,49896,49898,49908,49913,49955,49972,49983,49990,49997,49998,50011,50020,50038,50042,50044,50058,50064,50073,50076,50080,50085,50088,50106,50108,50112,50114,50115,50118,50143,50146,50176,50178,50182,50184,50188,50190,50200,50202,50205,50220,50229,50238,50250,50252,50254,50257,50276,50277,50287,50295,50305,50315,50322,50338,50351,50357,50358,50368,50370,50378,50386,50396,50398,50399,50414,50421,50422,50423,50431,50433,50436,50438,50443,50445,50448,50461,50464,50477,50483,50492,50500,50510,50511,50514,50520,50521,50526,50527,50529,50535,50550,50551,50555,50568,50582,50585,50587,50592,50607,50627,50642,50649,50656,50697,50704,50706,50722,50738,50741,50745,50758,50759,50762,50763,50769,50773,50775,50782,50787,50789,50790,50793,50799,50810,50812,50815,50843,50849,50852,50857,50883,50886,50887,50890,50891,50895,50913,50935,50936,50939,50951,50953,50963,50976,50977,50980,50988,50993,50998,51000,51001,51009,51012,51013,51018,51020,51024,51040,51043,51055,51059,51062,51069,51070,51077,51085,51086,51103,51105,51112,51118,51126,51129,51130,51131,51140,51170,51184,51201,51203,51210,51212,51217,51223,51226,51231,51274,51305,51311,51312,51314,51320,51325,51329,51333,51335,51339,51341,51349,51352,51355,51373,51375,51378,51387,51393,51396,51397,51419,51428,51432,51440,51446,51454,51455,51457,51458,51472,51476,51480,51485,51499,51501,51512,51518,51530,51531,51532,51534,51565,51572,51584,51590,51592,51594,51595,51597,51600,51602,51616,51621,51622,51634,51636,51645,51646,51659,51673,51676,51678,51683,51694,51713,51714,51721,51723,51725,51732,51736,51743,51754,51762,51771,51773,51779,51783,51787,51789,51798,51801,51804,51818,51821,51823,51841,51846,51849,51856,51861,51863,51884,51892,51893,51895,51897,51901,51909,51922,51926,51928,51931,51935,51936,51939,51941,51949,51970,51978,51979,51980,51985,51989,51994,52001,52002,52009,52012,52018,52021,52031,52035,52039,52041,52058,52070,52083,52086,52092,52094,52098,52102,52129,52131,52137,52147,52166,52175,52176,52183,52223,52233,52236,52246,52260,52271,52275,52283,52292,52297,52301,52317,52327,52337,52338,52340,52342,52344,52349,52361,52372,52374,52399,52401,52402,52413,52416,52429,52436,52444,52454,52457,52459,52483,52492,52493,52497,52498,52500,52507,52517,52525,52534,52547,52558,52560,52561,52569,52581,52595,52597,52602,52610,52616,52624,52627,52628,52636,52637,52639,52648,52652,52655,52661,52664,52665,52667,52678,52701,52706,52711,52715,52723,52728,52731,52750,52755,52760,52778,52787,52789,52811,52824,52831,52843,52853,52862,52864,52866,52908,52923,52927,52931,52937,52939,52942,52961,52969,52974,52975,52979,53004,53036,53039,53041,53043,53045,53048,53053,53058,53066,53071,53076,53080,53083,53089,53091,53097,53099,53104,53126,53129,53150,53151,53157,53163,53178,53186,53193,53195,53209,53228,53241,53244,53270,53272,53274,53277,53280,53282,53288,53295,53301,53303,53305,53313,53320,53330,53335,53342,53345,53360,53369,53382,53387,53393,53398,53404,53416,53417,53418,53424,53435,53447,53464,53515,53518,53520,53523,53531,53533,53535,53539,53554,53560,53574,53578,53591,53596,53603,53609,53619,53625,53643,53645,53662,53664,53669,53672,53691,53714,53716,53722,53734,53752,53763,53767,53773,53780,53802,53813,53832,53841,53844,53846,53862,53863,53869,53870,53874,53878,53886,53888,53910,53912,53916,53919,53929,53931,53933,53937,53939,53944,53954,53960,53961,53964,53966,53983,53987,53999,54004,54035,54057,54061,54063,54076,54078,54081,54083,54087,54094,54099,54124,54125,54128,54135,54149,54164,54165,54183,54190,54191,54202,54208,54211,54217,54218,54225,54229,54237,54244,54245,54248,54260,54268,54278,54279,54280,54297,54302,54304,54307,54309,54315,54317,54321,54338,54344,54348,54378,54379,54383,54387,54398,54405,54407,54413,54417,54422,54445,54459,54461,54463,54476,54493,54494,54503,54506,54513,54517,54530,54552,54555,54557,54560,54561,54562,54568,54571,54572,54609,54614,54617,54629,54633,54644,54656,54658,54662,54674,54678,54681,54691,54716,54724,54727,54742,54744,54755,54756,54758,54761,54773,54777,54778,54785,54787,54788,54798,54799,67257,70123,73475,75633,76992,84067,85478,118177,128938,166711)
AND Users.Id = Badges.UserId
AND Badges.TagBased = 0
ORDER BY Users.Id, Badges.Date

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results