CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_storages_temp` AS
    SELECT 
        `a`.`idstorage` AS `idstorage_temp`,
        `a`.`doc_id` AS `doc_type`,
        `d`.`look_values` AS `doc_look_values`,
        DATE_FORMAT(`a`.`doc_exp_dt`, _UTF8'%y-%m-%d') AS `expire_dt`,
        DATE_FORMAT(`a`.`doc_exp_dt`, _UTF8'%m-%d-%y') AS `mod_expire_dt`,
        `a`.`owner_id` AS `owner_id`,
        `a`.`file_name` AS `file_name`,
        `a`.`public` AS `public`,
        `a`.`self_view` AS `self_view`,
        `a`.`shared` AS `shared`,
        `a`.`updated_for_ref_id` AS `updated_for_ref_id`,
        `a`.`updated_for_ref_table` AS `updated_for_ref_table`,
        `a`.`tag_id` AS `tag_id`,
        `a`.`user_session_id` AS `user_session_id`
    FROM
        (`aerion`.`storages_temp` `a`
        LEFT JOIN `aerion`.`look_values` `d` ON ((`a`.`doc_id` = `d`.`look_values_id`)))
    WHERE
        (`a`.`edit_id` = _LATIN1'')