Skip to content

Instantly share code, notes, and snippets.

@MKorostoff
Created January 13, 2014 22:28
Show Gist options
  • Save MKorostoff/8409339 to your computer and use it in GitHub Desktop.
Save MKorostoff/8409339 to your computer and use it in GitHub Desktop.
SELECT job.job_id AS job_id, job.app_id AS app_id, job.job_type AS job_type, job.asset_id AS asset_id, job.mediafile_id AS mediafile_id, job.started AS started, job.changed AS changed, job.error_description AS error_description, mediafile.filename AS filename
FROM
mediamosa_job job
INNER JOIN mediamosa_asset_mediafile mediafile ON mediafile.mediafile_id = job.mediafile_id
LEFT OUTER JOIN mediamosa_job_display display ON display.job_id = job.job_id
WHERE (job.job_id = (SELECT MAX(j.job_id) FROM mediamosa_job j WHERE j.mediafile_id = job.mediafile_id AND j.job_type = job.job_type)) AND (display.visibility IS NULL ) AND( (job.job_type = 'ANALYSE') OR (job.job_type = 'TRANSCODE') )AND( (job.status = 'FAILED') OR (job.status = 'CANCELLED') )AND (mediafile.is_still = 'FALSE')
ORDER BY job_id desc
LIMIT 25 OFFSET 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment