CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_dev_trng` AS
    SELECT 
        `a`.`iddev_trng` AS `iddev_trng`,
        `a`.`disp_order` AS `disp_order`,
        `a`.`train_nm` AS `train_nm`,
        `a`.`train_desc` AS `train_desc`,
        `a`.`duration` AS `duration`,
        `a`.`cnt` AS `cnt`,
        `a`.`practical` AS `practical`,
        `a`.`last_updated` AS `last_updated`,
        IFNULL(`b`.`fullname`, 'Admin') AS `updater`,
        DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt`,
        `a`.`del_dt` AS `del_dt_unformatted`,
        IFNULL(`e_del_by`.`fullname`, 'Admin') AS `del_by`,
        `a`.`del_by` AS `del_by_id`,
        `o_del_by`.`file_name` AS `del_by_file_name`,
        `a`.`del_day` AS `del_day`,
        (TO_DAYS((DATE_FORMAT(`a`.`del_dt`, '%y-%m-%d') + INTERVAL `a`.`del_day` DAY)) - TO_DAYS(DATE_FORMAT(NOW(), '%y-%m-%d'))) AS `virtual_del_day`,
        IFNULL(`e_arch_by`.`fullname`, 'Admin') AS `arch_by`,
        `a`.`archv_by` AS `arch_by_id`,
        `o_arch_by`.`file_name` AS `arch_by_file_name`,
        DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `arch_dt`,
        `a`.`archv_dt` AS `arch_dt_unformatted`
    FROM
        (((((`aerion`.`dev_trng` `a`
        LEFT JOIN `aerion`.`vw_emp` `b` ON ((`a`.`updater` = `b`.`emp_id`)))
        LEFT JOIN `aerion`.`vw_emp` `e_del_by` ON ((`a`.`del_dt` = `e_del_by`.`emp_id`)))
        LEFT JOIN `aerion`.`vw_emp` `e_arch_by` ON ((`a`.`archv_by` = `e_arch_by`.`emp_id`)))
        LEFT JOIN `aerion`.`storages` `o_del_by` ON ((`e_del_by`.`emp_id` = `o_del_by`.`emp_id`)))
        LEFT JOIN `aerion`.`storages` `o_arch_by` ON ((`e_arch_by`.`emp_id` = `o_arch_by`.`emp_id`)))
    ORDER BY `a`.`disp_order`