UPDATE "FeaturedSections"
SET quiz_ids = (
SELECT array_agg(quiz_id ORDER BY count DESC)
FROM (
SELECT quiz_id, COUNT(*) AS count
FROM "UserVotes"
WHERE created_at >= NOW() - INTERVAL '1 year'
AND is_liked = true
GROUP BY quiz_id
ORDER BY count DESC
LIMIT 10
) AS top_quizzes
)
WHERE title = 'Most Loved Quizzes'
returning
quiz_ids;
UPDATE "FeaturedSections"
SET quiz_ids = (
SELECT array_agg(quiz_id ORDER BY count DESC)
FROM (
SELECT quiz_id, COUNT(*) AS count
FROM "UserVotes"
WHERE created_at >= NOW() - INTERVAL '1 year'
AND is_liked = true
GROUP BY quiz_id
ORDER BY count DESC
LIMIT 10
) AS top_quizzes
)
WHERE title = 'Most Loved Quizzes'
returning
quiz_ids;