0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited oct 19 anonymous

created jul 28 18 jon.doe29013