Select posts from top 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 Users.Reputation < 11
  AND LEN(posts.Body) < 250
    AND (posts.Body LIKE '%why%'
  OR posts.Body LIKE '%bother%')
  AND parentPosts.OwnerUserId != posts.OwnerUserId
  ORDER BY posts.Id desc

Enter Parameters

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