CREATE TABLE `agency` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `regions` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logotype` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `operating_time` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ;

SELECT * FROM agency
WHERE id NOT IN (SELECT * 
FROM (SELECT MIN(n.id)
FROM agency n
GROUP BY n.name, n.regions) x)