Posts deleted by VoteType 4

1

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

SELECT
  Votes.*,
  'site://q/' + CAST(COALESCE(PostsWithDeleted.ParentId, Votes.PostId) AS
    VARCHAR(MAX)) + '|Link' AS Link,
  'site://posts/' + CAST(Votes.PostId AS VARCHAR(MAX)) + '/revisions|Revisions'
    AS Revisions
FROM Votes, PostsWithDeleted
WHERE
  Votes.PostId = PostsWithDeleted.Id
  AND
  Votes.VoteTypeId = 4
ORDER BY Votes.Id DESC;

Enter Parameters

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