Unlocked Questions From High Reputation Users Without Accepted Answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select top 25000
  q.Id as [Post Link],
  (select count(*) from Posts where ParentId = q.Id) as [Answers],
  q.Score,
  u.Id as [User Link],
  u.Reputation

from
  Posts q
  inner join Users u
             on q.OwnerUserId = u.Id

where
  q.PostTypeId = 1 -- a Question
  and q.AcceptedAnswerId is null
  and q.ClosedDate is null
  and q.CommunityOwnedDate is null
  and q.Score >= 0
  and (select count(*) from PostHistory
       where PostId = q.Id and PostHistoryTypeId = 14) -- Locked
      <= (select count(*) from PostHistory              --- no more times than
          where PostId = q.Id and PostHistoryTypeId = 15) -- Unlocked

order by 
  log(cast(u.Reputation as float))
  + (case when q.Score > 0
               then log(cast(q.Score as float))
               else 0.0 end) 
  + log(cast(q.Id as float)) / log(100000.0)
  - (select count(*) from Posts where ParentId = q.Id) / 2
  desc

Enter Parameters

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