SELECT DISTINCT
    menu.id,
    menu.parent,
    menu.name,
    menu.role,
    menu.`order`,
    menu.action,
    menu.action_string
  FROM menu
    INNER JOIN role_pages
      ON FIND_IN_SET(menu.action_string, (SELECT
          GROUP_CONCAT(role_pages.pages) AS expr1
        FROM role_pages
          INNER JOIN users
            ON role_pages.id_role = users.role
        WHERE users.login = login_))
      OR menu.action_string = ''
    INNER JOIN users
      ON users.role = role_pages.id_role
      AND menu.parent = a_id
      AND menu.action = 0
  ORDER BY menu.`order`;

SET @@max_sp_recursion_depth = 10;

IF ntree_ready = 1
  THEN
    DROP TABLE IF EXISTS menu_tree;

    CREATE TABLE menu_tree (
      id int(11) NOT NULL AUTO_INCREMENT,
      id_in int(11) NOT NULL,
      parent_id int(11) NOT NULL,
      name varchar(50) NOT NULL,
      role int(11) NOT NULL,
      nlevel int(11) NOT NULL,
      `order` int(11) DEFAULT NULL,
      action int(11),
      action_string varchar(50),
      PRIMARY KEY (id)
    )
    ENGINE = MEMORY
    AUTO_INCREMENT = 1
    AVG_ROW_LENGTH = 176
    CHARACTER SET utf8
    COLLATE utf8_general_ci;

  END IF;