1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT
  Posts.Id AS [Post Link],
  Posts.OwnerUserId AS [User Link],
  Posts.Score
FROM Posts
LEFT JOIN Comments ON
  Comments.PostId = Posts.Id
  AND
  Comments.UserId <> Posts.OwnerUserId
  AND
  Comments.UserId > 1
WHERE
  Comments.Id IS NULL
  AND
  Posts.OwnerUserId > 1
  AND
  Posts.Score < 0
ORDER BY Posts.Score, Posts.Id

fork query

edited feb 22 19

created feb 22 19 peterh - PLEASE DELETE THIS ACCOUNT