High views, high votes short answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of questions with a high score and low view count

Stack Overflow

Q&A for professional and enthusiast programmers

-- High views, high votes short answer
-- This serves to present frequently viewed questions which 
-- accepted an answer with a very short post
select 
        top 500 a.Id as [Post Link], 
        a.Score, 
        a.ViewCount,
        a.AcceptedAnswerId
from 
        Posts a
INNER JOIN Posts q ON a.AcceptedAnswerId = q.Id
where 
        a.Score > 2 and 
        a.ViewCount <> 0 and 
        a.PostTypeId = 1 and
        a.Id < 100000 and
        Len(q.Body) < 300
order by 
        ViewCount asc

Enter Parameters

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