0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT DISTINCT
  P.Id as [Post Link]
  ,P.Score
FROM Comments C
JOIN Posts P ON P.Id = C.PostId
WHERE
  P.ClosedDate IS NULL
  AND P.Score >= 0
  AND c.userid = ##userid##
  AND p.OwnerUserId = ##userid##
  AND C.CreationDate < '2022-12-15'
ORDER BY P.Id DESC, p.score DESC

fork query

edited dec 26 James.Risner

created dec 25 anonymous