MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- структура 

CREATE TABLE `data` (
    `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `content` text NOT NULL,
        PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `hub` (
`page` varchar(64) NOT NULL,
`section` int(11) UNSIGNED NULL DEFAULT NULL,
`data` int(11) UNSIGNED NULL,
    UNIQUE (`page`, `section`, `data`) USING BTREE,
    INDEX `page-I`(`page`) USING BTREE,
    INDEX `section-I`(`section`) USING BTREE,
    INDEX `data-I`(`data`) USING BTREE,
    CONSTRAINT `page-FK` FOREIGN KEY (`data`)
        REFERENCES `data` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT               
) ENGINE = InnoDB;

CREATE TABLE `section` (
    `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`)
) ENGINE = InnoDB;
-- исходные данные

INSERT INTO section VALUES
(1,	'foo'),
(2,	'bar'),
(3,	'baz');

INSERT INTO data VALUES
(1,	'some text - 1'),
(2,	'some text - 2'),
(3,	'some text - 3'),
(4,	'some text - 4'),
(5,	'some text - 5');

INSERT INTO hub VALUES
('index',	1,	NULL),
('about',	2,	1),
('about',	3,	1),
('about',	4,	NULL),
('contacts',	5,	2),
('contacts',	NULL,	1);
-- просмотр исходного состояния

SELECT * FROM section;
SELECT * FROM data;
SELECT * FROM hub;


id
title


1
foo

2
bar

3
baz




id
content


1
some text - 1

2
some text - 2

3
some text - 3

4
some text - 4

5
some text - 5




page
section
data


about
2
1

about
3
1

about
4
null

contacts
null
1

contacts
5
2

index
1
null


-- посмотрим, что собираемсчя удалять

SELECT * 
FROM data
LEFT JOIN hub ON data.id = hub.data
LEFT JOIN section ON section.id = hub.section
WHERE data.id IN(2,5)


id
content
page
section
data
id
title


2
some text - 2
contacts
5
2
null
null

5
some text - 5
null
null
null
null
null


-- удаляем

DELETE data, hub, section
FROM data
LEFT JOIN hub ON data.id = hub.data
LEFT JOIN section ON section.id = hub.section
WHERE data.id IN(2,5)
-- смотрим, что осталось

SELECT * FROM section;
SELECT * FROM data;
SELECT * FROM hub;


id
title


1
foo

2
bar

3
baz




id
content


1
some text - 1

3
some text - 3

4
some text - 4




page
section
data


about
2
1

about
3
1

about
4
null

contacts
null
1

index
1
null
id	content
1	some text - 1
2	some text - 2
3	some text - 3
4	some text - 4
5	some text - 5
page	section	data
about	2	1
about	3	1
about	4	null
contacts	null	1
contacts	5	2
index	1	null