0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/280695/how-to-find-the-post-having-highest-upvote-without-any-downvote

Q&A for researchers, developers, and users of Tor

select top 1000 p.id as [Post Link]
      , posttypeid 
      ,score 
from posts p
left outer join votes v on v.postid = p.id and votetypeid =##votetypeid##
and posttypeid in (1,2)
and v.id is null
order by score desc

fork query

edited jul 21 anonymous

created jun 29 16 rene