Top 50 Users Who May Need Some Feedback For Improvement

2

Please login or register to vote for this query.

(click on this box to dismiss)

These users have concerning usage.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select top 50
  u.Id as [User Link],
  u.Reputation, 
  up.Votes as [(+)],
  down.Votes as [(-)],
  recent.Closed as [Recent Closed],
  u.LastAccessDate
from Users u
cross apply
  (   
      select
        count(*)
      from
        posts inner join
        votes on posts.Id = votes.PostId
      where 
        posts.OwnerUserId = u.Id
        and votes.VoteTypeId = 3
        and ((posts.PostTypeId = 1) or (posts.PostTypeId = 2))
  ) as down(Votes)
cross apply
  (   
      select
        count(*)
      from
        posts inner join
        votes on posts.Id = votes.PostId
      where 
        posts.OwnerUserId = u.Id
        and votes.VoteTypeId = 2
        and ((posts.PostTypeId = 1) or (posts.PostTypeId = 2))
  ) as up(Votes)
cross apply
  (
      select 
        count(*) 
      from Posts 
      where 
        OwnerUserId = u.Id
        and ParentId is null
        and ClosedDate is not null
        and ClosedDate >= dateadd(year, -1, getdate())
  ) as recent(Closed)
where
  u.LastAccessDate >= dateadd(year, -1, getdate())
  and u.Reputation < 200
  and down.Votes > up.Votes
  and ((down.Votes > 1)
  or (recent.Closed > 0))
order by u.LastAccessDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results