0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners of the art and science of signal, image and video processing

-- Enter Query Title
-- Enter Query Description
WITH posts_with_votes(ID) AS (
   SELECT p.ID
   FROM Posts p
      JOIN Posts aa ON aa.ParentId = p.Id
      JOIN Votes v ON v.PostId = aa.Id
   WHERE aa.PostTypeId = 2
    AND p.PostTypeId = 1
    AND v.VoteTypeId = 2
   GROUP BY p.Id
)
SELECT *
FROM Posts
WHERE AcceptedAnswerId IS NOT NULL
AND ID NOT IN (SELECT ID FROM posts_with_votes)
AND Posts.PostTypeId = 1

fork query

created jan 21 11 anonymous