CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_dev_est_reqs_case` AS
    SELECT 
        `a`.`iddev_est_reqs_case` AS `iddev_est_reqs_case`,
        `a`.`iddev_est_reqs` AS `iddev_est_reqs`,
        `b`.`iddev_est` AS `iddev_est`,
        DATE_FORMAT(`b`.`open_dt_time`, '%m.%d.%y') AS `open_dt_time`,
        DATE_FORMAT(`b`.`close_dt_time`, '%m.%d.%y') AS `close_dt_time`,
        `b`.`req_status` AS `req_status`,
        `l`.`look_value` AS `req_status_name`,
        `b`.`req_desc` AS `req_desc`,
        `a`.`created_by` AS `created_by`,
        IF(ISNULL(`a`.`created_by`),
            'Admin',
            CONCAT(`c`.`firstname`, ' ', `c`.`lastname`)) AS `created_by_name`,
        `a`.`create_dt` AS `create_dt`,
        CONCAT(CONVERT( DATE_FORMAT(`a`.`create_dt`, '%m.%d.%y') USING LATIN1),
                ' ',
                IF(ISNULL(`a`.`created_by`),
                    'Admin',
                    CONCAT(`c`.`firstname`, ' ', `c`.`lastname`))) AS `mod_created_by`,
        DATE_FORMAT(`a`.`create_dt`, '%m-%d-%y') AS `mod_create_dt`,
        `a`.`create_end_dt` AS `create_end_dt`,
        DATE_FORMAT(`a`.`create_end_dt`, '%m-%d-%y') AS `mod_create_end_dt`,
        `a`.`reqs_cases` AS `reqs_cases`,
        `a`.`case_data` AS `case_data`,
        `a`.`case_result_desc` AS `case_result_desc`,
        `a`.`case_status` AS `case_status`,
        `lp`.`look_value` AS `case_status_name`,
        `a`.`executed_by` AS `executed_by`,
        IF(ISNULL(`a`.`executed_by`),
            'Admin',
            CONCAT(`d`.`firstname`, ' ', `d`.`lastname`)) AS `executed_by_name`,
        `a`.`execute_dt` AS `execute_dt`,
        DATE_FORMAT(`a`.`execute_dt`, '%m-%d-%y') AS `mod_execute_dt`,
        CONCAT(CONVERT( DATE_FORMAT(`a`.`execute_dt`, '%m.%d.%y') USING LATIN1),
                ' ',
                IF(ISNULL(`a`.`executed_by`),
                    'Admin',
                    CONCAT(`d`.`firstname`, '', `d`.`lastname`))) AS `mod_executed_by`,
        `a`.`updated_by` AS `updated_by`,
        IF(ISNULL(`a`.`updated_by`),
            'Admin',
            CONCAT(`e`.`firstname`, ' ', `e`.`lastname`)) AS `updated_by_name`,
        `a`.`last_updated` AS `last_updated`,
        CONCAT(CONVERT( DATE_FORMAT(`a`.`last_updated`, '%m.%d.%y %H.%i.%s') USING LATIN1),
                ' ',
                IF(ISNULL(`a`.`updated_by`),
                    'Admin',
                    CONCAT(`e`.`firstname`, ' ', `e`.`lastname`))) AS `mod_last_updated`
    FROM
        ((((((`dev_est_reqs_case` `a`
        LEFT JOIN `dev_est_reqs` `b` ON ((`a`.`iddev_est_reqs` = `b`.`iddev_est_reqs`)))
        LEFT JOIN `emp` `c` ON ((`a`.`created_by` = `c`.`emp_id`)))
        LEFT JOIN `emp` `d` ON ((`a`.`executed_by` = `d`.`emp_id`)))
        LEFT JOIN `emp` `e` ON ((`a`.`updated_by` = `e`.`emp_id`)))
        LEFT JOIN `dev_look_value` `l` ON ((`b`.`req_status` = `l`.`iddev_look_value`)))
        LEFT JOIN `dev_look_value` `lp` ON ((`a`.`case_status` = `lp`.`iddev_look_value`)))