SELECT count(*) AS stale_cron_count FROM dot_tools WHERE trigger_type = 'cron' AND status IN ('active','published') AND last_executed IS NOT NULL AND last_executed < NOW() - INTERVAL '7 days'