คำถามที่มีแท็กเฉพาะในตอนนี้และไม่ใช่ในการแก้ไขครั้งแรก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions with a specific tag now and not at first revision.It is not neccessary to use all the tables.
 Badges:  Id [ number]  UserId [ number]  Name [ text]  Date [ time]  Class [ number]  TagBased [ boolean] 
SELECT Posts.Id AS "post_link", Posts.Tags, PostInits.Text AS "initial_tags", Posts.CreationDate FROM Posts INNER JOIN (SELECT PostId, Text FROM PostHistory WHERE PostHistoryTypeId = 3 AND NOT Text LIKE '%##Tag##%') AS PostInits ON Posts.Id = PostInits.PostId WHERE Posts.Tags LIKE '%##Tag##%' AND (DATEDIFF(month, Posts.CreationDate, GETDATE()) <= '##MaxQuestionAgeInMonths:int?24##') AND (DATEDIFF(month, Posts.CreationDate, GETDATE()) >= '##MinQuestionAgeInMonths:int?0##') ORDER BY CreationDate DESC