Select posts from top quartile

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

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 main site
loading Hold tight while we fetch your results