Last votes by a given user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- uid: User ID
-- NbMonth: Number of months

DECLARE @user INT = ##uid:INT##

SELECT
  v.CreationDate AS 'Date',
  t.Name
FROM 
  Votes v 
  INNER JOIN VoteTypes t ON v.VoteTypeId = t.Id
  WHERE v.UserId = @user 
  ORDER BY 'Date' DESC

Enter Parameters

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