500 Longuest questions with score and poster rep

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 500 Id as [Post Link], len(Body) AS Length, Score,
UserRep = (SELECT Reputation FROM Users WHERE Id = OwnerUserId)
FROM Posts WHERE PostTypeId=1 AND creationdate > 2013-01-01 ORDER BY len(Body) DESC

Enter Parameters

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