แท็กวิกิด้วยลิงก์ http// ภายใน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Tag wikis with internal http// links.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT DISTINCT Tags.Id, Tags.Count, Tags.TagName, 'site://tags/' + Tags.TagName + '/info|Url' AS Url FROM Tags LEFT JOIN Posts ON Posts.Id = Tags.WikiPostId OR Posts.Id = Tags.ExcerptPostId WHERE (LOWER(Posts.Body) LIKE '%http://%.stackexchange.com%' OR LOWER(Posts.Body) LIKE '%http://stackexchange.com%' OR LOWER(Posts.Body) LIKE '%http://%.stackoverflow.com%' OR LOWER(Posts.Body) LIKE '%http://%.serverfault.com%' OR LOWER(Posts.Body) LIKE '%http://%.superuser.com%') ORDER BY Tags.Count