Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
SELECT p.Id AS [Post Link], p.CreationDate AS [Date], p.Score AS [Score], p.Tags FROM Posts p JOIN PostTags pt ON pt.PostId = p.Id JOIN Tags t ON t.Id = pt.TagId AND t.TagName = '##Tag##' WHERE p.PostTypeId = 1 AND p.AnswerCount > 0 AND p.CreationDate > '2002-04-28' AND p.closeddate is null AND p.Body like '%##casesensitiveKeyword##%' AND LEN(p.Body) < 500 AND p.Score > 0 ORDER BY p.Score ASC