Q&A for SharePoint enthusiasts
SELECT * -- TOP 50 ROW_NUMBER() OVER (ORDER BY v.CreationDate DESC) AS [#], * FROM Tags t JOIN PostTags pt ON pt.TagId = t.id JOIN Posts p ON p.ParentId = pt.PostId JOIN Votes v ON v.PostId = p.Id -- and VoteTypeId = 3 JOIN Users u ON p.OwnerUserId = u.Id WHERE TagName in ('jolt') ORDER BY v.CreationDate DESC;