Post Query

1

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language Meta

Q&A about the site for linguists, teachers and students of the Korean language

declare @epoch as datetime = DATEADD(WEEK, - ##Weeks:int?52## - 1, CURRENT_TIMESTAMP)
;



SELECT 
  TOP 10 
    *
FROM Posts
WHERE Posts.Id IN
  (SELECT Id
    FROM Posts
    WHERE
    Posts.Score > 0 
    AND Posts.Tags LIKE '##Tag##'
    AND Posts.AnswerCount > 0
    AND Posts.AcceptedAnswerId is NOT NULL
    AND Posts.CreationDate > @epoch
    )
ORDER BY AnswerCount Desc

Enter Parameters

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