Tags with descriptions

WITH tag_counts AS (
  SELECT 
    tag, 
    description,
    (SELECT count(DISTINCT entry_id) 
     FROM blog_entry_tags 
     WHERE blog_entry_tags.tag_id = blog_tag.id) AS entry_count,
    (SELECT count(DISTINCT blogmark_id) 
     FROM blog_blogmark_tags 
     WHERE blog_blogmark_tags.tag_id = blog_tag.id) AS blogmark_count,
    (SELECT count(DISTINCT quotation_id) 
     FROM blog_quotation_tags 
     WHERE blog_quotation_tags.tag_id = blog_tag.id) AS quotation_count
  FROM blog_tag
  WHERE description IS NOT NULL AND description != ''
)
SELECT 
  tag,
  'https://simonwillison.net/tags/' || tag || '/' as url,
  description,
  (entry_count + blogmark_count + quotation_count) AS post_count,
  entry_count,
  blogmark_count,
  quotation_count
FROM tag_counts