Untitled query #18408

SQL

SELECT
  CONCAT("[[:File:", REPLACE(transcode_image_name, "_", " "), "]]") AS "File",
  CONCAT("align=right | ", 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 Exitcode, transcode_image_name
ORDER BY img_media_type, Exitcode, transcode_image_name;
SQL

Checking query status...
