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
having
    success
group by
    transcode_key,missing, queued, active, failed, success
SQL

Checking query status...
