CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_prosp_lk_val` AS
    SELECT 
        `a`.`idprosp_lk_val` AS `idprosp_lk_val`,
        `a`.`idprosp_lk` AS `idprosp_lk`,
        `b`.`lk_name_desc` AS `lk_name_desc`,
        `b`.`prosp_name` AS `prosp_name`,
        `a`.`prosp_value` AS `prosp_value`,
        `a`.`prosp_value_desc` AS `prosp_value_desc`,
        `a`.`disp_order` AS `disp_order`,
        `a`.`updater` AS `updater`,
        IFNULL(`u`.`fullname`, 'Admin') AS `updater_nm`,
        `u`.`emp_fnm` AS `updater_file_name`,
        `a`.`last_updated` AS `last_updated`,
        IFNULL(DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p'),
                'Never') AS `last_updated_formatted`,
        CONCAT(IFNULL(`u`.`fullname`, 'Admin'),
                ' ',
                CONVERT( IFNULL(DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p'),
                        'Never') USING LATIN1)) AS `last_updated_by`
    FROM
        ((`prosp_lk_val` `a`
        LEFT JOIN `prosp_lk` `b` ON ((`a`.`idprosp_lk` = `b`.`idprosp_lk`)))
        LEFT JOIN `vw_emp` `u` ON ((`a`.`updater` = `u`.`emp_id`)))
    ORDER BY `a`.`last_updated` DESC