instruction: Tag wikis with internal http:// links ordered by use.
response: 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%' OR LOWER(Posts.Body) LIKE '%http://%.wikipedia.org%') ORDER BY Tags.Count