SEDE cannot handle very basic query to show all comments with scores greater than zero

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/412188

Emacs

Q&A for those using, extending or developing Emacs

SELECT CONCAT(
           'site://q/'
         , Posts.Id
         , '|'
         , CASE WHEN Posts.PostTypeId = 1 THEN 'Q' ELSE 'A' END
         , ' - '
         , Questions.Title) [Link]
     , Comments.Score
     , Comments.Text
FROM 
    Comments
INNER JOIN
    Posts ON Posts.Id = Comments.PostId
INNER JOIN 
    Posts Questions ON Questions.Id = COALESCE(Posts.ParentId, Posts.Id)
WHERE Comments.Score > 0
ORDER BY Comments.Score Desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results