SELECT user_id as entity_id, email
FROM SUNO_PROD.PROD.BOT_HOURLY
WHERE meets_bot_definition
AND most_recent_activity_date > DATEADD(DAY, -2, CURRENT_DATE)
AND email_domain IN ('hotmail.com', 'outlook.com')
AND most_recent_plan IS NULL
AND play_count = 0
AND are_clip_metrics_healthy
ORDER BY most_recent_activity_date DESC
