Find shortest YouTube Videos in answers

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.

Gardening and Landscaping Meta

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
  LEN(Body) as BodyLength, 
  Score AS "Score",
  Id AS [Post Link],
  Tags
FROM
  Posts
WHERE
  PostTypeId = 2 AND
  (Body LIKE '%http://www.youtube.com/watch%' OR
  Body Like '%http://www.youtube.com/v/%')
ORDER BY
  LEN(Body)

Enter Parameters

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