Last posts made by a given user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show the last 5 posts of a user

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
DECLARE @user INT = ##uid:INT##

SELECT TOP 5
  p.CreationDate AS 'Date',
  p.Id as [Post Link]
FROM 
  Posts p
  WHERE p.OwnerUserId = @user
  ORDER BY 'Date' DESC

Enter Parameters

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