คำถามที่มีการติดแท็ก (รวมถึงผู้แก้ไขที่เพิ่มด้วย) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions which had given tag (included the editor who added it).It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
WITH firstrev_cte AS (SELECT p.Id AS pid, MIN(ph.Id) AS MinId FROM PostHistory AS ph INNER JOIN Posts AS p ON ph.PostId = p.Id WHERE ph.PostHistoryTypeId IN (3, 6, 9) AND ph.Text LIKE '%<##tagName##>%' GROUP BY p.Id) SELECT pid AS "post_link", url = 'site://posts/' + CAST(PostId AS TEXT) + '/revisions', UserId AS "user_link", UserDisplayName FROM PostHistory INNER JOIN firstrev_cte ON PostHistory.Id = MinId