CREATE TABLE SEA (
    WORD_ID    INTEGER NOT NULL,
    OBJECT_ID  CHAR(16) CHARACTER SET OCTETS NOT NULL,
    NS_LEFT    INTEGER NOT NULL,
    NS_RIGHT   INTEGER NOT NULL
);

SELECT t1.object_id as obj_id
FROM sea t1
inner join sea t2
   on t2.ns_left  < t1.ns_right
  and t2.ns_right > t1.ns_left
group by t1.object_id, t1.ns_left, t1.ns_right
having count(distinct t2.word_id) >= 3
   and t1.ns_left  = max(t2.ns_left)
   and t1.ns_right = min(t2.ns_right)

   and t1.ns_left  = max(t2.ns_left)
   and t1.ns_right = min(t2.ns_right)

CREATE TABLE FIAS$SEARCH_PREPARE (
    WORD_ID    D$INTEGER NOT NULL,
    OBJECT_FK  D$GUID NOT NULL,
    NS_LEFT    D$INTEGER DEFAULT 0 NOT NULL,
    NS_RIGHT   D$INTEGER DEFAULT 0 NOT NULL
);

OBJECT_ID	PARENT_FK	NAME	NS_LEFT	NS_RIGHT
743FA475-8AFA-4CAF-B211-0F0372A2D762    BC4E8FBC-54DC-4114-9C48-FD7A9B3E2E5C    Санкт-Петербургская 1411152 1411153
BC4E8FBC-54DC-4114-9C48-FD7A9B3E2E5C    AB9218FD-CB07-4BB8-AFF2-EE3D735E9CAC    Старая Русса        1410849 1411248
AB9218FD-CB07-4BB8-AFF2-EE3D735E9CAC    E5A84B81-8EA1-49E3-B3C4-0528651BE129    Старорусский        1409768 1411261
E5A84B81-8EA1-49E3-B3C4-0528651BE129    NULL                                    Новгородская        1393227 1414996

      SELECT T1.OBJECT_FK
      FROM FIAS$SEARCH_PREPARE T1
      INNER JOIN FIAS$SEARCH_PREPARE T2
         ON T1.NS_LEFT  BETWEEN T2.NS_LEFT AND T2.NS_RIGHT
        AND T1.NS_RIGHT BETWEEN T2.NS_LEFT AND T2.NS_RIGHT
      GROUP BY T1.NS_LEFT, T1.NS_RIGHT, T1.OBJECT_FK
      HAVING COUNT(DISTINCT T2.WORD_ID) >= (SELECT COUNT(DISTINCT WORD_ID) FROM FIAS$SEARCH_PREPARE)

ALTER TABLE FIAS$SEARCH_PREPARE ADD CONSTRAINT FIAS$SEARCH_PREPARE$PK PRIMARY KEY (WORD_ID, OBJECT_FK);
CREATE INDEX FIAS$SEARCH_PREPARE$IDX_NS_PAIR ON FIAS$SEARCH_PREPARE (NS_LEFT, NS_RIGHT, OBJECT_FK);

SELECT node.object_id AS node_id
  FROM sea node
    INNER JOIN sea child
      ON child.ns_left > node.ns_left AND child.ns_right < node.ns_right
  GROUP BY node.object_id
  HAVING Count(DISTINCT t2.word_id) > 2

select t.node_id, gfu.address from (
SELECT node.object_fk AS node_id
  FROM FIAS$SEARCH_PREPARE node
    INNER JOIN FIAS$SEARCH_PREPARE child
      ON child.ns_left > node.ns_left AND child.ns_right < node.ns_right
  GROUP BY node.object_fk
  HAVING Count(DISTINCT child.word_id) > 2
) t
    LEFT OUTER JOIN FIAS$GET_FULL_ADDRESS(t.node_id, '', '', 0) GFU ON 0 = 0t