CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_emp_address` AS
    SELECT 
        `a`.`emp_add_id` AS `emp_add_id`,
        `a`.`emp_id` AS `emp_id`,
        `a`.`house_apt_no` AS `house_apt_no`,
        `a`.`house_apt_type` AS `house_apt_type`,
        `l`.`emp_value` AS `house_apt_type_nm`,
        `a`.`look_street_no_id` AS `look_street_no_id`,
        `b`.`look_street_no` AS `look_street_no`,
        `b`.`street_name` AS `street_name`,
        `b`.`street_type` AS `street_type`,
        `b`.`street_type_name` AS `street_type_name`,
        `b`.`zip_code` AS `zip_code`,
        `b`.`city_name` AS `city_name`,
        `b`.`state_name` AS `state_name`,
        `b`.`con_name` AS `con_name`,
        `a`.`add_type` AS `add_type`,
        `v`.`emp_value` AS `add_type_nm`,
        `a`.`from_dt` AS `from_dt`,
        `a`.`to_dt` AS `to_dt`,
        (CASE
            WHEN (`a`.`from_dt` <> _UTF8'0000-00-00') THEN DATE_FORMAT(`a`.`from_dt`, _UTF8'%m-%d-%y')
            ELSE _UTF8''
        END) AS `from_dt_formatted`,
        (CASE
            WHEN (`a`.`to_dt` <> _UTF8'0000-00-00') THEN DATE_FORMAT(`a`.`to_dt`, _UTF8'%m-%d-%y')
            ELSE _UTF8''
        END) AS `to_dt_formatted`,
        `a`.`updater` AS `updater`,
        IF(ISNULL(`a`.`updater`),
            'Admin',
            CONCAT(`e`.`firstname`, ' ', `e`.`lastname`)) AS `updater_nm`,
        `s`.`file_name` AS `updater_file_name`,
        `a`.`last_updated` AS `last_updated`,
        CONCAT(CONVERT( DATE_FORMAT(`a`.`last_updated`,
                        '%m-%d-%y %H:%i:%s %p') USING LATIN1),
                ' ') AS `format_last_updated`
    FROM
        (((((`emp_address` `a`
        LEFT JOIN `vw_look_addresses` `b` ON ((`a`.`look_street_no_id` = `b`.`look_street_no_id`)))
        LEFT JOIN `emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))
        LEFT JOIN `storages` `s` ON ((`e`.`idstorage` = `s`.`idstorage`)))
        LEFT JOIN `emp_lk_val` `l` ON ((`a`.`house_apt_type` = `l`.`idemp_lk_value`)))
        LEFT JOIN `emp_lk_val` `v` ON ((`a`.`add_type` = `v`.`idemp_lk_value`)))