CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_menu_global` AS
    SELECT 
        `a`.`iddev_apps` AS `iddev_apps`,
        `a`.`app_name` AS `app_name`,
        `a`.`comp_id` AS `comp_id`,
        `b`.`idstorage` AS `idstorage`,
        `b`.`comp_pub_menu_id` AS `comp_pub_menu_id`,
        `b`.`comp_private_menu_id` AS `comp_private_menu_id`,
        `c`.`look_values_id` AS `main_menu_id`,
        `c`.`look_values` AS `main_menu`,
        `c`.`look_value_desc` AS `main_menu_file`,
        `c`.`look_value_code` AS `main_menu_code`,
        `c`.`look_display_id` AS `main_dis_order`,
        0 AS `sub_menu_id`,
        NULL AS `sub_menu`,
        NULL AS `sub_menu_file`,
        0 AS `sub_menu_code`,
        0 AS `sub_dis_order`,
        `c`.`look_sub_value_id` AS `look_sub_value_id`,
        `c`.`look_values_id` AS `look_values_id`
    FROM
        (`aerion`.`look_values` `c`
        LEFT JOIN (`aerion`.`dev_apps` `a`
        LEFT JOIN `aerion`.`company` `b` ON ((`a`.`comp_id` = `b`.`comp_id`))) ON ((`b`.`comp_private_menu_id` = `c`.`look_sub_value_id`)))
    WHERE
        (`a`.`menu_show` = _LATIN1'Y') 
    UNION SELECT 
        `a`.`iddev_apps` AS `iddev_apps`,
        `a`.`app_name` AS `app_name`,
        `a`.`comp_id` AS `comp_id`,
        `b`.`idstorage` AS `idstorage`,
        `b`.`comp_pub_menu_id` AS `comp_pub_menu_id`,
        `b`.`comp_private_menu_id` AS `comp_private_menu_id`,
        `c`.`look_values_id` AS `main_menu_id`,
        `c`.`look_values` AS `main_menu`,
        `c`.`look_value_desc` AS `main_menu_file`,
        `c`.`look_value_code` AS `main_menu_code`,
        `c`.`look_display_id` AS `main_dis_order`,
        `d`.`look_values_id` AS `sub_menu_id`,
        `d`.`look_values` AS `sub_menu`,
        `d`.`look_value_desc` AS `sub_menu_file`,
        `d`.`look_value_code` AS `sub_menu_code`,
        `d`.`look_display_id` AS `sub_dis_order`,
        `d`.`look_sub_value_id` AS `look_sub_value_id`,
        `d`.`look_values_id` AS `look_values_id`
    FROM
        (`aerion`.`look_values` `d`
        LEFT JOIN (`aerion`.`look_values` `c`
        LEFT JOIN (`aerion`.`dev_apps` `a`
        LEFT JOIN `aerion`.`company` `b` ON ((`a`.`comp_id` = `b`.`comp_id`))) ON ((`b`.`comp_private_menu_id` = `c`.`look_sub_value_id`))) ON ((`c`.`look_values_id` = `d`.`look_sub_value_id`)))
    WHERE
        (`a`.`menu_show` = _LATIN1'Y')
    ORDER BY `iddev_apps` , `comp_pub_menu_id` , `comp_private_menu_id` , `main_menu_id` , `main_dis_order` , (CASE
        WHEN ISNULL(`sub_dis_order`) THEN `sub_menu_id`
        ELSE `sub_dis_order`
    END)