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

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, Badges.Name
FROM Users, Badges
WHERE Users.Id IN (22108,22185,22260,22567,22739,22762,22870,22969,22991,23050,23149,23377,23393,23442,23757,23830,23964,24106,24249,24268,24820,24942,25061,25154,25407,25568,25956,26142,26325,26993,27046,27432,27533,27654,28910,29076,29336,29342,29446,29452,29686,30168,30260,30488,30518,30682,31333,31550,31631,31835,32081,32115,32468,32682,33027,33199,33402,33781,33926,33950,34197,34723,34949,35223,35375,35872,35941,36035,36441,36993,37010,37148,37333,37442,37890,38162,38581,38613,38674,38812,38850,38865,38915,39053,39309,39329,39557,40264,41428,41456,41821,41838,42273,42333,42568,42646,42659,42693,43388,44138,44589,44637,44737,45064,45270,45279,45409,45549,46094,46141,46203,46240,46271,46274,47552,47582,47750,47816,47944,48045,48828,48831,48844,48855,48876,48898,49111,49118,49196,49221,49334,49688,49734,49788,50188,50334,50780,51009,51162,51553,51577,51621,51632,51731,52134,52205,52330,52979,53004,53323,53717,54468,54683,54766,54774)
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