CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_rpt_dev_status` AS
    SELECT 
        `aerion`.`rpt_dev_status`.`idrpt_dev_status` AS `idrpt_dev_status`,
        `aerion`.`rpt_dev_status`.`iddev_est_reqs` AS `iddev_est_reqs`,
        (SELECT 
                `aerion`.`dev_est_reqs`.`iddev_est` AS `iddev_est`
            FROM
                `aerion`.`dev_est_reqs`
            WHERE
                (`aerion`.`dev_est_reqs`.`iddev_est_reqs` = `aerion`.`rpt_dev_status`.`iddev_est_reqs`)
            GROUP BY `aerion`.`rpt_dev_status`.`iddev_est_reqs`) AS `Tickets`,
        `aerion`.`rpt_dev_status`.`rpt_dev_app` AS `rpt_dev_app`,
        `aerion`.`rpt_dev_status`.`rpt_dev_app_req_smry` AS `rpt_dev_app_req_smry`,
        `aerion`.`rpt_dev_status`.`rpt_dev_req_status_cnt` AS `rpt_dev_req_status_cnt`,
        `aerion`.`rpt_dev_status`.`rpt_dev_stat_list` AS `rpt_dev_stat_list`,
        `aerion`.`rpt_dev_status`.`rpt_dev_stat_hist` AS `rpt_dev_stat_hist`,
        `aerion`.`vw_rpt_dev_status_lag_time`.`lag_time` AS `lag_time`,
        DATE_FORMAT(`aerion`.`rpt_dev_status`.`rpt_dev_req_open_dt_time`,
                _UTF8'%m-%d-%y %h:%i %s') AS `rpt_dev_req_open_dt_time`,
        DATE_FORMAT(`aerion`.`rpt_dev_status`.`rpt_dev_req_open_dt_time`,
                _UTF8'%Y-%m-%d %h:%i %s') AS `rpt_dev_req_open_dt_time1`,
        DATE_FORMAT(`aerion`.`rpt_dev_status`.`rpt_dev_req_close_dt_time`,
                _UTF8'%m-%d-%y %h:%i %s') AS `rpt_dev_req_close_dt_time`,
        DATE_FORMAT(`aerion`.`rpt_dev_status`.`rpt_dev_req_close_dt_time`,
                _UTF8'%Y-%m-%d %h:%i %s') AS `rpt_dev_req_close_dt_time1`,
        `aerion`.`rpt_dev_status`.`rpt_dev_total_time_hrs` AS `rpt_dev_total_time_hrs`,
        `aerion`.`rpt_dev_status`.`rpt_dev_req_open_yr` AS `rpt_dev_req_open_yr`,
        `aerion`.`rpt_dev_status`.`rpt_dev_req_open_mon` AS `rpt_dev_req_open_mon`,
        `aerion`.`rpt_dev_status`.`rpt_dev_req_close_yr` AS `rpt_dev_req_close_yr`,
        `aerion`.`rpt_dev_status`.`rpt_dev_req_close_mon` AS `rpt_dev_req_close_mon`,
        `aerion`.`rpt_dev_status`.`rpt_req_manager` AS `rpt_req_manager`,
        `aerion`.`rpt_dev_status`.`rpt_req_developer` AS `rpt_req_developer`,
        `aerion`.`rpt_dev_status`.`rpt_req_analyst` AS `rpt_req_analyst`,
        (SELECT 
                CONCAT(`aerion`.`emp`.`firstname`,
                            _LATIN1' ',
                            `aerion`.`emp`.`lastname`) AS `concat(firstname,' ',lastname)`
            FROM
                `aerion`.`emp`
            WHERE
                (`aerion`.`emp`.`emp_id` = (SELECT 
                        IF(`aerion`.`dev_est_reqs`.`updater`,
                                0,
                                1) AS `if(``updater``,0,1)`
                    FROM
                        `aerion`.`dev_est_reqs`
                    WHERE
                        (`aerion`.`dev_est_reqs`.`iddev_est_reqs` = `aerion`.`rpt_dev_status`.`iddev_est_reqs`)
                    GROUP BY `aerion`.`rpt_dev_status`.`iddev_est_reqs`))) AS `updater`,
        (SELECT 
                CONCAT(`aerion`.`emp`.`firstname`,
                            _LATIN1' ',
                            `aerion`.`emp`.`lastname`) AS `concat(firstname,' ',lastname)`
            FROM
                `aerion`.`emp`
            WHERE
                (`aerion`.`emp`.`emp_id` = (SELECT 
                        `aerion`.`dev_est_reqs`.`assigned_to` AS `assigned_to`
                    FROM
                        `aerion`.`dev_est_reqs`
                    WHERE
                        (`aerion`.`dev_est_reqs`.`iddev_est_reqs` = `aerion`.`rpt_dev_status`.`iddev_est_reqs`)
                    GROUP BY `aerion`.`rpt_dev_status`.`iddev_est_reqs`))) AS `updated_to`
    FROM
        (`aerion`.`rpt_dev_status`
        LEFT JOIN `aerion`.`vw_rpt_dev_status_lag_time` ON ((`aerion`.`rpt_dev_status`.`iddev_est_reqs` = `aerion`.`vw_rpt_dev_status_lag_time`.`iddev_est_reqs`)))