Questions with many short answers by low rep users

0

Please login or register to vote for this query.

(click on this box to dismiss)

includes viewcount as secondary sort to distinguish "high value" protection cases

Stack Overflow

Q&A for programmers

-- Questions with many short answers by low rep users
-- includes viewcount as secondary sort to distinguish "high value" protection cases

select x.ParentId, x.[Post Link], x.Counter, p.ViewCount from
(
select
   ParentId, ParentId as [Post Link], count(posts.id) as Counter
from posts, users
where posttypeid = 2
  and len(body) <= 200
  and posts.owneruserid = users.id
  and users.reputation < 20
  and posts.CommunityOwnedDate is null
group by parentid
having count(posts.id) > 1
) x
inner join Posts p
on p.Id = x.ParentId
order by Counter desc, p.ViewCount desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached