-- Author: fruit.com.cn
-- 收口未绑定分集或媒资不存在的僵尸转码任务（可重复执行）

BEGIN;

UPDATE transcode_task t
SET status = 'FAILED',
    error_msg = '历史任务无效：episode_id=0 或 media_asset_id 指向不存在的媒资，请从有视频的分集重新转码',
    finished_at = CURRENT_TIMESTAMP
WHERE t.deleted = 0
  AND t.status IN ('QUEUED', 'RUNNING')
  AND (
    t.episode_id = 0
    OR NOT EXISTS (
      SELECT 1
      FROM media_asset a
      WHERE a.id = t.media_asset_id
        AND a.deleted = 0
    )
  );

COMMIT;