Close Votes by User (with Links)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT Id, PostId as [Post Link], CreationDate, Text, (SELECT (LEN(Text) - LEN(REPLACE(Text, 'DisplayName', '')))/11) as [Total Voters], (SELECT 'TRUE' WHERE Text Like '%"OriginalQuestionIds"%') as [IsDuplicate]
FROM PostHistory
WHERE PostHistoryTypeId = 10 AND CreationDate > ##SinceDate##
AND Text LIKE '%"Id":' + CAST(##UserId## AS nvarchar) + ',%'

Enter Parameters

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