CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_dev_look` AS
    SELECT 
        `a`.`iddev_look` AS `iddev_look`,
        `a`.`look_name` AS `look_name`,
        `a`.`look_name_desc` AS `look_name_desc`,
        `a`.`disp_order` AS `disp_order`,
        `a`.`updater` AS `updater`,
        `e`.`emp_fnm` AS `updater_fnm`,
        `e`.`fullname` AS `updater_fmt`,
        `a`.`last_updated` AS `last_updated`,
        IF(ISNULL(`a`.`last_updated`),
            'Never',
            DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p')) AS `last_updated_fmt`
    FROM
        (`aerion`.`dev_look` `a`
        LEFT JOIN `aerion`.`vw_emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))