Reprocess specific transcoded videos?

SELECT 
    SUBSTRING("originalFileName" FROM '\.([^\.]+)$') AS ext,
    CASE 
        WHEN "encodedVideoPath" IS NULL 
        THEN NULL
        ELSE 'encoded'
    END AS encoded,
    COUNT(*) AS count
FROM asset
WHERE type = 'VIDEO'
GROUP BY 1,2 ORDER BY 1,2;

SELECT 
    SUBSTRING("originalFileName" FROM '\.([^\.]+)$') AS ext,
    CASE 
        WHEN "encodedVideoPath" IS NULL 
        THEN NULL
        ELSE 'encoded'
    END AS encoded,
    COUNT(*) AS count
FROM asset
WHERE type = 'VIDEO'
GROUP BY 1,2 ORDER BY 1,2;

SELECT 
    LOWER(SUBSTRING("originalPath" FROM '\.([^\.]+)$')) AS ext,
    CASE 
        WHEN "encodedVideoPath" IS NULL 
        THEN NULL
        ELSE 'encoded'
    END AS encoded,
    CASE
        WHEN "originalPath" LIKE '%-MP.%'
        THEN 'MP'
        ELSE NULL
    END AS mp,
    COUNT(*) AS count
FROM asset
WHERE type = 'VIDEO'
GROUP BY 1, 2, 3 ORDER BY 1, 2, 3;

SELECT 
    LOWER(SUBSTRING("originalPath" FROM '\.([^\.]+)$')) AS ext,
    CASE 
        WHEN "encodedVideoPath" IS NULL 
        THEN NULL
        ELSE 'encoded'
    END AS encoded,
    CASE
        WHEN "originalPath" LIKE '%-MP.%'
        THEN 'MP'
        ELSE NULL
    END AS mp,
    COUNT(*) AS count
FROM asset
WHERE type = 'VIDEO'
GROUP BY 1, 2, 3 ORDER BY 1, 2, 3;

    if (target === TranscodeTarget.None && !this.isRemuxRequired(ffmpeg, format)) {
      if (asset.encodedVideoPath) {
        this.logger.log(\`Transcoded video exists for asset ${asset.id}, but is no longer required. Deleting...\`);
        await this.jobRepository.queue({ name: JobName.FileDelete, data: { files: [asset.encodedVideoPath] } });
        await this.assetRepository.update({ id: asset.id, encodedVideoPath: null });
      } else {
        this.logger.verbose(\`Asset ${asset.id} does not require transcoding based on current policy, skipping\`);
      }

    if (target === TranscodeTarget.None && !this.isRemuxRequired(ffmpeg, format)) {
      if (asset.encodedVideoPath) {
        this.logger.log(\`Transcoded video exists for asset ${asset.id}, but is no longer required. Deleting...\`);
        await this.jobRepository.queue({ name: JobName.FileDelete, data: { files: [asset.encodedVideoPath] } });
        await this.assetRepository.update({ id: asset.id, encodedVideoPath: null });
      } else {
        this.logger.verbose(\`Asset ${asset.id} does not require transcoding based on current policy, skipping\`);
      }