This query is marked as a draft This query has been published by Dispenser.

SQL

x
 
SELECT
  CONCAT("[[:File:", REPLACE(transcode_image_name, "_", " "), "]]") AS "File",
  ROUND(img_size / 1024 / 1024, 1) AS "Size (MB)",
  GROUP_CONCAT(transcode_key ORDER BY 1 SEPARATOR ", ") AS "Video key",
  REPLACE(REGEXP_REPLACE(
   SUBSTRING_INDEX(SUBSTRING_INDEX(transcode_error, "Exitcode: ", -1), "\n", 1),
   "mwstore[&:][^ \"]+", "[snipped]"),
   CONCAT("File:", REPLACE(transcode_image_name,"_"," "), ": "), ""
  ) AS Exitcode
FROM transcode
JOIN image ON img_name=transcode_image_name /* Rename check */
WHERE transcode_time_addjob>=img_timestamp
AND (transcode_time_success IS NULL OR transcode_time_success<transcode_time_error)
GROUP BY transcode_image_name;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...