0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT
    *
FROM
    Posts p
WHERE
    EXISTS
  ( SELECT
        COUNT(1)
    FROM
        Votes v
    WHERE
        v.PostId = p.Id
    AND (   v.VoteTypeId = 2
        OR  v.VoteTypeId = 3
        )
  )
AND 
  ( SELECT
        COUNT(1)
    FROM
        Votes v
    WHERE
        v.PostId = p.Id
    AND v.VoteTypeId = 2
  ) =
  ( SELECT
        COUNT(1)
    FROM
        Votes v
    WHERE
        v.PostId = p.Id
    AND v.VoteTypeId = 3
  )

fork query

edited may 26 20

created may 26 20 anonymous