SELECT TOP 1 p.Id as [PostLink] FROM Posts p JOIN Votes v...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT TOP 1 p.Id as [PostLink] 
FROM Posts p
JOIN Votes v
ON v.PostId = p.Id
WHERE p.PostTypeId = 1
AND V.VoteTypeId = 12

/*
SELECT PostId AS [Post Link],
       'site://q/' + CAST(PostId as nvarchar) AS [Alt Link],
       CreationDate
FROM   Votes
WHERE  VoteTypeId = 12 -- Spam
ORDER  BY CreationDate DESC*/

Enter Parameters

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