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`.`iddev_look` AS `parent_id`,
        `a`.`look_value` AS `look_value`,
        `a`.`look_value_desc` AS `look_value_desc`,
        `a`.`disp_order` AS `disp_order`,
        `a`.`updater` AS `updater`,
        `e`.`emp_fnm` AS `updater_fnm`,
        IF(ISNULL(`a`.`updater`),
            'Admin',
            `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`,
        CONCAT(IF(ISNULL(`a`.`updater`),
                    'Admin',
                    `e`.`fullname`),
                ' ',
                CONVERT( IF(ISNULL(`a`.`last_updated`),
                    'Never',
                    DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p')) USING LATIN1)) AS `last_updated_by`
    FROM
        ((`aerion`.`dev_look_value` `a`
        LEFT JOIN `aerion`.`vw_emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))
        LEFT JOIN `aerion`.`storages` `s` ON ((`e`.`idstorage` = `s`.`idstorage`))) 
    UNION ALL SELECT 
        NULL AS `iddev_look_value`,
        `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`,
        IF(ISNULL(`a`.`updater`),
            'Admin',
            `e`.`fullname`) AS `updater_nm`,
        `e`.`emp_fnm` AS `updater_fnm`,
        `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`,
        CONCAT(IF(ISNULL(`a`.`updater`),
                    'Admin',
                    `e`.`fullname`),
                ' ',
                CONVERT( IF(ISNULL(`a`.`last_updated`),
                    'Never',
                    DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p')) USING LATIN1)) AS `last_updated_by`
    FROM
        (`aerion`.`dev_look` `a`
        LEFT JOIN `aerion`.`vw_emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))