s ตามแท็ก ไม่จำเป็นต้องใช้ทุกตาราง
s by tag.It is not neccessary to use all the tables.
 Tags:  Id [ number]  TagName [ text]  Count [ number]  ExcerptPostId [ number]  WikiPostId [ number] 
SELECT 'post_link' = Posts.Id, Posts.ViewCount, Posts.Score, Tags.TagName AS "tag_name" FROM PostHistory INNER JOIN PostTags ON PostTags.PostId = PostHistory.PostId INNER JOIN Tags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON PostTags.PostId = Posts.Id WHERE PostHistory.PostHistoryTypeId = 19 AND Tags.TagName = @TagName ORDER BY Posts.ViewCount DESC LIMIT 100