CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `aerion`.`vw_prosp_open_log` AS SELECT `aerion`.`prosp_open_log`.`prosp_open_logid` AS `prosp_open_logid`, `aerion`.`prosp_open_log`.`idprosp_open` AS `idprosp_open`, `aerion`.`prosp_open_log`.`compname` AS `compname`, `aerion`.`prosp_open_log`.`client_name` AS `client_name`, `aerion`.`prosp_open_log`.`location` AS `location`, `aerion`.`prosp_open_log`.`contact_info` AS `contact_info`, `aerion`.`prosp_open_log`.`open_details` AS `open_details`, DATE_FORMAT(`aerion`.`prosp_open_log`.`open_dt`, _UTF8'%m-%d-%y') AS `open_dt`, DATE_FORMAT(`aerion`.`prosp_open_log`.`open_dt`, _UTF8'%Y-%m-%d') AS `open_dt1`, DATE_FORMAT(`aerion`.`prosp_open_log`.`close_dt`, _UTF8'%m-%d-%y') AS `close_dt`, DATE_FORMAT(`aerion`.`prosp_open_log`.`close_dt`, _UTF8'%Y-%m-%d') AS `close_dt1`, DATE_FORMAT(`aerion`.`prosp_open_log`.`last_update`, _UTF8'%m-%d-%y') AS `last_update`, DATE_FORMAT(`aerion`.`prosp_open_log`.`last_update`, _UTF8'%Y-%m-%d') AS `last_update1`, `aerion`.`prosp_open_log`.`updated_by` AS `updated_by`, (CASE WHEN (`aerion`.`prosp_open_log`.`updated_by` <> 0) THEN CONCAT(`aerion`.`emp`.`firstname`, _LATIN1' ', `aerion`.`emp`.`lastname`) ELSE 'Admin' END) AS `updater_name`, `aerion`.`prosp_open_log`.`summary` AS `summary`, `aerion`.`prosp_open_log`.`trans_type` AS `trans_type` FROM (`aerion`.`prosp_open_log` LEFT JOIN `aerion`.`emp` ON ((`aerion`.`prosp_open_log`.`updated_by` = `aerion`.`emp`.`emp_id`))) ORDER BY `aerion`.`prosp_open_log`.`last_update` DESC