1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for participants in team and individual sport activities

Declare @PostId int = ##PostId##

SELECT
    v.Id
  , v.PostId
  , v.VoteTypeId
  , v.UserId
  , v.CreationDate
  , p.CreationDate
  , p.Score
  , p.ViewCount
  , p.OwnerUserId
  , p.Title
  , p.FavoriteCount
  , u.Reputation
  , u.CreationDate
  , u.DisplayName
  , u.UpVotes
  , u.DownVotes
FROM
    Votes v
INNER JOIN
    Posts p
ON
    p.Id = v.PostId
INNER JOIN
    Users u
ON
    u.Id = v.UserId
WHERE
    v.VoteTypeId = 5
AND v.PostId = @PostId

fork query

edited mar 11 19

created mar 2 19 fra-san