SELECT menu_1.*, user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_1.id
                WHERE permissions_user._employee_id = 1601 AND menu_1.id IS NOT NULL and menu_1.left_menu = 1
                UNION
                SELECT menu_2.*,user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN menu AS menu_2 ON menu_2.id = menu_1.parent
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_2.id
                WHERE permissions_user._employee_id = 1601 AND menu_2.id IS NOT NULL and menu_2.left_menu = 1
                UNION
                SELECT menu_3.*,user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN menu AS menu_2 ON menu_2.id = menu_1.parent
                LEFT OUTER JOIN menu AS menu_3 ON menu_3.id = menu_2.parent
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_3.id
                WHERE permissions_user._employee_id = 1601 AND menu_3.id IS NOT NULL and menu_3.left_menu = 1
                UNION
                SELECT menu_4.*,user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN menu AS menu_2 ON menu_2.id = menu_1.parent
                LEFT OUTER JOIN menu AS menu_3 ON menu_3.id = menu_2.parent
                LEFT OUTER JOIN menu AS menu_4 ON menu_4.id = menu_3.parent
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_4.id
                WHERE permissions_user._employee_id = 1601 AND menu_4.id IS NOT NULL and menu_4.left_menu = 1
                UNION
                SELECT menu_5.*,user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN menu AS menu_2 ON menu_2.id = menu_1.parent
                LEFT OUTER JOIN menu AS menu_3 ON menu_3.id = menu_2.parent
                LEFT OUTER JOIN menu AS menu_4 ON menu_4.id = menu_3.parent
                LEFT OUTER JOIN menu AS menu_5 ON menu_5.id = menu_4.parent
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_5.id
                WHERE permissions_user._employee_id = 1601 AND menu_5.id IS NOT NULL and menu_5.left_menu = 1
                UNION
                SELECT menu_6.*,user_favorites.id AS favorite
                FROM permissions_user
                LEFT OUTER JOIN permissions_menu ON permissions_menu._permission_id = permissions_user._permission_id
                LEFT OUTER JOIN menu AS menu_1 ON menu_1.id = permissions_menu._menu_id
                LEFT OUTER JOIN menu AS menu_2 ON menu_2.id = menu_1.parent
                LEFT OUTER JOIN menu AS menu_3 ON menu_3.id = menu_2.parent
                LEFT OUTER JOIN menu AS menu_4 ON menu_4.id = menu_3.parent
                LEFT OUTER JOIN menu AS menu_5 ON menu_5.id = menu_4.parent
                LEFT OUTER JOIN menu AS menu_6 ON menu_6.id = menu_5.parent
                LEFT OUTER JOIN user_favorites ON user_favorites._employee_id = permissions_user._employee_id AND user_favorites._menu_id = menu_6.id
                WHERE permissions_user._employee_id = 1601 AND menu_6.id IS NOT NULL and menu_6.left_menu = 1
                GROUP BY permissions_user.id
                ORDER BY menu_order