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 questions. Non-paged question and answers list for a user (excluding CW questions)

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

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

SELECT
    p.Id as [Post Link],
    Score,
    p.CommunityOwnedDate as [CW]
FROM Posts p
WHERE p.OwnerUserId = ##UserId## AND
      p.CommunityOwnedDate is null  -- User "Community" (ID 1) owns all Community Wiki posts.
ORDER BY Score DESC

view current version

edited jul 20 10

created jul 20 10 Peter Mortensen