0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for contractors and serious DIYers

SELECT
  P.Id AS [Post Link],
  F.[Count] AS [ModFlagsViewed]
FROM PostsWithDeleted P
JOIN (
SELECT
  V.PostId,
  COUNT(*) AS [Count]
FROM Votes V
WHERE V.VoteTypeId = 15 AND V.Id > 261094248
GROUP BY V.PostId
HAVING COUNT(*) >= 3
) F ON F.PostId = P.Id
WHERE
  P.PostTypeId = 2
  AND P.CreationDate > '2022-11-30'
ORDER BY F.[Count] DESC
;

fork query

edited mar 2

created mar 2 anonymous