Перестал работать запрос

WITH T1 AS ( SELECT `chat_id`, `count_new_mess` FROM `chat_party` WHERE `user_id` = 141 AND `hidden` = 0), 
T2 AS ( SELECT `chat_id`, MAX(`message_id`) AS last_message_id FROM `chat_messages` WHERE `chat_id` IN (SELECT `chat_id` FROM T1) GROUP BY `chat_id` )
SELECT T1.`chat_id`, T1.`count_new_mess`, C.`name`, C.`privat`, T2.`last_message_id` AS `last_message_id`, CM.`message`, C.`author_user_id`
FROM T1 INNER JOIN `chat` C ON T1.`chat_id` = C.`chat_id`
LEFT OUTER JOIN T2 ON T1.`chat_id` = T2.`chat_id`
LEFT OUTER JOIN `chat_messages` CM ON T2.`last_message_id` = CM.`message_id` 
ORDER BY T2.`last_message_id` DESC

CREATE TABLE `chat` (
  `chat_id` INT(11) NOT NULL,
  `name` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `author_user_id` INT(11) NOT NULL,
  `type_user` INT(11) NOT NULL DEFAULT '0',
  `id_m_p` INT(11) DEFAULT '0',
  `privat` VARCHAR(50) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 
CREATE TABLE `chat_messages` (
  `message_id` INT(11) NOT NULL,
  `chat_id` INT(11) NOT NULL,
  `user_id` INT(11) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_create` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type_user` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 
CREATE TABLE `chat_party` (
  `id` INT(11) NOT NULL,
  `chat_id` INT(11) NOT NULL,
  `user_id` INT(11) NOT NULL,
  `count_new_mess` INT(11) NOT NULL DEFAULT '0',
  `type_user` INT(11) NOT NULL DEFAULT '0',
  `unik` VARCHAR(128) CHARACTER SET utf8 NOT NULL,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `role` VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 
ALTER TABLE `chat`
  ADD PRIMARY KEY (`chat_id`);
 
 
ALTER TABLE `chat_messages`
  ADD PRIMARY KEY (`message_id`);
 
 
ALTER TABLE `chat_party`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unik` (`unik`),
  ADD KEY `chat_id` (`chat_id`);

CREATE TABLE `chat` (
  `chat_id` INT(11) NOT NULL,
  `name` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `author_user_id` INT(11) NOT NULL,
  `type_user` INT(11) NOT NULL DEFAULT '0',
  `id_m_p` INT(11) DEFAULT '0',
  `privat` VARCHAR(50) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`chat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
CREATE TABLE `chat_messages` (
  `message_id` INT(11) NOT NULL,
  `chat_id` INT(11) NOT NULL,
  `user_id` INT(11) NOT NULL,
  `message` TEXT COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_create` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type_user` TINYINT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
CREATE TABLE `chat_party` (
  `id` INT(11) NOT NULL,
  `chat_id` INT(11) NOT NULL,
  `user_id` INT(11) NOT NULL,
  `count_new_mess` INT(11) NOT NULL DEFAULT '0',
  `type_user` INT(11) NOT NULL DEFAULT '0',
  `unik` VARCHAR(128) CHARACTER SET utf8 NOT NULL,
  `hidden` TINYINT(1) NOT NULL DEFAULT '0',
  `role` VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unik` (`unik`),
  KEY `chat_id` (`chat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;