Find good Hibernate questions I didn't answer

1

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 *
FROM (
  SELECT
    DENSE_RANK() OVER (ORDER BY q.Score DESC) AS Ranking,
    q.Id AS [Post Link],
    q.Id AS PostId,
    q.Score AS PostScore
  FROM Posts q
  JOIN PostTags pt ON q.Id = pt.PostId
  JOIN Tags t ON pt.TagId = t.Id
  WHERE t.TagName = '##TagName##'
) TopQ
WHERE
  Ranking < 50 AND
  NOT EXISTS (
    SELECT 1
    FROM Posts a
    WHERE
      PostId = a.ParentId AND
      a.OwnerUSerId = ##UserId##
  )
ORDER BY PostScore DESC

Enter Parameters

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