0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT TOP 1000 Posts.Id AS [Post Link], 
               Posts.Score, 
               Posts.ViewCount 
FROM   Posts 
       INNER JOIN Comments AS ClarifyingQuestion
               ON ClarifyingQuestion.PostId = Posts.Id 
       INNER JOIN Comments AS ClarifyingAnswer
               ON ClarifyingAnswer.PostId = Posts.Id 
       INNER JOIN Posts AS FinalAnswer
               ON Posts.AcceptedAnswerId = FinalAnswer.Id 
WHERE  Posts.Score > 0 
       AND Posts.ParentId IS NULL 
       AND Posts.CommentCount < 5
       AND Posts.CommentCount > 0
       AND ClarifyingQuestion.Text LIKE '%?' 
       AND ClarifyingQuestion.UserId = FinalAnswer.OwnerUserId 
       AND ClarifyingAnswer.UserId = Posts.OwnerUserId 
       AND FinalAnswer.OwnerUserId <> Posts.OwnerUserId 
GROUP  BY Posts.Id, 
          Posts.Score, 
          Posts.ViewCount 
ORDER  BY ViewCount ASC

fork query

edited mar 8 20

created mar 8 20 anonymous