0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

SELECT TOP 50
  post.Id AS [Post Link],
  post.Score,
  postType.Name,
  post.CreationDate
FROM
  Posts post
INNER JOIN
  PostTypes postType ON
    postType.Id = post.PostTypeId
WHERE
  post.Score < 0
  AND post.ClosedDate IS NULL
  AND post.PostTypeId IN (1, 2)
 
  AND EXISTS
  (
    SELECT
      comment.PostId
    FROM
      Comments comment
    WHERE
      comment.PostId = post.Id
    GROUP BY
      comment.PostId
    HAVING
      COUNT(*) > 0
  )
ORDER BY
  --post.PostTypeId DESC,
  post.Score ASC

fork query

edited may 24 17 anonymous

created jan 7 14 MetaFight