gistfile1.sql

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