SELECT TOP 100 Posts.Id AS PostId, Users.Id AS UserId, Po...

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 100
  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 > 1
  AND Users.Reputation < 11
  AND LEN(posts.Body) < 250
  AND ParentPosts.OwnerUserId != Posts.OwnerUserId
  ORDER BY RAND()

Enter Parameters

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