Recent posts by given users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

SELECT TOP ##num?100##
  u.Id AS [User Link], u.LastAccessDate, p.CreationDate, p.Id AS [Post Link]
FROM Users u INNER JOIN Posts p ON p.OwnerUserId=u.Id
WHERE u.Id IN (##users?18,12,6126##)
ORDER BY p.CreationDate DESC

Enter Parameters

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