SELECT COUNT(V.Id), PL.PostId AS [Post Link] FROM Votes V...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--WITH Questions AS (
SELECT
  COUNT(V.Id),
  PL.PostId AS [Post Link]
FROM
  Votes V
  INNER JOIN PostLinks PL ON (PL.PostId = V.PostId)
WHERE V.VoteTypeID = 3
GROUP BY PL.PostId

/**SELECT 
  PL.PostId AS [Post Link],
  COUNT(V.Id)
FROM
  PostLinks PL
  INNER JOIN Votes V ON (PL.PostId = V.PostId)
WHERE
 PL.LinkTypeId = 3
 AND V.VoteTypeId = 3
GROUP BY V.PostId
--)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results