CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vW_DeV_LoOk_vAlUe` AS
    SELECT 
        `a`.`iddev_look_value` AS `iddev_look_value`,
        `a`.`look_value` AS `look_value`,
        `a`.`look_value_desc` AS `look_value_desc`,
        `a`.`disp_order` AS `disp_order`,
        `a`.`iddev_look` AS `parent_id`,
        `a`.`updater` AS `updater`,
        `e`.`emp_fnm` AS `updater_fnm`,
        `e`.`fullname` AS `updater_nm`,
        `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_value` `a`
        LEFT JOIN `aerion`.`vw_emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))