Common typos in tag wiki

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

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
  (
  -- frequent
  
  LOWER(Posts.Body) LIKE '%usefull%'
  OR
  LOWER(Posts.Body) LIKE '%offical%'
  OR
  LOWER(Posts.Body) LIKE '%program[ae][^cpxr]%'
  OR
  LOWER(Posts.Body) LIKE '%seperat%'
  OR
  LOWER(Posts.Body) LIKE '%calender%'
  OR
  LOWER(Posts.Body) LIKE '%boostrap%'
  OR
  LOWER(Posts.Body) LIKE '%formating%'
  OR
  LOWER(Posts.Body) LIKE '%databse%'
  OR
  LOWER(Posts.Body) LIKE '%adress%'
  OR
  LOWER(Posts.Body) LIKE '%extention%'
  OR
  LOWER(Posts.Body) LIKE '%standart%'
  
  -- less frequent
  
  OR
  LOWER(Posts.Body) LIKE '%mutipl%'
  OR
  LOWER(Posts.Body) LIKE '%statment%'
  OR
  LOWER(Posts.Body) LIKE '%diffrent%'
  OR
  LOWER(Posts.Body) LIKE '%embeded%'
  OR
  LOWER(Posts.Body) LIKE '%coodinate%'
  OR
  LOWER(Posts.Body) LIKE '%debuging%'
  )
ORDER BY Tags.Id

Enter Parameters

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