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

Q&A for Drupal developers and administrators

WITH X AS (
SELECT TOP 100 P.Id
from Posts P
where P.Score > 2 and
P.ViewCount >= 10000 and
P.ParentId is null and 
P.AcceptedAnswerId is null and
P.ClosedDate is null and
P.body like '%python%')
SELECT P.Id as [Post Link],MAX(P.Score) as PostScore,MAX(P.ViewCount) as ViewCount,MAX(C.Score) as BestCommentScore
FROM X JOIN Comments C ON X.Id=C.PostId
JOIN Posts P ON X.Id=P.Id
GROUP BY P.Id
HAVING MAX(C.Score)=0

fork query

edited sep 6 anonymous

created may 25 10 sam.saffron