SELECT DISTINCT a.clerk_id
FROM SUNO_PROD.PROD.BOT_HOURLY b
JOIN SUNO_PROD.PROD.RDS_DISCORD_INFO a
ON b.user_id = a.user_id
LEFT JOIN SUNO_PROD.PROD.DAGSTER_CLERK_REFUNDS c
ON a.clerk_id = c.clerk_id
WHERE b.meets_bot_definition
AND b.user_joined_at > DATEADD(DAY, -30, CURRENT_DATE)
AND b.play_count = 0
AND b.are_clip_metrics_healthy
AND (
    c.clerk_id IS NULL
    OR c.status_code IS NULL
    OR c.status_code != 200
)
LIMIT 30000
