All tags with excerpt

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT
   A.TagName AS TagName 
  ,A.Count AS TagCount 
  ,COALESCE(B.Body,'') AS Excerpt
FROM Tags AS A 
   LEFT JOIN Posts AS B ON A.ExcerptPostId = B.ID
-- ORDER BY TagCount DESC
ORDER BY TagName ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results