0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter A way around paging for a user's posts, questions and answers.

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

-- Enter Non-paged user's posts (non-CW)
-- Enter A way around paging for a user's posts, questions and answers.

SELECT
    p.Id as [Post Link],
    Score,
    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 Score DESC

fork query

created jul 20 10 Peter Mortensen