Q&A for professional and enthusiast programmers
DECLARE @w40 datetime = '2013-09-29 00:00:00.000' DECLARE @w41 datetime = '2013-10-07 00:00:00.000' DECLARE @w42 datetime = '2013-10-14 00:00:00.000' DECLARE @w43 datetime = '2013-10-21 00:00:00.000' DECLARE @w44 datetime = '2013-10-28 00:00:00.000' DECLARE @w45 datetime = '2013-11-04 00:00:00.000' DECLARE @w46 datetime = '2013-11-11 00:00:00.000' DECLARE @w47 datetime = '2013-11-18 00:00:00.000' DECLARE @w48 datetime = '2013-11-25 00:00:00.000' DECLARE @w49 datetime = '2013-12-02 00:00:00.000' DECLARE @w50 datetime = '2013-12-09 00:00:00.000' DECLARE @w51 datetime = '2013-12-16 00:00:00.000' DECLARE @w52 datetime = '2013-12-23 00:00:00.000' SELECT p.Id as [Post Link], p.CreationDate, p.Score FROM Posts p INNER JOIN PostTags pt ON p.ParentId = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id INNER JOIN Posts q ON q.Id = p.ParentId WHERE q.PostTypeId = 1 AND t.TagName IN ('prism', 'prism-4', 'prism-2') AND @w45 < (select top 1 ans.CreationDate from Posts ans where ans.ParentId = q.Id order by ans.CreationDate asc) AND @w46 > (select top 1 ans.CreationDate from Posts ans where ans.ParentId = q.Id order by ans.CreationDate asc) GROUP BY p.Id, p.CreationDate, p.Score ORDER BY p.CreationDate desc