Successful HLS track transcodes

SQL

select
    count(transcode_key),
    transcode_key,
    (transcode_time_addjob IS     NULL AND transcode_time_startwork IS     NULL AND transcode_time_success IS     NULL AND transcode_time_error IS     NULL) as missing,
    (transcode_time_addjob IS NOT NULL AND transcode_time_startwork IS     NULL AND transcode_time_success IS     NULL AND transcode_time_error IS     NULL) as queued,
    (transcode_time_addjob IS NOT NULL AND transcode_time_startwork IS NOT NULL AND transcode_time_success IS     NULL AND transcode_time_error IS     NULL) as active,
    (transcode_time_addjob IS NOT NULL AND transcode_time_startwork IS NOT NULL AND transcode_time_success IS     NULL AND transcode_time_error IS NOT NULL) as failed,
    (transcode_time_addjob IS NOT NULL AND transcode_time_startwork IS NOT NULL AND transcode_time_success IS NOT NULL AND transcode_time_error IS     NULL) as success    
from transcode
where transcode_key like '%.mp4' OR transcode_key like '%.mov'
group by
    transcode_key, missing, queued, active, failed, success
having success
order by success desc, failed desc, active desc, queued desc, missing desc, transcode_key
SQL

Checking query status...
