WITH
  monthly_items AS (
    SELECT
      DATE_FORMAT(FROM_UNIXTIME(time), '%Y-%m-01') AS month,
      type
    FROM
      items
    WHERE
      deleted = 0
      AND dead = 0
      AND time >= UNIX_TIMESTAMP('2023-01-01')
  ),
  monthly_counts AS (
    SELECT
      month,
      type,
      COUNT(*) AS count
    FROM
      monthly_items
    GROUP BY
      month,
      type
  )
SELECT
  month,
  SUM(
    CASE
      WHEN type = 'story' THEN count
      ELSE 0
    END
  ) AS new_stories,
  SUM(
    CASE
      WHEN type = 'comment' THEN count
      ELSE 0
    END
  ) AS new_comments
FROM
  monthly_counts
GROUP BY
  month
ORDER BY
  month ASC
LIMIT
  20;