Am I quality banned for questions?

2

Please login or register to vote for this query.

(click on this box to dismiss)

Deleted questions Negative voted Closed Enter missing values manual

Christianity

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

/* (total questions - negative questions - closed - deleted) / total questions >= 0.5
*/

-- negdel:# negative deleted posts "deleted recent posts link is in your profile "
-- closedel:# closed deleted posts
-- deleted:# deleted posts
-- userid:Your userid

declare @negdeleted as integer = ##negdel:int?0##
declare @closeddeleted as integer = ##closedel:int?0##



select (([total] + [deleted]) -
        ([negative] + @negdeleted) -
        ([closed] + @closeddeleted ) -
        [deleted])
        / ([total] + [deleted]) [Q-ban when < 0.5] 
from 
(
select cast(count(*) as decimal) as [total]
     , sum(case when score < 0 then 1 else 0 end) [negative]
     , sum(case when closeddate is not null then 1 else 0 end) [closed]
     , ##deleted:int?0## [deleted]
from posts
where posttypeid = 1 
and owneruserid = ##userid:int?5022624##
) as rawdata

Enter Parameters

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