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