200 Posts from bottom quartile

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 1000
  posts.Id AS PostId,
  Users.Id AS UserId,
  posts.Body,
  posts.Score AS PostScore,
  Users.Reputation,
  parentPosts.Tags
FROM Posts posts
INNER JOIN Posts parentPosts on posts.ParentId = parentPosts.Id
INNER JOIN Users on posts.OwnerUserId = Users.Id
INNER JOIN PostTypes ON PostTypes.Id = posts.PostTypeId
WHERE
  PostTypes.Name = 'Answer'
  AND Users.Reputation < 30
  AND LEN(posts.Body) < 250
  ORDER BY RAND(222) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results