_________________________________________________________________________________________________________ 03_03_2025 vw_emp_address CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_emp_address` AS SELECT `a`.`emp_add_id` AS `emp_add_id`, `a`.`emp_id` AS `emp_id`, `d`.`file_name` AS `emp_fnm`, CONCAT(`c`.`firstname`, ' ', `c`.`lastname`) AS `emp_nm`, `a`.`house_apt_no` AS `house_apt_no`, `a`.`house_apt_type` AS `house_apt_type`, `l`.`lk_val` AS `house_apt_type_nm`, `a`.`look_street_no_id` AS `look_street_no_id`, `b`.`look_street_no` AS `look_street_no`, `b`.`street_name` AS `street_name`, `b`.`street_type` AS `street_type`, `b`.`street_type_name` AS `street_type_name`, `b`.`zip_code` AS `zip_code`, `b`.`city_name` AS `city_name`, `b`.`state_name` AS `state_name`, `b`.`con_name` AS `con_name`, `b`.`addresses` AS `addresses`, `a`.`add_type` AS `add_type`, `v`.`lk_val` AS `add_type_nm`, `a`.`from_dt` AS `from_dt`, DATE_FORMAT(`a`.`from_dt`, '%Y') AS `from_dt_yr`, DATE_FORMAT(`a`.`from_dt`, '%M') AS `from_dt_mon`, (CASE WHEN (`a`.`from_dt` <> _UTF8'0000-00-00') THEN DATE_FORMAT(`a`.`from_dt`, _UTF8'%m-%d-%y') ELSE '' END) AS `from_dt_fmt`, `a`.`to_dt` AS `to_dt`, DATE_FORMAT(`a`.`to_dt`, '%Y') AS `to_dt_yr`, DATE_FORMAT(`a`.`to_dt`, '%M') AS `to_dt_mon`, (CASE WHEN (`a`.`to_dt` <> _UTF8'0000-00-00') THEN DATE_FORMAT(`a`.`to_dt`, _UTF8'%m-%d-%y') ELSE '' END) AS `to_dt_fmt`, `a`.`no_of_days` AS `no_of_days`, TIMESTAMPDIFF(DAY, `a`.`from_dt`, IFNULL(`a`.`to_dt`, NOW())) AS `no_of_days_vir`, `a`.`updater` AS `updater`, `s`.`file_name` AS `updater_fnm`, IF(ISNULL(`a`.`updater`), 'Admin', CONCAT(`e`.`firstname`, ' ', `e`.`lastname`)) AS `updater_nm`, `a`.`last_updated` AS `last_updated`, CONCAT(CONVERT( DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %H:%i:%s %p') USING LATIN1), ' ') AS `last_updated_fmt`, `a`.`del_dt` AS `del_dt`, DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt_fmt`, `a`.`del_by` AS `del_by`, `g`.`file_name` AS `del_by_fnm`, IF(ISNULL(`a`.`del_by`), 'Admin', CONCAT(`f`.`firstname`, ' ', `f`.`lastname`)) AS `del_by_nm`, `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 `del_day_vir`, `a`.`archv_dt` AS `archv_dt`, DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `archv_dt_fmt`, `a`.`archv_by` AS `archv_by`, `h`.`file_name` AS `archv_by_fnm`, IF(ISNULL(`a`.`archv_by`), 'Admin', CONCAT(`i`.`firstname`, ' ', `i`.`lastname`)) AS `archv_by_nm` FROM (((((((((((`emp_address` `a` LEFT JOIN `vw_look_addresses` `b` ON ((`a`.`look_street_no_id` = `b`.`look_street_no_id`))) LEFT JOIN `emp` `e` ON ((`a`.`updater` = `e`.`emp_id`))) LEFT JOIN `storages` `s` ON ((`e`.`idstorage` = `s`.`idstorage`))) LEFT JOIN `feature_lk_val` `l` ON ((`a`.`house_apt_type` = `l`.`idfeature_lk_val`))) LEFT JOIN `emp_lk_val` `v` ON ((`a`.`add_type` = `v`.`idemp_lk_value`))) LEFT JOIN `emp` `c` ON ((`c`.`emp_id` = `a`.`emp_id`))) LEFT JOIN `storages` `d` ON ((`d`.`idstorage` = `c`.`idstorage`))) LEFT JOIN `emp` `f` ON ((`a`.`del_by` = `f`.`emp_id`))) LEFT JOIN `storages` `g` ON ((`g`.`idstorage` = `f`.`idstorage`))) LEFT JOIN `emp` `i` ON ((`a`.`archv_by` = `i`.`emp_id`))) LEFT JOIN `storages` `h` ON ((`h`.`idstorage` = `e`.`idstorage`))) _____________________________________________________________________________________________________________ 10/11/2024 CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_storages` AS SELECT `a`.`idstorage` AS `idstorage`, `a`.`file_name` AS `file_name`, `a`.`sto_cloud` AS `sto_cloud`, IFNULL(`b`.`lk_val`, 'local') AS `sto_cloud_nm`, `a`.`file_size` AS `file_size`, (CASE WHEN (`a`.`file_size` < 1024) THEN CONCAT(`a`.`file_size`, ' B') WHEN ((`a`.`file_size` > 1024) AND (`a`.`file_size` < 1048576)) THEN CONCAT(ROUND((`a`.`file_size` / 1024), 2), ' KB') WHEN ((`a`.`file_size` > 1048576) AND (`a`.`file_size` < 1073741824)) THEN CONCAT(ROUND(((`a`.`file_size` / 1024) / 1024), 2), ' MB') WHEN (`a`.`file_size` > 1073741824) THEN CONCAT(ROUND((((`a`.`file_size` / 1024) / 1024) / 1024), 2), ' GB') END) AS `file_size_fmt`, `a`.`owner_id` AS `owner_id`, `d`.`file_name` AS `owner_fnm`, IF(ISNULL(`a`.`owner_id`), 'No Owner', CONCAT(`c`.`firstname`, ' ', `c`.`lastname`)) AS `owner_nm`, `a`.`create_dt` AS `create_dt`, DATE_FORMAT(`a`.`create_dt`, '%m-%d-%y %h:%i %p') AS `create_dt_fmt`, DATE_FORMAT(`a`.`create_dt`, '%Y') AS `create_dt_yr`, DATE_FORMAT(`a`.`create_dt`, '%M') AS `create_dt_mon`, `a`.`expire_dt` AS `expire_dt`, DATE_FORMAT(`a`.`expire_dt`, '%m-%d-%y') AS `expire_dt_fmt`, DATE_FORMAT(`a`.`expire_dt`, '%m %Y') AS `expire_dt_mon_yr`, `a`.`ext_type` AS `ext_type`, `a`.`public` AS `public`, `a`.`self_view` AS `self_view`, `a`.`smry` AS `smry`, `a`.`ref_emp_id` AS `ref_emp_id`, `g`.`file_name` AS `ref_emp_id_fnm`, CONCAT(`f`.`firstname`, ' ', `f`.`lastname`) AS `ref_emp_id_nm`, `a`.`updater` AS `updater`, `i`.`file_name` AS `updater_fnm`, IF(ISNULL(`a`.`updater`), 'admin', CONCAT(`h`.`firstname`, ' ', `h`.`lastname`)) AS `updater_nm`, `a`.`updated` AS `updated`, DATE_FORMAT(`a`.`updated`, '%m-%d-%y %h:%i %p') AS `updated_dt_fmt`, `a`.`usage` AS `usage`, `a`.`sto_tags` AS `sto_tags`, IFNULL(`a`.`sto_tags`, 'No Tags') AS `sto_tags_nm`, `a`.`del_dt` AS `del_dt`, DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt_fmt`, IFNULL(CONVERT( DATE_FORMAT(`a`.`del_dt`, '%Y') USING UTF8MB4), 'Not deleted') AS `del_dt_yr`, IFNULL(CONVERT( DATE_FORMAT(`a`.`del_dt`, '%M') USING UTF8MB4), 'Not Deleted') AS `del_dt_mon`, `a`.`del_by` AS `del_by`, `k`.`file_name` AS `del_by_fnm`, IF(ISNULL(`a`.`del_by`), 'admin', CONCAT(`j`.`firstname`, ' ', `j`.`lastname`)) AS `del_by_nm`, `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 `del_day_vir`, `a`.`archv_dt` AS `archv_dt`, DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `archv_dt_fmt`, IFNULL(CONVERT( DATE_FORMAT(`a`.`archv_dt`, '%Y') USING UTF8MB4), 'Not Archived') AS `archv_dt_yr`, IFNULL(CONVERT( DATE_FORMAT(`a`.`archv_dt`, '%M') USING UTF8MB4), 'Not Archived') AS `archv_dt_mon`, `a`.`archv_by` AS `archv_by`, `m`.`file_name` AS `archv_by_fnm`, IF(ISNULL(`a`.`archv_by`), 'admin', CONCAT(`l`.`firstname`, ' ', `l`.`lastname`)) AS `archv_by_nm`, `a`.`chk_del` AS `chk_del` FROM (((((((((((`storages` `a` LEFT JOIN `storages_lk_val` `b` ON ((`a`.`sto_cloud` = `b`.`idstorages_lk_val`))) LEFT JOIN `emp` `c` ON ((`a`.`owner_id` = `c`.`emp_id`))) LEFT JOIN `storages` `d` ON ((`c`.`idstorage` = `d`.`idstorage`))) LEFT JOIN `emp` `f` ON ((`a`.`ref_emp_id` = `f`.`emp_id`))) LEFT JOIN `storages` `g` ON ((`f`.`idstorage` = `g`.`idstorage`))) LEFT JOIN `emp` `h` ON ((`a`.`updater` = `h`.`emp_id`))) LEFT JOIN `storages` `i` ON ((`h`.`idstorage` = `i`.`idstorage`))) LEFT JOIN `emp` `j` ON ((`a`.`del_by` = `j`.`emp_id`))) LEFT JOIN `storages` `k` ON ((`j`.`idstorage` = `k`.`idstorage`))) LEFT JOIN `emp` `l` ON ((`a`.`archv_by` = `l`.`emp_id`))) LEFT JOIN `storages` `m` ON ((`l`.`idstorage` = `m`.`idstorage`))) ORDER BY `a`.`updated` DESC ___________________________________________________________________ (08/27/2024) CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_addresses` AS SELECT `a`.`country_id` AS `country_id`, `a`.`con_name` AS `con_name`, `a`.`con_full_name` AS `con_full_name`, `a`.`lk_design` AS `lk_design`, `a`.`con_code` AS `con_code`, `a`.`con_digit` AS `con_digit`, `b`.`state_id` AS `state_id`, `b`.`state_name` AS `state_name`, `b`.`state_full_name` AS `state_full_name`, `c`.`city_id` AS `city_id`, `c`.`city_name` AS `city_name`, `d`.`postal_id` AS `postal_id`, `d`.`zip_code` AS `zip_code`, `e`.`look_street_id` AS `look_street_id`, `e`.`street_name` AS `street_name`, `e`.`street_type` AS `street_type`, `j`.`lk_val` AS `street_type_nm`, `f`.`look_street_no_id` AS `look_street_no_id`, `f`.`look_street_no` AS `look_street_no` FROM ((((`look_postal` `d` LEFT JOIN (`look_city` `c` LEFT JOIN (`look_state` `b` LEFT JOIN `look_country` `a` ON ((`a`.`country_id` = `b`.`country_id`))) ON ((`b`.`state_id` = `c`.`state_id`))) ON ((`c`.`city_id` = `d`.`city_id`))) LEFT JOIN `look_street` `e` ON ((`d`.`postal_id` = `e`.`postal_id`))) LEFT JOIN `look_street_no` `f` ON ((`e`.`look_street_id` = `f`.`look_street_id`))) LEFT JOIN `feature_lk_val` `j` ON ((`j`.`idfeature_lk_val` = `e`.`street_type`))) ____________________________________________________________________________________________ (08/29/2024) 12:34 CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_emp` AS SELECT `a`.`emp_id` AS `emp_id`, `a`.`idstorage` AS `idstorage`, `e`.`file_name` AS `emp_fnm`, `a`.`firstname` AS `firstname`, `a`.`lastname` AS `lastname`, CONCAT(`a`.`firstname`, ' ', `a`.`lastname`) AS `fullname`, `a`.`nickname` AS `nickname`, `b`.`user_name` AS `user_name`, IFNULL(`b`.`user_name`, 'No Login') AS `user_name_nm`, IF(ISNULL(`b`.`user_name`), 'No', 'Yes') AS `user_name_cur_stat`, `b`.`status` AS `status`, `b`.`expire_tm` AS `expire_tm`, `b`.`last_clicked` AS `last_clicked`, `b`.`url_fwd` AS `url_fwd`, TIMESTAMPDIFF(MINUTE, `f`.`lastlogin`, `b`.`last_clicked`) AS `last_clicked_tm`, `a`.`all_contacts` AS `all_contacts`, IF(ISNULL(`a`.`all_contacts`), 'No', 'Yes') AS `all_contacts_nm`, `a`.`unique_id_type` AS `unique_id`, IFNULL(`c`.`lk_val`, 'NA') AS `unique_id_nm`, `a`.`ssn` AS `ssn`, IFNULL(`a`.`ssn`, 'No SSN') AS `ssn_nm`, `a`.`dob` AS `dob`, IFNULL(DATE_FORMAT(`a`.`dob`, '%m-%d-%y'), 'No DOB') AS `dob_fmt`, IFNULL(TIMESTAMPDIFF(YEAR, `a`.`dob`, CURDATE()), 'No DOB') AS `age`, `a`.`gender` AS `gender_id`, IFNULL(`d`.`lk_val`, 'NA') AS `gender_nm`, `a`.`all_features` AS `all_features`, `a`.`cnt_feature` AS `cnt_feature`, `a`.`all_education` AS `all_education`, IF(ISNULL(`a`.`all_education`), 'No', 'Yes') AS `all_education_nm`, `a`.`education_cnt` AS `education_cnt`, `a`.`all_emp_org` AS `all_emp_org`, IF(ISNULL(`a`.`all_emp_org`), 'No', 'Yes') AS `all_emp_org_nm`, `a`.`all_addresses` AS `all_addresses`, `a`.`sto_limit` AS `sto_limit`, (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_limit_fmt`, `a`.`sto_usage` AS `sto_usage`, (CASE WHEN (`a`.`sto_usage` < 1024) THEN CONCAT(`a`.`sto_usage`, ' B') WHEN ((`a`.`sto_usage` >= 1024) AND (`a`.`sto_usage` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_usage` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_usage` >= 1048576) AND (`a`.`sto_usage` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_usage` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_usage` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_usage` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_usage_fmt`, `a`.`sto_remain` AS `sto_remain`, (CASE WHEN (`a`.`sto_remain` < 1024) THEN CONCAT(`a`.`sto_remain`, ' B') WHEN ((`a`.`sto_remain` >= 1024) AND (`a`.`sto_remain` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_remain` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_remain` >= 1048576) AND (`a`.`sto_remain` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_remain` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_remain` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_remain` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_remain_fmt`, CONCAT((CASE WHEN (`a`.`sto_usage` < 1024) THEN CONCAT(`a`.`sto_usage`, ' B') WHEN ((`a`.`sto_usage` >= 1024) AND (`a`.`sto_usage` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_usage` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_usage` >= 1048576) AND (`a`.`sto_usage` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_usage` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_usage` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_usage` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END), ' of ', (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END)) AS `sto_in_use`, CONCAT((CASE WHEN (`a`.`sto_remain` < 1024) THEN CONCAT(`a`.`sto_remain`, ' B') WHEN ((`a`.`sto_remain` >= 1024) AND (`a`.`sto_remain` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_remain` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_remain` >= 1048576) AND (`a`.`sto_remain` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_remain` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_remain` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_remain` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END), ' of ', (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END)) AS `sto_remaining`, CONCAT(ROUND(((`a`.`sto_usage` / `a`.`sto_limit`) * 100), 2), '%') AS `sto_in_use_pcnt`, CONCAT(ROUND(((`a`.`sto_remain` / `a`.`sto_limit`) * 100), 2), '%') AS `sto_remaining_pcnt`, `a`.`taxid` AS `taxid`, IFNULL(`a`.`taxid`, 'No TAXID') AS `taxid_nm`, IFNULL(`a`.`hrs_forecast`, '0.00') AS `hrs_forecast`, IFNULL(`a`.`hrs_actual`, '0.00') AS `hrs_actual`, CONCAT((CASE WHEN ISNULL(`a`.`hrs_actual`) THEN '0.00' WHEN (`a`.`hrs_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`hrs_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`hrs_actual` < 1000) THEN `a`.`hrs_actual` END), ' of ', (CASE WHEN ISNULL(`a`.`hrs_forecast`) THEN '0.00' WHEN (`a`.`hrs_forecast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`hrs_forecast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`hrs_forecast` < 1000) THEN `a`.`hrs_forecast` END)) AS `hrs_actual_forecast`, IFNULL(`a`.`fore_act_pcnt`, '0.00') AS `fore_act_pcnt`, IFNULL(`a`.`amt_forcast`, '0.00') AS `amt_forcast`, IFNULL(`a`.`amt_actual`, '0.00') AS `amt_actual`, CONCAT((CASE WHEN ISNULL(`a`.`amt_actual`) THEN '0.00' WHEN (`a`.`amt_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`amt_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`amt_actual` < 1000) THEN `a`.`amt_actual` END), ' of ', (CASE WHEN ISNULL(`a`.`amt_forcast`) THEN '0.00' WHEN (`a`.`amt_forcast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`amt_forcast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`amt_forcast` < 1000) THEN `a`.`amt_forcast` END)) AS `amt_actual_forcast`, IFNULL(`a`.`amt_pcnt`, '0.00') AS `amt_pcnt`, IFNULL(`a`.`vac_earn`, '0.00') AS `vac_earned`, IFNULL(`a`.`vac_use`, '0.00') AS `vac_used`, CONCAT((CASE WHEN ISNULL(`a`.`vac_use`) THEN '0.00' WHEN (`a`.`vac_use` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`vac_use` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`vac_use` < 1000) THEN `a`.`vac_use` END), ' of ', (CASE WHEN ISNULL(`a`.`vac_earn`) THEN '0.00' WHEN (`a`.`vac_earn` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`vac_earn` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`vac_earn` < 1000) THEN `a`.`vac_earn` END)) AS `vac_used_earned`, IFNULL(`a`.`vac_pcnt`, '0.00') AS `vac_pcnt`, IFNULL(`a`.`vac_bal`, '0.00') AS `vac_bal`, `a`.`login_id` AS `login_id`, `g`.`domain_nm` AS `domain_name`, `g`.`ip_contry` AS `contry`, `f`.`lastlogin` AS `lastlogin`, DATE_FORMAT(`f`.`lastlogin`, '%m-%d-%y %h:%i %p') AS `lastlogin_fmt`, `f`.`lastlogout` AS `lastlogout`, DATE_FORMAT(`f`.`lastlogout`, '%m-%d-%y %h:%i %p') AS `lastlogout_fmt`, IFNULL(CONCAT(ROUND(((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`f`.`lastlogout`)) / 3600), 0), ':', ROUND((ROUND(((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`f`.`lastlogout`)) % 3600), 0) / 60), 0)), 'Live') AS `loggged_out`, `f`.`logged_in` AS `logged_in`, TIMESTAMPDIFF(MINUTE, `f`.`lastlogin`, `f`.`lastlogout`) AS `logged_in_tm`, `h`.`idlook_menu_pvt_lvl1` AS `idlook_menu_pvt_lvl1`, `i`.`lk_values` AS `main_menu`, `h`.`idlook_menu_pvt_lvl2` AS `idlook_menu_pvt_lvl2`, `j`.`lk_values` AS `sub_menu`, `a`.`last_updated` AS `last_updated`, DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p') AS `last_updated_fmt`, `a`.`updater` AS `updater`, `l`.`file_name` AS `updater_fnm`, IFNULL(CONCAT(`k`.`firstname`, ' ', `k`.`lastname`), 'Admin') AS `updater_nm`, `a`.`del_dt` AS `del_dt`, DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt_fmt`, `a`.`del_by` AS `del_by`, `n`.`file_name` AS `del_by_fnm`, IFNULL(CONCAT(`m`.`firstname`, ' ', `m`.`lastname`), 'Admin') AS `del_by_nm`, `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 `del_day_vir`, `a`.`archv_dt` AS `archv_dt`, DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `archv_dt_fmt`, `a`.`archv_by` AS `archv_by`, `p`.`file_name` AS `archv_by_fnm`, IFNULL(CONCAT(`o`.`firstname`, ' ', `o`.`lastname`), 'Admin') AS `archv_by_nm` FROM (((((((((((((((`emp` `a` LEFT JOIN `all_users` `b` ON ((`a`.`emp_id` = `b`.`emp_id`))) LEFT JOIN `emp_lk_val` `c` ON ((`a`.`unique_id_type` = `c`.`idemp_lk_value`))) LEFT JOIN `emp_lk_val` `d` ON ((`a`.`gender` = `d`.`idemp_lk_value`))) LEFT JOIN `storages` `e` ON ((`a`.`idstorage` = `e`.`idstorage`))) LEFT JOIN `all_usr_login` `f` ON ((`a`.`login_id` = `f`.`idall_usr_login`))) LEFT JOIN `look_ip_addr` `g` ON ((`f`.`idlook_ip_addr` = `g`.`idlook_ip_addr`))) LEFT JOIN `all_usr_login` `h` ON ((`a`.`login_id` = `h`.`idall_usr_login`))) LEFT JOIN `look_menu_pvt` `i` ON ((`h`.`idlook_menu_pvt_lvl1` = `i`.`idlook_menu_pvt`))) LEFT JOIN `look_menu_pvt` `j` ON ((`h`.`idlook_menu_pvt_lvl2` = `j`.`idlook_menu_pvt`))) LEFT JOIN `emp` `k` ON ((`a`.`updater` = `k`.`emp_id`))) LEFT JOIN `storages` `l` ON ((`k`.`idstorage` = `l`.`idstorage`))) LEFT JOIN `emp` `m` ON ((`a`.`del_by` = `m`.`emp_id`))) LEFT JOIN `storages` `n` ON ((`m`.`idstorage` = `n`.`idstorage`))) LEFT JOIN `emp` `o` ON ((`a`.`archv_by` = `o`.`emp_id`))) LEFT JOIN `storages` `p` ON ((`o`.`idstorage` = `p`.`idstorage`))) ORDER BY `a`.`last_updated` ___________________________________________________________________________________________________ (08/29/2024) CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_emp` AS SELECT `a`.`emp_id` AS `emp_id`, `a`.`idstorage` AS `idstorage`, `e`.`file_name` AS `emp_fnm`, `a`.`firstname` AS `firstname`, `a`.`middlename` AS `middlename`, `a`.`lastname` AS `lastname`, CONCAT(IFNULL(`a`.`firstname`, ''), ' ', IFNULL(`a`.`middlename`, ''), ' ', IFNULL(`a`.`lastname`, '')) AS `fullname`, `a`.`nickname` AS `nickname`, `b`.`user_name` AS `user_name`, IFNULL(`b`.`user_name`, 'No Login') AS `user_name_nm`, IF(ISNULL(`b`.`user_name`), 'No', 'Yes') AS `user_name_cur_stat`, `b`.`status` AS `status`, `b`.`expire_tm` AS `expire_tm`, `b`.`last_clicked` AS `last_clicked`, `b`.`url_fwd` AS `url_fwd`, TIMESTAMPDIFF(MINUTE, `f`.`lastlogin`, `b`.`last_clicked`) AS `last_clicked_tm`, `a`.`all_contacts` AS `all_contacts`, IF(ISNULL(`a`.`all_contacts`), 'No', 'Yes') AS `all_contacts_nm`, `a`.`unique_id_type` AS `unique_id`, IFNULL(`c`.`lk_val`, 'NA') AS `unique_id_nm`, `a`.`ssn` AS `ssn`, IFNULL(`a`.`ssn`, 'No SSN') AS `ssn_nm`, `a`.`dob` AS `dob`, IFNULL(DATE_FORMAT(`a`.`dob`, '%m-%d-%y'), 'No DOB') AS `dob_fmt`, IFNULL(TIMESTAMPDIFF(YEAR, `a`.`dob`, CURDATE()), 'No DOB') AS `age`, `a`.`gender` AS `gender_id`, IFNULL(`d`.`lk_val`, 'NA') AS `gender_nm`, `a`.`all_features` AS `all_features`, `a`.`cnt_feature` AS `cnt_feature`, `a`.`all_education` AS `all_education`, IF(ISNULL(`a`.`all_education`), 'No', 'Yes') AS `all_education_nm`, `a`.`education_cnt` AS `education_cnt`, `a`.`all_emp_org` AS `all_emp_org`, IF(ISNULL(`a`.`all_emp_org`), 'No', 'Yes') AS `all_emp_org_nm`, `a`.`all_addresses` AS `all_addresses`, `a`.`sto_limit` AS `sto_limit`, (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_limit_fmt`, `a`.`sto_usage` AS `sto_usage`, (CASE WHEN (`a`.`sto_usage` < 1024) THEN CONCAT(`a`.`sto_usage`, ' B') WHEN ((`a`.`sto_usage` >= 1024) AND (`a`.`sto_usage` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_usage` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_usage` >= 1048576) AND (`a`.`sto_usage` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_usage` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_usage` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_usage` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_usage_fmt`, `a`.`sto_remain` AS `sto_remain`, (CASE WHEN (`a`.`sto_remain` < 1024) THEN CONCAT(`a`.`sto_remain`, ' B') WHEN ((`a`.`sto_remain` >= 1024) AND (`a`.`sto_remain` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_remain` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_remain` >= 1048576) AND (`a`.`sto_remain` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_remain` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_remain` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_remain` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END) AS `sto_remain_fmt`, CONCAT((CASE WHEN (`a`.`sto_usage` < 1024) THEN CONCAT(`a`.`sto_usage`, ' B') WHEN ((`a`.`sto_usage` >= 1024) AND (`a`.`sto_usage` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_usage` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_usage` >= 1048576) AND (`a`.`sto_usage` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_usage` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_usage` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_usage` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END), ' of ', (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END)) AS `sto_in_use`, CONCAT((CASE WHEN (`a`.`sto_remain` < 1024) THEN CONCAT(`a`.`sto_remain`, ' B') WHEN ((`a`.`sto_remain` >= 1024) AND (`a`.`sto_remain` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_remain` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_remain` >= 1048576) AND (`a`.`sto_remain` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_remain` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_remain` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_remain` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END), ' of ', (CASE WHEN (`a`.`sto_limit` < 1024) THEN CONCAT(`a`.`sto_limit`, ' B') WHEN ((`a`.`sto_limit` >= 1024) AND (`a`.`sto_limit` < 1048576)) THEN CONVERT( CONCAT(ROUND((`a`.`sto_limit` / 1024), 2), ' KB') USING LATIN1) WHEN ((`a`.`sto_limit` >= 1048576) AND (`a`.`sto_limit` < 1073741824)) THEN CONVERT( CONCAT(ROUND(((`a`.`sto_limit` / 1024) / 1024), 2), ' MB') USING LATIN1) WHEN (`a`.`sto_limit` >= 1073741824) THEN CONVERT( CONCAT(ROUND((((`a`.`sto_limit` / 1024) / 1024) / 1024), 2), ' GB') USING LATIN1) END)) AS `sto_remaining`, CONCAT(ROUND(((`a`.`sto_usage` / `a`.`sto_limit`) * 100), 2), '%') AS `sto_in_use_pcnt`, CONCAT(ROUND(((`a`.`sto_remain` / `a`.`sto_limit`) * 100), 2), '%') AS `sto_remaining_pcnt`, `a`.`taxid` AS `taxid`, IFNULL(`a`.`taxid`, 'No TAXID') AS `taxid_nm`, CONCAT((CASE WHEN ISNULL(`q`.`org_actual`) THEN '0.00' WHEN (`q`.`org_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_actual` < 1000) THEN `q`.`org_actual` END), ' of ', (CASE WHEN ISNULL(`q`.`org_forecast`) THEN '0.00' WHEN (`q`.`org_forecast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_forecast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_forecast` < 1000) THEN `q`.`org_forecast` END)) AS `org_actual_forecast`, IFNULL(`q`.`org_pcnt`, '0.00') AS `org_pcnt`, CONCAT((CASE WHEN ISNULL(`q`.`org_amt_actual`) THEN '0.00' WHEN (`q`.`org_amt_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_amt_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_amt_actual` < 1000) THEN `q`.`org_amt_actual` END), ' of ', (CASE WHEN ISNULL(`q`.`org_amt_forcast`) THEN '0.00' WHEN (`q`.`org_amt_forcast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_amt_forcast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_amt_forcast` < 1000) THEN `q`.`org_amt_forcast` END)) AS `org_amt_actual_forcast`, IFNULL(`q`.`org_amt_pcnt`, '0.00') AS `org_amt_pcnt`, CONCAT((CASE WHEN ISNULL(`q`.`org_vac_use`) THEN '0.00' WHEN (`q`.`org_vac_use` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_vac_use` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_vac_use` < 1000) THEN `q`.`org_vac_use` END), ' of ', (CASE WHEN ISNULL(`q`.`org_vac_earn`) THEN '0.00' WHEN (`q`.`org_vac_earn` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`q`.`org_vac_earn` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`q`.`org_vac_earn` < 1000) THEN `q`.`org_vac_earn` END)) AS `org_vac_used_earned`, IFNULL(`q`.`org_vac_pcnt`, '0.00') AS `org_vac_pcnt`, IFNULL(`q`.`org_vac_bal`, '0.00') AS `org_vac_bal`, IFNULL(`a`.`hrs_forecast`, '0.00') AS `hrs_forecast`, IFNULL(`a`.`hrs_actual`, '0.00') AS `hrs_actual`, CONCAT((CASE WHEN ISNULL(`a`.`hrs_actual`) THEN '0.00' WHEN (`a`.`hrs_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`hrs_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`hrs_actual` < 1000) THEN `a`.`hrs_actual` END), ' of ', (CASE WHEN ISNULL(`a`.`hrs_forecast`) THEN '0.00' WHEN (`a`.`hrs_forecast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`hrs_forecast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`hrs_forecast` < 1000) THEN `a`.`hrs_forecast` END)) AS `hrs_actual_forecast`, IFNULL(`a`.`fore_act_pcnt`, '0.00') AS `fore_act_pcnt`, IFNULL(`a`.`amt_forcast`, '0.00') AS `amt_forcast`, IFNULL(`a`.`amt_actual`, '0.00') AS `amt_actual`, CONCAT((CASE WHEN ISNULL(`a`.`amt_actual`) THEN '0.00' WHEN (`a`.`amt_actual` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`amt_actual` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`amt_actual` < 1000) THEN `a`.`amt_actual` END), ' of ', (CASE WHEN ISNULL(`a`.`amt_forcast`) THEN '0.00' WHEN (`a`.`amt_forcast` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`amt_forcast` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`amt_forcast` < 1000) THEN `a`.`amt_forcast` END)) AS `amt_actual_forcast`, IFNULL(`a`.`amt_pcnt`, '0.00') AS `amt_pcnt`, IFNULL(`a`.`vac_earn`, '0.00') AS `vac_earned`, IFNULL(`a`.`vac_use`, '0.00') AS `vac_used`, CONCAT((CASE WHEN ISNULL(`a`.`vac_use`) THEN '0.00' WHEN (`a`.`vac_use` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`vac_use` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`vac_use` < 1000) THEN `a`.`vac_use` END), ' of ', (CASE WHEN ISNULL(`a`.`vac_earn`) THEN '0.00' WHEN (`a`.`vac_earn` > 999) THEN CONVERT( CONCAT((TRIM(ROUND((`a`.`vac_earn` / 1000), 2)) + 0), 'K') USING LATIN1) WHEN (`a`.`vac_earn` < 1000) THEN `a`.`vac_earn` END)) AS `vac_used_earned`, IFNULL(`a`.`vac_pcnt`, '0.00') AS `vac_pcnt`, IFNULL(`a`.`vac_bal`, '0.00') AS `vac_bal`, `a`.`login_id` AS `login_id`, `g`.`domain_nm` AS `domain_name`, `g`.`ip_contry` AS `contry`, `f`.`lastlogin` AS `lastlogin`, DATE_FORMAT(`f`.`lastlogin`, '%m-%d-%y %h:%i %p') AS `lastlogin_fmt`, `f`.`lastlogout` AS `lastlogout`, DATE_FORMAT(`f`.`lastlogout`, '%m-%d-%y %h:%i %p') AS `lastlogout_fmt`, CONCAT(`g`.`ip_address`, ' ', `g`.`domain_nm`, ' ', `g`.`ip_contry`, ' ', `g`.`ip_state`, ' ', `g`.`ip_city`, ' ', `g`.`ip_post_code`) AS `from_fmt`, IFNULL(CONCAT(ROUND(((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`f`.`lastlogout`)) / 3600), 0), ':', ROUND((ROUND(((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`f`.`lastlogout`)) % 3600), 0) / 60), 0)), 'Live') AS `loggged_out`, `f`.`logged_in` AS `logged_in`, TIMESTAMPDIFF(MINUTE, `f`.`lastlogin`, `f`.`lastlogout`) AS `logged_in_tm`, `h`.`idlook_menu_pvt_lvl1` AS `idlook_menu_pvt_lvl1`, `i`.`lk_values` AS `main_menu`, `h`.`idlook_menu_pvt_lvl2` AS `idlook_menu_pvt_lvl2`, `j`.`lk_values` AS `sub_menu`, `a`.`last_updated` AS `last_updated`, DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p') AS `last_updated_fmt`, `a`.`updater` AS `updater`, `l`.`file_name` AS `updater_fnm`, IFNULL(CONCAT(`k`.`firstname`, ' ', `k`.`lastname`), 'Admin') AS `updater_nm`, `a`.`del_dt` AS `del_dt`, DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt_fmt`, `a`.`del_by` AS `del_by`, `n`.`file_name` AS `del_by_fnm`, IFNULL(CONCAT(`m`.`firstname`, ' ', `m`.`lastname`), 'Admin') AS `del_by_nm`, `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 `del_day_vir`, `a`.`archv_dt` AS `archv_dt`, DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `archv_dt_fmt`, `a`.`archv_by` AS `archv_by`, `p`.`file_name` AS `archv_by_fnm`, IFNULL(CONCAT(`o`.`firstname`, ' ', `o`.`lastname`), 'Admin') AS `archv_by_nm` FROM ((((((((((((((((`emp` `a` LEFT JOIN `all_users` `b` ON ((`a`.`emp_id` = `b`.`emp_id`))) LEFT JOIN `emp_lk_val` `c` ON ((`a`.`unique_id_type` = `c`.`idemp_lk_value`))) LEFT JOIN `emp_lk_val` `d` ON ((`a`.`gender` = `d`.`idemp_lk_value`))) LEFT JOIN `storages` `e` ON ((`a`.`idstorage` = `e`.`idstorage`))) LEFT JOIN `all_usr_login` `f` ON ((`a`.`login_id` = `f`.`idall_usr_login`))) LEFT JOIN `look_ip_addr` `g` ON ((`f`.`idlook_ip_addr` = `g`.`idlook_ip_addr`))) LEFT JOIN `all_usr_login` `h` ON ((`a`.`login_id` = `h`.`idall_usr_login`))) LEFT JOIN `look_menu_pvt` `i` ON ((`h`.`idlook_menu_pvt_lvl1` = `i`.`idlook_menu_pvt`))) LEFT JOIN `look_menu_pvt` `j` ON ((`h`.`idlook_menu_pvt_lvl2` = `j`.`idlook_menu_pvt`))) LEFT JOIN `emp` `k` ON ((`a`.`updater` = `k`.`emp_id`))) LEFT JOIN `storages` `l` ON ((`k`.`idstorage` = `l`.`idstorage`))) LEFT JOIN `emp` `m` ON ((`a`.`del_by` = `m`.`emp_id`))) LEFT JOIN `storages` `n` ON ((`m`.`idstorage` = `n`.`idstorage`))) LEFT JOIN `emp` `o` ON ((`a`.`archv_by` = `o`.`emp_id`))) LEFT JOIN `storages` `p` ON ((`o`.`idstorage` = `p`.`idstorage`))) LEFT JOIN `emp_org` `q` ON ((`a`.`emp_id` = `q`.`emp_org_id`))) ORDER BY `a`.`last_updated`