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.