Select posts from top quartile

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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