CREATE TABLE `travel_point` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`travel_id` int unsigned NOT NULL,
`from` varchar(255) NOT NULL,
`to` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
INSERT INTO `travel_point` (`id`, `travel_id`, `from`, `to`) VALUES
(1, 1, 'МСК', 'СПБ'),
(2, 1, 'СПБ', 'КРД'),
(3, 1, 'КРД', 'СОЧИ'),
(4, 2, 'МСК', 'СПБ'),
(5, 3, 'КРД', 'СПБ'),
(6, 3, 'СПБ', 'СОЧИ'),
(7, 4, 'ОМСК', 'СОЧИ'),
(8, 4, 'СОЧИ', 'СПБ'),
(9, 4, 'СПБ', 'СОЧИ');SELECT `travel_id`
FROM `travel_point`
WHERE `from`='МСК' OR `to`='СОЧИ'
GROUP BY `travel_id`
HAVING COUNT(`id`)>1SELECT `travel_id`
FROM `travel_point` AS `t1` JOIN `travel_point` as `t2` USING (`travel_id`)
WHERE `t1`.`from`='СПБ' AND `t2`.`to`='СОЧИ'
GROUP BY `travel_id`DirectoryIndex index.html index.php
Забавная в теории штука, тот кто это придумал явно дружит с юмором.