answers that should have votes

2

Please login or register to vote for this query.

(click on this box to dismiss)

answers by specified user(s) that "should" have votes

Moderators

Q&A for community managers, administrators, and moderators

select 
  id as [Post Link],
  case when acceptedanswerid is null then 0 else 1 end as accepted, 
  format(creationdate,'YYYY-MM-dd') as answered,
  len(body) as length
from posts
where posttypeid=2
and owneruserid in ( ##UserID## )
and score <=0
order by 
  case when acceptedanswerid is null then 0 else 1 end desc,
  len(body) desc

Enter Parameters

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