โพสต์ที่มีแท็กที่มีคนดูมากที่สุดกลายเป็นคำพ้องความหมาย ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most viewed posts with tags became synonyms.It is not neccessary to use all the tables.
 Users:  Id [ number]  Reputation [ number]  CreationDate [ time]  DisplayName [ text]  LastAccessDate [ time]  WebsiteUrl [ text]  Location [ text]  AboutMe [ text]  Views [ number]  UpVotes [ number]  DownVotes [ number]  ProfileImageUrl [ text]  EmailHash [ text]  AccountId [ number] 
WITH Raw AS (SELECT TagName FROM Tags INTERSECT SELECT SourceTagName AS TagName FROM TagSynonyms WHERE NOT ApprovalDate IS NULL) SELECT DENSE_RANK() OVER (ORDER BY Posts.ViewCount DESC) AS N, Posts.Id AS "post_link", Posts.ViewCount, 'site://tags/' + TagSynonyms.SourceTagName + '|' + TagSynonyms.SourceTagName AS SourceTag, 'site://tags/' + TagSynonyms.TargetTagName + '|' + TagSynonyms.TargetTagName AS TargetTag FROM Raw, Tags, PostTags, TagSynonyms, Posts WHERE Raw.TagName = Tags.TagName AND Tags.Id = PostTags.TagId AND PostTags.PostId = Posts.Id AND Raw.TagName = TagSynonyms.SourceTagName ORDER BY Posts.ViewCount DESC, Posts.Id LIMIT 20000