Closed questions, oldest

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
TOP 100
'site://q/' + CAST(q.Id AS NVARCHAR) + '/' + CAST(MIN(m.Id) AS NVARCHAR) + '|' + MIN(q.Title) AS qti,
e.CreationDate,
e.Comment,
q.OwnerUserId AS 'User Link'
FROM Posts AS q
JOIN PostHistory AS e ON q.Id = e.PostId
LEFT JOIN Users AS m ON m.AccountId = 1192385
WHERE 1 = q.PostTypeId AND
10 = e.PostHistoryTypeId
GROUP BY q.Id, q.OwnerUserId, e.Id, e.PostId, e.CreationDate, e.Comment
ORDER BY q.Id, e.Id;

Enter Parameters

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