Евгений

Select concat(manager.name," ", manager.surname ) as Ответственный
from manager
where manager.id in (
       #Менеджеры у которых есть незакрытые задачи за последние 30 дней
    SELECT DISTINCT m.manager_id
    FROM manager_task as m
    WHERE m.date_create BETWEEN (now() - INTERVAL 30 DAY) AND (now())
      AND m.date_close is not null
      AND m.manager_id not in (
        #Исключаем менеджеров которые отписались за последние 24 часа
        SELECT DISTINCT manager_task_comment.manager_id
        FROM manager_task_comment
        WHERE manager_task_comment.date_create BETWEEN (now() - INTERVAL 24 HOUR) AND now())