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 50 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 [PostLink],MAX(P.Score),MAX(P.ViewCount)
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