ความคิดเห็นในแท็กที่กำหนด (ระหว่างวันที่สองวัน) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Comments in a given tag (between two dates).It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT c.UserId AS "user_link", c.CreationDate, c.Id AS "comment_link", c.PostId AS "post_link", c.Text FROM (Comments AS c JOIN Posts AS p ON c.PostId = p.Id) WHERE (p.PostTypeId = 1) AND (p.Tags LIKE '%<##tagName?gn.general-topology##>%') AND (c.CreationDate >= '##Date1##') AND (c.CreationDate <= '##Date2##') UNION SELECT c.UserId AS "user_link", c.CreationDate, c.Id AS "comment_link", c.PostId AS "post_link", c.Text FROM Comments AS c JOIN Posts AS p ON c.PostId = p.Id JOIN Posts AS q ON p.ParentId = q.Id WHERE (p.PostTypeId = 2) AND (q.Tags LIKE '%<##tagName?gn.general-topology##>%') AND (c.CreationDate >= '##Date1##') AND (c.CreationDate <= '##Date2##') ORDER BY c.CreationDate DESC