1

Please login or register to vote for this query.

(click on this box to dismiss)

A way around paging for a user's posts, questions and answers. A view count of zero means it is an answer.

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

-- A user's posts, non-paged (non-Community Wiki)
-- A way around paging for a user's posts, questions and answers. A view count of zero means it is  an answer.

SELECT
    p.Id as [Post Link],
    Score as [Votes],
    ViewCount  as [Views],
    p.CommunityOwnedDate as [CW]
FROM Posts p
WHERE p.OwnerUserId = ##UserId## AND
      p.CommunityOwnedDate is null  -- Field CommunityOwnedDate is absent for non-CW posts.
ORDER BY ViewCount DESC

fork query

created jul 20 10 Peter Mortensen