Get my public votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

-- Get my public votes. (Unfotunately upvotes and downvotes are not exportable: https://meta.stackexchange.com/questions/315022/why-does-this-simple-data-explorer-query-only-return-124-rows-instead-of-4-912/315023?noredirect=1#comment1032551_315023)
SELECT v.id, v.VoteTypeId, v.CreationDate
  , p.Title, p.Id as [Post Link]
FROM Votes v
LEFT JOIN Posts p
ON v.Postid = p.id
WHERE v.UserId = ##UserID##
AND v.VoteTypeId IN (2, 5, 8)
ORDER BY v.CreationDate DESC

Enter Parameters

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