CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_all_usr_login` AS
    SELECT 
        `a`.`login_id` AS `login_id`,
        DATE_FORMAT(`a`.`lastlogin`,
                _UTF8'%m-%d-%y %H:%i:%s') AS `lastlogin`,
        `a`.`lastlogin` AS `lastlogin_unformatted`,
        DATE_FORMAT(`a`.`lastlogout`,
                _UTF8'%m-%d-%y %H:%i:%s') AS `lastlogout`,
        `a`.`lastlogout` AS `lastlogout_unformatted`,
        `a`.`login_IP_add` AS `login_IP_add`,
        `a`.`domain_name` AS `domain_name`,
        `a`.`isp` AS `isp`,
        `a`.`country` AS `country`,
        `a`.`state` AS `state`,
        `a`.`city` AS `city`,
        `a`.`postal_code` AS `postal_code`,
        `a`.`updater` AS `updater`,
        `a`.`logouttype` AS `logouttype`,
        `b`.`emp_id` AS `emp_id`,
        IF(ISNULL(`b`.`emp_id`),
            'Admin',
            CONCAT(`b`.`firstname`, '  ', `b`.`lastname`)) AS `username`
    FROM
        (`aerion`.`all_users_login` `a`
        LEFT JOIN `aerion`.`emp` `b` ON ((`a`.`emp_id` = `b`.`emp_id`)))
    ORDER BY `a`.`lastlogin` DESC