select cdate AS 'Creation Date/Time',
        case
                when statusType = '1' then 'Debug'
                when statusType = '2' then 'Info'
                when statusType = '3' then 'Warning'
                when statusType = '4' then 'Error'
        else 'unknown'
        end as Status,
        statusValue AS 'Description'
        from statusmessages
        order by cdate desc LIMIT 100