By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE brand ( b_id INT);
CREATE TABLE model ( m_id INT, b_id INT);
CREATE TABLE item ( i_id INT, m_id INT);
INSERT INTO brand VALUES (1), (2), (3), (4);
INSERT INTO model VALUES (11,1), (111,1), (22,2), (222,2), (33,3);
INSERT INTO item VALUES(1111,11), (11111,111), (2222,22);
Records: 4 Duplicates: 0 Warnings: 0
Records: 5 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
SELECT brand.b_id
FROM brand
NATURAL LEFT JOIN model
NATURAL LEFT JOIN item
GROUP BY 1
HAVING NOT SUM(i_id IS NULL)
| b_id |
|---|
| 1 |