0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists shortest answers which are containing a link against YouTube-Videos.

Q&A about the site for gardeners and landscapers

-- Find shortest YouTube Videos in answers
-- Lists shortest answers which are containing a link against YouTube-Videos.

SELECT
  top 500
  LEN(Body) as BodyLength, 
  Score AS "Score",
  Id AS [Post Link],
  Tags
FROM
  Posts
INNER JOIN 
   PostTags ON ParentId = PostTags.PostId
WHERE
  PostTypeId = 2 AND
  (Body LIKE '%http://www.youtube.com/watch%' OR
  Body Like '%http://www.youtube.com/v/%')
ORDER BY
  LEN(Body)

fork query

created may 3 11 YOU