0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

SELECT *

FROM PostHistory H

INNER JOIN Posts P on P.Id = H.PostId

CROSS APPLY openjson(text, '$.Voters') WITH (Id integer  '$.Id') V

WHERE H.PostHistoryTypeId = 10 AND V.Id = 88163

ORDER BY ClosedDate DESC

fork query

edited jan 15 24

created dec 12 22 anonymous