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 5 P.Id as [PostLink],P.Score,P.ViewCount
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 X.PostLink,X.Score,X.ViewCount,MAX(C.Score)
FROM X JOIN Comments C ON X.PostLink=C.PostId
GROUP BY X.PostLink,X.Score,X.ViewCount

fork query

edited sep 6 anonymous

created may 25 10 sam.saffron