SELECT
   TaskBase.Uid AS [Уникальный идентификатор],
            TaskBase.Subject AS [Тема],
            TaskBase.Description AS [Описание],
            TaskBase.CreationDate AS [Дата создания],
            TaskBase.CreationAuthor AS [Автор],
            Executor.FullName AS [Исполнитель],
            Executor.Id AS [Исполнитель Ид],
            TaskBase.StartDate AS [Дата начала],
            TaskBase.EndDate AS [Срок завершения],
            TaskBase.Priority AS [Приоритет],
            (CASE
      WHEN  TaskBase.[STATUS] = '34387afa-6b70-476f-9d34-748732059003' THEN 'Новая'
      WHEN  TaskBase.[STATUS] = 'dd048b73-4e08-404a-b62e-c55222845cc4' THEN 'Выполнено'
       WHEN  TaskBase.[STATUS] = '1710de4d-86fa-4072-951a-55ebbdcd5bf1' THEN 'Невозможно выполнить'
        WHEN  TaskBase.[STATUS] = '37a184b8-a81d-4177-9eb5-4ebe3dfae959' THEN 'Выполняется'
         WHEN  TaskBase.[STATUS] = 'fd7993c6-99c7-4b23-83cc-0f576a63c144' THEN 'Закрыто автором'
          WHEN  TaskBase.[STATUS] = '85707efe-806c-4ec6-8cd6-4d5e4edd8b19' THEN 'Прочитана'
           WHEN  TaskBase.[STATUS] = '112ea757-36f7-4859-b0d3-6cc0f5a04705' THEN 'Подготовлено'
            WHEN  TaskBase.[STATUS] = '46f88008-94cd-4b14-985c-31ba6edeb60e' THEN 'Выполнено и проконтролировано'
             WHEN  TaskBase.[STATUS] = '2968382b-e9be-4e2f-967b-0dce0a67a4c4' THEN 'Невозможно выполнить и проконтролировано'
              WHEN  TaskBase.[STATUS] = 'b9c9f74a-15ec-4337-9916-f02ffec83dd4' THEN 'На предварительном согласовании'
               WHEN  TaskBase.[STATUS] = '1f6de7ff-03af-401a-a3ca-23af7cab8f65' THEN 'Отказано в предварительном согласовании'
                WHEN  TaskBase.[STATUS] = 'b0b6a339-ba74-4e46-b721-2733d7fb76a9' THEN 'На согласовании'
                 WHEN  TaskBase.[STATUS] = '70918293-8b84-43be-ad39-181375d51373' THEN 'Отказано в согласовании'
                  WHEN  TaskBase.[STATUS] = '98ff43bd-b897-41f0-adf2-4eb3b3783851' THEN 'Не выполнено'
   END  )
            AS [Статус],
            TaskBase.StartWorkDate AS [Работа начата],
            TaskBase.EndWorkDate AS [Работа выполнена],
            TaskBase.Harmonizator AS [Согласующий],
            TaskBase.NotShowInLists AS [Не отображать в общих списках],
            TaskBase.InformToHash AS [InformToHash],
            TaskBase.Category AS [Категория],
            TaskBase.ExpiredNotificationSent AS [Уведомление о просрочке отправлено],
            TaskBase.PlanWorkLog AS [Плановые трудозатраты],
            TaskBase.IsEmulation AS [Эмуляция],
            TaskBase.ExecutorIsEmulation AS [Исполнитель при эмуляции],
            TaskBase.FactWorkLog AS [Фактические трудозатраты],
      WorkflowInstance.Process
      ,WorkflowInstance.ParentInstance
      ,WorkflowInstance.ParentBookmark
      ,WorkflowInstance.Name
      ,WorkflowInstance.State
      ,WorkflowInstance.Initiator
      ,WorkflowInstance.Responsible
      ,WorkflowInstance.StartDate
      ,WorkflowInstance.EndDate
      ,WorkflowInstance.STATUS
      ,WorkflowInstance.HasProblemMetric
      ,WorkflowInstance.TerminateUser
      ,WorkflowInstance.HasWarningMetric
      ,WorkflowInstance.ShowProblemMetric
      ,WorkflowInstance.ShowWarningMetric
      ,WorkflowInstance.ShowGoodMetric
      ,WorkflowInstance.AllMetricsIsGood
      ,WorkflowInstance.IsEmulation
      ,WorkflowInstance.StartActivityUid

            FROM WorkflowTask
            LEFT JOIN   TaskBase ON TaskBase.Id = WorkflowTask.Id
            LEFT JOIN   WorkflowBookmark ON WorkflowBookmark.Id = TaskBase.WorkflowBookmark
            LEFT JOIN   WorkflowInstance  ON WorkflowBookmark.Instance = WorkflowInstance.Id
            LEFT JOIN [USER] Executor ON Executor.Id = TaskBase.Executor

            WHERE TaskBase.[STATUS] = 'dd048b73-4e08-404a-b62e-c55222845cc4'