Tag wikis with internal http:// links

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT DISTINCT
  Tags.Id,
  Tags.TagName,
  'site://tags/' + Tags.Tagname + '/info|Url' AS Url,
  len(Posts.Body)
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://__.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://___.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://____.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://_____.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://______.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://_______.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://________.stackexchange.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://_________.stackexchange.com%'
  OR
  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://_.stackoverflow.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://__.stackoverflow.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://___.stackoverflow.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://____.stackoverflow.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://serverfault.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://___.serverfault.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://____.serverfault.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://superuser.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://___.superuser.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://____.superuser.com%'
  OR
  LOWER(Posts.Body) LIKE '%http://i.stack.imgur.com%'
  )
ORDER BY Tags.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results