SELECT P.Id AS [Post Link], F.[Count] AS [ModFlagsViewed]...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

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
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results