Votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 20 Title, ViewCount, AnswerCount, PostTypeId
FROM Posts as P, PostTags as PT
WHERE P.Id=PT.PostId and PT.TagId = 3

SELECT TOP 20 Title, ViewCount, AnswerCount, postTypeId
FROM Posts 
WHERE id IN (SELECT PostId FROM PostTags WHERE TagId = 3)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results