DECLARE @Question INT = (SELECT Id FROM PostTypes WHERE N...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

DECLARE @Question INT = (SELECT Id FROM PostTypes WHERE Name = 'Question');

SELECT
  [Post Link] = Posts.Id
  , Posts.Score
  , [Tags] = Posts.Tags
  , Posts.CreationDate

FROM Posts
INNER JOIN PostTags ON Posts.Id = PostTags.PostId
INNER JOIN Tags ON Tags.Id = PostTags.TagId

WHERE Tags.TagName IN ('code-size-optimization', 'minification')
AND Posts.PostTypeId = @Question
ORDER BY Posts.CreationDate ASC

Enter Parameters

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