tag wiki excerpts with promotional vocabulary + Google

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT DISTINCT
  Tags.Id,
  Tags.TagName,
  'site://tags/' + Tags.Tagname + '/info|Url' AS Info,
  'https://www.google.com/search?q=' +
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  REPLACE(
  Posts.Body
  ,' ','+')
  ,char(10),'+')
  ,char(13),'+')
  ,char(39),'+')
  ,'.','+')
  ,',','+')
  ,'"','+')
  ,'`','+')
  ,'(','+')
  ,')','+')
  ,'<','+')
  ,'>','+')
  ,'!','+')
  + '|Url' AS Google,
  Posts.Body,
  len(Posts.Body) as Len,
  Posts.CreationDate as Creation,
  Posts.LastEditDate as LastEdit
FROM Tags
LEFT JOIN Posts ON Posts.Id = Tags.ExcerptPostId
WHERE len(Posts.Body) > 0
ORDER BY len(Posts.Body) DESC

Enter Parameters

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