Prisma is awesome. I love this!

most-popular-posts.ts

async function getMostPopularPostSlugs({
  limit,
  exclude,
}: {
  limit: number
  exclude: Array<string>
}) {
  const result = await prisma.postRead.groupBy({
    by: ['postSlug'],
    _count: true,
    orderBy: {
      _count: {
        postSlug: 'desc',
      },
    },
    where: {
      postSlug: {notIn: exclude},
    },
    take: limit,
  })

  return result.map(p => p.postSlug)
}