Составление сложного запроса SQL

CREATE EXTENSION ltree;
 
CREATE TABLE all_clothes (
    id INTEGER PRIMARY KEY,
    name TEXT,
    image_path VARCHAR(250),
    parent_id INTEGER REFERENCES all_clothes ON DELETE CASCADE,
    parent_path LTREE
);
 
CREATE TABLE characters (
    id INTEGER PRIMARY KEY,
    image_path VARCHAR(250),
    description TEXT,
    posted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
 
CREATE TABLE clothes_on_characters (
    id INTEGER PRIMARY KEY,
    character_id INTEGER REFERENCES characters ON DELETE CASCADE,
    clothes_id INTEGER REFERENCES all_clothes ON DELETE CASCADE
);
 
CREATE OR REPLACE FUNCTION update_all_clothes_parent_path() RETURNS TRIGGER AS $$
    DECLARE
        path ltree;
    BEGIN
        IF NEW.parent_id IS NULL THEN
            NEW.parent_path = NEW.id::text::ltree;
        ELSE
            SELECT parent_path FROM all_clothes WHERE id = NEW.parent_id INTO path;
            IF path IS NULL THEN
                RAISE EXCEPTION 'Invalid parent_id %', NEW.parent_id;
            END IF;
            NEW.parent_path = (path::text || '.' || NEW.id)::ltree;
        END IF;
        RETURN NEW;
    END;
$$ LANGUAGE plpgsql;
 
CREATE TRIGGER all_clothes_parent_path_tgr BEFORE INSERT OR UPDATE ON all_clothes
    FOR EACH ROW EXECUTE PROCEDURE update_all_clothes_parent_path();

SELECT * FROM characters WHERE id IN (SELECT character_id FROM clothes_on_characters WHERE clothes_id IN (SELECT id FROM all_clothes WHERE parent_path <@ '1.2.4'))
INTERSECT
SELECT * FROM characters WHERE id IN (SELECT character_id FROM clothes_on_characters WHERE clothes_id IN (SELECT id FROM all_clothes WHERE parent_path <@ '9.10'))