Created
January 13, 2014 22:28
-
-
Save MKorostoff/8409339 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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