select "" Project30""."" Id1"" as "" Id"", "" Project30""."" Id2"" as "" Id1

SELECT

"" Project30""."" Id1"" AS "" Id"",

"" Project30""."" Id2"" AS "" Id1"",

"" Project30""."" Id3"" AS "" Id2"",

"" Project30""."" Id4"" AS "" Id3"",

"" Project30""."" Id5"" AS "" Id4"",

"" Project30""."" Id7"" AS "" Id5"",

"" Project30""."" Id8"" AS "" Id6"",

"" Project30""."" Id6"" AS "" Id7"",

"" Project30""."" Id9"" AS "" Id8"",

"" Project30""."" Id10"" AS "" Id9"",

"" Project30""."" Id11"" AS "" Id10"",

"" Project30""."" Id12"" AS "" Id11"",

"" Project30""."" Id13"" AS "" Id12"",

"" Project30""."" Id14"" AS "" Id13"",

"" Project30""."" Id15"" AS "" Id14"",

"" Project30""."" Id16"" AS "" Id15"",

"" Project30""."" Id17"" AS "" Id16"",

"" Project30""."" Id18"" AS "" Id17"",

"" Project30""."" Id19"" AS "" Id18"",

"" Project30""."" Id20"" AS "" Id19"",

"" Project30""."" Id21"" AS "" Id20"",

"" Project30""."" Id22"" AS "" Id21"",

"" Project30""."" Id23"" AS "" Id22"",

"" Project30""."" Id24"" AS "" Id23"",

"" Project30""."" Id25"" AS "" Id24"",

"" Project30""."" Id26"" AS "" Id25"",

"" Project30""."" Id27"" AS "" Id26"",

"" Project30""."" Id28"" AS "" Id27"",

"" Project30""."" Id29"" AS "" Id28"",

"" Project30""."" C6"" AS "" C1"",

"" Project30""."" C7"" AS "" C2"",

"" Project30""."" DocumentWriterName"",

"" Project30""."" OfficialPersonName"",

"" Project30""."" OfficialPersonPost"",

"" Project30""."" Code"",

"" Project30""."" CatalogTaskId"",

"" Project30""."" ChainDate"",

"" Project30""."" C8"" AS "" C3"",

"" Project30""."" C9"" AS "" C4"",

"" Project30""."" CreationDate"",

"" Project30""."" C1"" AS "" C5"",

"" Project30""."" GroupId"",

"" Project30""."" C11"" AS "" C6"",

"" Project30""."" Id"" AS "" Id29"",

"" Project30""."" C12"" AS "" C7"",

"" Project30""."" IsConfidential"",

"" Project30""."" C13"" AS "" C8"",

"" Project30""."" C21"" AS "" C9"",

"" Project30""."" C14"" AS "" C10"",

"" Project30""."" C2"" AS "" C11"",

"" Project30""."" C4"" AS "" C12"",

"" Project30""."" OutDate"",

"" Project30""."" OutNumber"",

"" Project30""."" C5"" AS "" C13"",

"" Project30""."" RegistrationDate"",

"" Project30""."" RegistrationNumber"",

"" Project30""."" ReplyFormId"",

"" Project30""."" ReplyTaskId"",

"" Project30""."" C15"" AS "" C14"",

"" Project30""."" Name"",

"" Project30""."" C3"" AS "" C15"",

"" Project30""."" C22"" AS "" C16"",

"" Project30""."" C16"" AS "" C17"",

"" Project30""."" text "",

"" Project30""."" C17"" AS "" C18"",

"" Project30""."" C18"" AS "" C19"",

"" Project30""."" UploadedDate"",

"" Project30""."" C19"" AS "" C20"",

"" Project30""."" C20"" AS "" C21"",

"" Project30""."" Name1"",

"" Project30""."" C10"" AS "" C22"",

"" Project30""."" Id30"",

"" Project30""."" LENGTH""

FROM

(

SELECT

"" Alias1""."" Id"",

"" Alias1""."" text "",

"" Alias1""."" CreationDate"",

"" Alias1""."" UploadedDate"",

"" Alias1""."" ChainDate"",

"" Alias1""."" IsConfidential"",

"" Alias1""."" RegistrationNumber"",

"" Alias1""."" RegistrationDate"",

"" Alias1""."" OutNumber"",

"" Alias1""."" OutDate"",

"" Alias1""."" CatalogTaskId"",

"" Alias1""."" GroupId"",

"" Alias1""."" Id1"",

"" Alias1""."" Id2"",

"" Alias1""."" C1"",

"" Alias1""."" C2"",

"" Alias1""."" C3"",

"" Alias1""."" C4"",

"" Alias1""."" C5"",

"" Alias1""."" Id3"",

"" Alias1""."" OfficialPersonName"",

"" Alias1""."" DocumentWriterName"",

"" Alias1""."" OfficialPersonPost"",

"" Alias1""."" Id4"",

"" Alias1""."" Code"",

"" Alias1""."" ReplyTaskId"",

"" Alias1""."" ReplyFormId"",

"" Alias1""."" Id5"",

"" Alias1""."" Id6"",

"" Alias1""."" Id7"",

"" Alias1""."" Id8"",

"" Alias1""."" Id9"",

"" Alias1""."" Id10"",

"" Alias1""."" Id11"",

"" Alias1""."" Id12"",

"" Alias1""."" Id13"",

"" Alias1""."" Id14"",

"" Alias1""."" Id15"",

"" Alias1""."" Id16"",

"" Alias1""."" Id17"",

"" Alias1""."" Id18"",

"" Alias1""."" Name"",

"" Alias1""."" Id19"",

"" Alias1""."" Id20"",

"" Alias1""."" Id21"",

"" Alias1""."" Id22"",

"" Alias1""."" Id23"",

"" Alias1""."" Id24"",

"" Alias1""."" Id25"",

"" Alias1""."" Id26"",

"" Alias1""."" Id27"",

"" Alias1""."" Id28"",

"" Alias1""."" Id29"",

"" Alias1""."" C6"",

"" Alias1""."" C7"",

"" Alias1""."" C8"",

"" Alias1""."" C9"",

"" Extent62""."" Id"" AS "" Id30"",

"" Extent62""."" Name"" AS "" Name1"",

"" Extent62""."" LENGTH"",

CASE

WHEN ("" Extent61""."" Message_Id"" IS NULL) THEN (CAST (NULL AS int2))

ELSE (CAST ("" Extent62""."" FileType"" AS int2))

END AS "" C10"",

"" Alias1""."" C10"" AS "" C11"",

"" Alias1""."" C11"" AS "" C12"",

"" Alias1""."" C12"" AS "" C13"",

"" Alias1""."" C13"" AS "" C14"",

"" Alias1""."" C14"" AS "" C15"",

"" Alias1""."" C15"" AS "" C16"",

"" Alias1""."" C16"" AS "" C17"",

"" Alias1""."" C17"" AS "" C18"",

"" Alias1""."" C18"" AS "" C19"",

CASE

WHEN ("" Extent61""."" Message_Id"" IS NULL) THEN (CAST (NULL AS int4))

ELSE (1)

END AS "" C20"",

"" Alias1""."" C19"" AS "" C21"",

"" Alias1""."" C20"" AS "" C22""

FROM

(

SELECT

"" Project29""."" Id"",

"" Project29""."" text "",

"" Project29""."" CreationDate"",

"" Project29""."" UploadedDate"",

"" Project29""."" ChainDate"",

"" Project29""."" IsConfidential"",

"" Project29""."" RegistrationNumber"",

"" Project29""."" RegistrationDate"",

"" Project29""."" OutNumber"",

"" Project29""."" OutDate"",

"" Project29""."" CatalogTaskId"",

"" Project29""."" GroupId"",

"" Project29""."" Id1"",

"" Project29""."" Id2"",

"" Project29""."" C1"",

"" Project29""."" C2"",

"" Project29""."" C3"",

"" Project29""."" C4"",

"" Project29""."" C5"",

"" Project29""."" Id3"",

"" Project29""."" OfficialPersonName"",

"" Project29""."" DocumentWriterName"",

"" Project29""."" OfficialPersonPost"",

"" Project29""."" Id4"",

"" Project29""."" Code"",

"" Project29""."" ReplyTaskId"",

"" Project29""."" ReplyFormId"",

"" Project29""."" Id5"",

"" Project29""."" Id6"",

"" Project29""."" Id7"",

"" Project29""."" Id8"",

"" Project29""."" Id9"",

"" Project29""."" Id10"",

"" Project29""."" Id11"",

"" Project29""."" Id12"",

"" Project29""."" Id13"",

"" Project29""."" Id14"",

"" Project29""."" Id15"",

"" Project29""."" Id16"",

"" Project29""."" Id17"",

"" Project29""."" Id18"",

"" Project29""."" Name"",

"" Project29""."" Id19"",

"" Project29""."" Id20"",

"" Project29""."" Id21"",

"" Project29""."" Id22"",

"" Project29""."" Id23"",

"" Project29""."" Id24"",

"" Project29""."" Id25"",

"" Project29""."" Id26"",

"" Project29""."" Id27"",

"" Project29""."" Id28"",

"" Project29""."" Id29"",

"" Project29""."" C6"",

"" Project29""."" C7"",

"" Project29""."" C8"",

"" Project29""."" C9"",

"" Project29""."" C10"",

"" Project29""."" C11"",

"" Project29""."" C12"",

"" Project29""."" C13"",

"" Project29""."" C14"",

"" Project29""."" C15"",

"" Project29""."" C16"",

"" Project29""."" C17"",

"" Project29""."" C18"",

"" Project29""."" C19"",

"" Project29""."" C20""

FROM

(

SELECT

"" Project28""."" Id"",

"" Project28""."" text "",

"" Project28""."" CreationDate"",

"" Project28""."" UploadedDate"",

"" Project28""."" ChainDate"",

"" Project28""."" IsConfidential"",

"" Project28""."" RegistrationNumber"",

"" Project28""."" RegistrationDate"",

"" Project28""."" OutNumber"",

"" Project28""."" OutDate"",

"" Project28""."" CatalogTaskId"",

"" Project28""."" GroupId"",

"" Project28""."" Id1"",

"" Project28""."" Id2"",

"" Project28""."" C1"",

"" Project28""."" C2"",

"" Project28""."" C3"",

"" Project28""."" C4"",

"" Project28""."" C5"",

"" Project28""."" Id3"",

"" Project28""."" OfficialPersonName"",

"" Project28""."" DocumentWriterName"",

"" Project28""."" OfficialPersonPost"",

"" Project28""."" Id4"",

"" Project28""."" Code"",

"" Project28""."" ReplyTaskId"",

"" Project28""."" ReplyFormId"",

"" Project28""."" Id5"",

"" Project28""."" Id6"",

"" Project28""."" Id7"",

"" Project28""."" Id8"",

"" Project28""."" Id9"",

"" Project28""."" Id10"",

"" Project28""."" Id11"",

"" Project28""."" Id12"",

"" Project28""."" Id13"",

"" Project28""."" Id14"",

"" Project28""."" Id15"",

"" Project28""."" Id16"",

"" Project28""."" Id17"",

"" Project28""."" Id18"",

"" Project28""."" Name"",

"" Project28""."" Id19"",

"" Project28""."" Id20"",

"" Project28""."" Id21"",

"" Project28""."" Id22"",

"" Project28""."" Id23"",

"" Project28""."" Id24"",

"" Project28""."" Id25"",

"" Project28""."" Id26"",

"" Project28""."" Id27"",

"" Project28""."" Id28"",

"" Project28""."" Id29"",

"" Project28""."" C6"",

"" Project28""."" C7"",

"" Project28""."" C8"",

"" Project28""."" C9"",

"" Project28""."" C10"",

"" Project28""."" C11"",

"" Project28""."" C12"",

"" Project28""."" C13"",

"" Project28""."" C14"",

"" Project28""."" C15"",

"" Project28""."" C16"",

"" Project28""."" C17"",

"" Project28""."" C18"",

"" Project28""."" C19"",

"" Project28""."" C20""

FROM

(

SELECT

"" Project18""."" Id"",

"" Project18""."" text "",

"" Project18""."" CreationDate"",

"" Project18""."" UploadedDate"",

"" Project18""."" ChainDate"",

"" Project18""."" IsConfidential"",

"" Project18""."" RegistrationNumber"",

"" Project18""."" RegistrationDate"",

"" Project18""."" OutNumber"",

"" Project18""."" OutDate"",

"" Project18""."" CatalogTaskId"",

"" Project18""."" GroupId"",

"" Project18""."" Id1"",

"" Project18""."" Id2"",

"" Project18""."" C1"",

"" Project18""."" C2"",

"" Project18""."" C4"" AS "" C3"",

"" Project18""."" C5"" AS "" C4"",

"" Project18""."" C8"" AS "" C5"",

"" Project18""."" Id3"",

"" Project18""."" OfficialPersonName"",

"" Project18""."" DocumentWriterName"",

"" Project18""."" OfficialPersonPost"",

"" Project18""."" Id4"",

"" Project18""."" Code"",

"" Project18""."" ReplyTaskId"",

"" Project18""."" ReplyFormId"",

"" Project18""."" Id5"",

"" Project18""."" Id6"",

"" Project18""."" Id7"",

"" Project18""."" Id8"",

"" Project18""."" Id9"",

"" Project18""."" Id10"",

"" Project18""."" Id11"",

"" Project18""."" Id12"",

"" Project18""."" Id13"",

"" Project18""."" Id14"",

"" Project18""."" Id15"",

"" Project18""."" Id16"",

"" Project18""."" Id17"",

"" Project18""."" Id18"",

"" Project18""."" Name"",

"" Project18""."" Id19"",

"" Project18""."" Id20"",

"" Project18""."" Id21"",

"" Project18""."" Id22"",

"" Project18""."" Id23"",

"" Project18""."" Id24"",

"" Project18""."" Id25"",

"" Project18""."" Id26"",

"" Project18""."" Id27"",

"" Project18""."" Id28"",

"" Project18""."" Id29"",

1 AS "" C6"",

CASE

WHEN ("" Project18""."" Id3"" IS NULL) THEN (CAST (NULL AS int4))

ELSE (1)

END AS "" C7"",

CASE

WHEN ("" Project18""."" Id5"" IS NULL) THEN ( CASE

WHEN ("" Project18""."" C7"" IS NOT NULL) THEN (CAST ( CASE

WHEN ("" Project18""."" C7"" IS NULL) THEN (0::int2)

ELSE ("" Project18""."" C7"")

END AS int4))

END )

WHEN ("" Project18""."" Id5"" IS NOT NULL) THEN ("" Project18""."" VALUE"")

END AS "" C8"",

CASE

WHEN ("" Project18""."" C10"" > 0) THEN ("" Project18""."" Color"")

ELSE ("" Project18""."" Color1"")

END AS "" C9"",

CASE

WHEN (EXISTS (

SELECT

1 AS "" C1""

FROM

"" dbo""."" MessagesToTags"" AS "" Extent42""

WHERE

"" Project18""."" Id"" = "" Extent42""."" MessageId"")) THEN (TRUE)

ELSE (FALSE)

END AS "" C10"",

CASE

WHEN (1::int2 = CAST ("" Project18""."" C2"" AS int2)

AND (14::int2 = CAST ("" Project18""."" C6"" AS int2)

OR EXISTS (

SELECT

1 AS "" C1""

FROM

(

SELECT

"" Extent43""."" Id"",

CAST ("" Extent43""."" MessageType"" AS int2) AS "" C1""

FROM

"" dbo""."" Messages"" AS "" Extent43""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent44"" ON

"" Extent44""."" MessageId"" IS NOT NULL

AND "" Extent43""."" Id"" = "" Extent44""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent45"" ON

"" Extent45""."" MessageId"" IS NOT NULL

AND "" Extent43""."" Id"" = "" Extent45""."" MessageId""

WHERE

"" Project18""."" Id"" = "" Extent43""."" ParentId"") AS "" Project20""

WHERE

2::int2 = CAST ("" Project20""."" C1"" AS int2)

AND EXISTS (

SELECT

1 AS "" C1""

FROM

"" dbo""."" MessageReceipts"" AS "" Extent46""

left outer join "" dbo""."" StatusEc"" AS "" Extent47"" ON

"" Extent46""."" StatusEcId"" = "" Extent47""."" Id""

WHERE

"" Project20""."" Id"" = "" Extent46""."" MessageId""

AND 5 = CASE

WHEN ("" Extent47""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent46""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent47""."" VALUE"")

END )))) THEN (TRUE)

WHEN (NOT (1::int2 = CAST ("" Project18""."" C2"" AS int2)

AND "" Project18""."" C2"" IS NOT NULL

AND (14::int2 = CAST ("" Project18""."" C6"" AS int2)

AND "" Project18""."" C6"" IS NOT NULL

OR EXISTS (

SELECT

1 AS "" C1""

FROM

(

SELECT

"" Extent48""."" Id"",

CAST ("" Extent48""."" MessageType"" AS int2) AS "" C1""

FROM

"" dbo""."" Messages"" AS "" Extent48""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent49"" ON

"" Extent49""."" MessageId"" IS NOT NULL

AND "" Extent48""."" Id"" = "" Extent49""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent50"" ON

"" Extent50""."" MessageId"" IS NOT NULL

AND "" Extent48""."" Id"" = "" Extent50""."" MessageId""

WHERE

"" Project18""."" Id"" = "" Extent48""."" ParentId"") AS "" Project23""

WHERE

2::int2 = CAST ("" Project23""."" C1"" AS int2)

AND EXISTS (

SELECT

1 AS "" C1""

FROM

"" dbo""."" MessageReceipts"" AS "" Extent51""

left outer join "" dbo""."" StatusEc"" AS "" Extent52"" ON

"" Extent51""."" StatusEcId"" = "" Extent52""."" Id""

WHERE

"" Project23""."" Id"" = "" Extent51""."" MessageId""

AND 5 = CASE

WHEN ("" Extent52""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent51""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent52""."" VALUE"")

END ))))) THEN (FALSE)

END AS "" C11"",

CASE

WHEN (2::int2 = CAST ("" Project18""."" C2"" AS int2)

OR NOT EXISTS (

SELECT

1 AS "" C1""

FROM

"" dbo""."" Messages"" AS "" Extent53""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent54"" ON

"" Extent54""."" MessageId"" IS NOT NULL

AND "" Extent53""."" Id"" = "" Extent54""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent55"" ON

"" Extent55""."" MessageId"" IS NOT NULL

AND "" Extent53""."" Id"" = "" Extent55""."" MessageId""

left outer join "" dbo""."" StatusEc"" AS "" Extent56"" ON

"" Extent53""."" StatusEcId"" = "" Extent56""."" Id""

WHERE

"" Project18""."" Id"" = "" Extent53""."" ParentId""

AND (NOT (8 != CASE

WHEN ("" Extent56""."" Id"" IS NOT NULL) THEN ("" Extent56""."" VALUE"")

ELSE (CAST (CAST ("" Extent53""."" Status"" AS int2) AS int4))

END

AND "" Extent53""."" IsRead"" = TRUE)

OR CASE

WHEN (NOT (8 = CASE

WHEN ("" Extent56""."" Id"" IS NOT NULL) THEN ("" Extent56""."" VALUE"")

ELSE (CAST (CAST ("" Extent53""."" Status"" AS int2) AS int4))

END

AND CASE

WHEN ("" Extent56""."" Id"" IS NOT NULL) THEN ("" Extent56""."" VALUE"")

ELSE (CAST (CAST ("" Extent53""."" Status"" AS int2) AS int4))

END IS NOT NULL)

AND "" Extent53""."" IsRead"" = TRUE) THEN (TRUE)

WHEN (NOT (8 != CASE

WHEN ("" Extent56""."" Id"" IS NOT NULL) THEN ("" Extent56""."" VALUE"")

ELSE (CAST (CAST ("" Extent53""."" Status"" AS int2) AS int4))

END

AND "" Extent53""."" IsRead"" = TRUE)) THEN (FALSE)

END IS NULL))

AND "" Project18""."" IsRead"" = TRUE

AND NOT (8 = CASE

WHEN ("" Project18""."" Id15"" IS NOT NULL) THEN ("" Project18""."" Value1"")

ELSE (CAST ("" Project18""."" C3"" AS int4))

END

AND CASE

WHEN ("" Project18""."" Id15"" IS NOT NULL) THEN ("" Project18""."" Value1"")

ELSE (CAST ("" Project18""."" C3"" AS int4))

END IS NOT NULL)) THEN (TRUE)

WHEN (NOT (2::int2 = CAST ("" Project18""."" C2"" AS int2)

AND "" Project18""."" C2"" IS NOT NULL

OR NOT EXISTS (

SELECT

1 AS "" C1""

FROM

"" dbo""."" Messages"" AS "" Extent57""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent58"" ON

"" Extent58""."" MessageId"" IS NOT NULL

AND "" Extent57""."" Id"" = "" Extent58""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent59"" ON

"" Extent59""."" MessageId"" IS NOT NULL

AND "" Extent57""."" Id"" = "" Extent59""."" MessageId""

left outer join "" dbo""."" StatusEc"" AS "" Extent60"" ON

"" Extent57""."" StatusEcId"" = "" Extent60""."" Id""

WHERE

"" Project18""."" Id"" = "" Extent57""."" ParentId""

AND (NOT (8 != CASE

WHEN ("" Extent60""."" Id"" IS NOT NULL) THEN ("" Extent60""."" VALUE"")

ELSE (CAST (CAST ("" Extent57""."" Status"" AS int2) AS int4))

END

AND "" Extent57""."" IsRead"" = TRUE)

OR CASE

WHEN (NOT (8 = CASE

WHEN ("" Extent60""."" Id"" IS NOT NULL) THEN ("" Extent60""."" VALUE"")

ELSE (CAST (CAST ("" Extent57""."" Status"" AS int2) AS int4))

END

AND CASE

WHEN ("" Extent60""."" Id"" IS NOT NULL) THEN ("" Extent60""."" VALUE"")

ELSE (CAST (CAST ("" Extent57""."" Status"" AS int2) AS int4))

END IS NOT NULL)

AND "" Extent57""."" IsRead"" = TRUE) THEN (TRUE)

WHEN (NOT (8 != CASE

WHEN ("" Extent60""."" Id"" IS NOT NULL) THEN ("" Extent60""."" VALUE"")

ELSE (CAST (CAST ("" Extent57""."" Status"" AS int2) AS int4))

END

AND "" Extent57""."" IsRead"" = TRUE)) THEN (FALSE)

END IS NULL))

AND "" Project18""."" IsRead"" = TRUE

AND 8 != CASE

WHEN ("" Project18""."" Id15"" IS NOT NULL) THEN ("" Project18""."" Value1"")

ELSE (CAST ("" Project18""."" C3"" AS int4))

END )) THEN (FALSE)

END AS "" C12"",

CASE

WHEN ("" Project18""."" Id15"" IS NOT NULL) THEN ("" Project18""."" Value1"")

ELSE (CAST ("" Project18""."" C3"" AS int4))

END AS "" C13"",

CASE

WHEN ("" Project18""."" Id16"" IS NOT NULL

AND "" Project18""."" Id17"" IS NOT NULL) THEN ("" Project18""."" FormCipher"")

END AS "" C14"",

CASE

WHEN ("" Project18""."" C13"" > 0) THEN ( CASE

WHEN ("" Project18""."" Id22"" IS NULL) THEN (CAST ("" Project18""."" C9"" AS int4))

ELSE ("" Project18""."" Value2"")

END )

WHEN ("" Project18""."" Id15"" IS NULL) THEN (CAST ("" Project18""."" C3"" AS int4))

ELSE ("" Project18""."" Value1"")

END AS "" C15"",

CASE

WHEN ("" Project18""."" Id16"" IS NOT NULL) THEN ("" Project18""."" Timeliness"")

END AS "" C16"",

CASE

WHEN (CAST (char_length("" Project18""."" Title"") AS int4) > 400) THEN ( CASE

WHEN (SUBSTR("" Project18""."" Title"",

0 + 1,

400) IS NULL) THEN (E'')

ELSE (SUBSTR("" Project18""."" Title"",

0 + 1,

400))

END || E'...')

ELSE ("" Project18""."" Title"")

END AS "" C17"",

CASE

WHEN ("" Project18""."" Id17"" IS NOT NULL) THEN ("" Project18""."" version "")

END AS "" C18"",

"" Project18""."" C11"" AS "" C19"",

"" Project18""."" C12"" AS "" C20""

FROM

(

SELECT

"" Project17""."" Id"",

"" Project17""."" Title"",

"" Project17""."" text "",

"" Project17""."" CreationDate"",

"" Project17""."" UploadedDate"",

"" Project17""."" ChainDate"",

"" Project17""."" IsRead"",

"" Project17""."" IsConfidential"",

"" Project17""."" RegistrationNumber"",

"" Project17""."" RegistrationDate"",

"" Project17""."" OutNumber"",

"" Project17""."" OutDate"",

"" Project17""."" CatalogTaskId"",

"" Project17""."" GroupId"",

"" Project17""."" Id1"",

"" Project17""."" Id2"",

"" Project17""."" C1"",

"" Project17""."" C2"",

"" Project17""."" C3"",

"" Project17""."" C4"",

"" Project17""."" C5"",

"" Project17""."" C6"",

"" Project17""."" C7"",

"" Project17""."" C8"",

"" Project17""."" Id3"",

"" Project17""."" OfficialPersonName"",

"" Project17""."" DocumentWriterName"",

"" Project17""."" OfficialPersonPost"",

"" Project17""."" Id4"",

"" Project17""."" Code"",

"" Project17""."" ReplyTaskId"",

"" Project17""."" ReplyFormId"",

"" Project17""."" Id5"",

"" Project17""."" VALUE"",

"" Project17""."" Id6"",

"" Project17""."" Id7"",

"" Project17""."" Id8"",

"" Project17""."" Id9"",

"" Project17""."" Color"",

"" Project17""."" Id10"",

"" Project17""."" Id11"",

"" Project17""."" Id12"",

"" Project17""."" Color1"",

"" Project17""."" Id13"",

"" Project17""."" Id14"",

"" Project17""."" Id15"",

"" Project17""."" Value1"",

"" Project17""."" Id16"",

"" Project17""."" Timeliness"",

"" Project17""."" Id17"",

"" Project17""."" version "",

"" Project17""."" Id18"",

"" Project17""."" Name"",

"" Project17""."" FormCipher"",

"" Project17""."" Id19"",

"" Project17""."" Id20"",

"" Project17""."" Id21"",

"" Project17""."" Id22"",

"" Project17""."" Id23"",

"" Project17""."" Id24"",

"" Project17""."" Id25"",

"" Project17""."" C9"",

"" Project17""."" Id26"",

"" Project17""."" Id27"",

"" Project17""."" Id28"",

"" Project17""."" Id29"",

"" Project17""."" Value2"",

"" Project17""."" C10"",

"" Project17""."" C11"",

"" Project17""."" C12"",

(

SELECT

CAST (COUNT(1) AS int4) AS "" A1""

FROM

"" dbo""."" Messages"" AS "" Extent39""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent40"" ON

"" Extent40""."" MessageId"" IS NOT NULL

AND "" Extent39""."" Id"" = "" Extent40""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent41"" ON

"" Extent41""."" MessageId"" IS NOT NULL

AND "" Extent39""."" Id"" = "" Extent41""."" MessageId""

WHERE

"" Project17""."" Id"" = "" Extent39""."" ParentId"") AS "" C13""

FROM

(

SELECT

"" Project16""."" Id"",

"" Project16""."" Title"",

"" Project16""."" text "",

"" Project16""."" CreationDate"",

"" Project16""."" UploadedDate"",

"" Project16""."" ChainDate"",

"" Project16""."" IsRead"",

"" Project16""."" IsConfidential"",

"" Project16""."" RegistrationNumber"",

"" Project16""."" RegistrationDate"",

"" Project16""."" OutNumber"",

"" Project16""."" OutDate"",

"" Project16""."" CatalogTaskId"",

"" Project16""."" GroupId"",

"" Project16""."" Id1"",

"" Project16""."" Id2"",

"" Project16""."" C1"",

"" Project16""."" C2"",

"" Project16""."" C3"",

"" Project16""."" C4"",

"" Project16""."" C5"",

"" Project16""."" C6"",

"" Project16""."" C7"",

"" Project16""."" C8"",

"" Project16""."" Id3"",

"" Project16""."" OfficialPersonName"",

"" Project16""."" DocumentWriterName"",

"" Project16""."" OfficialPersonPost"",

"" Project16""."" Id4"",

"" Project16""."" Code"",

"" Project16""."" ReplyTaskId"",

"" Project16""."" ReplyFormId"",

"" Project16""."" Id5"",

"" Project16""."" VALUE"",

"" Project16""."" Id6"",

"" Project16""."" Id7"",

"" Project16""."" Id8"",

"" Project16""."" Id9"",

"" Project16""."" Color"",

"" Project16""."" Id10"",

"" Project16""."" Id11"",

"" Project16""."" Id12"",

"" Project16""."" Color1"",

"" Project16""."" Id13"",

"" Project16""."" Id14"",

"" Project16""."" Id15"",

"" Project16""."" Value1"",

"" Project16""."" Id16"",

"" Project16""."" Timeliness"",

"" Project16""."" Id17"",

"" Project16""."" version "",

"" Project16""."" Id18"",

"" Project16""."" Name"",

"" Project16""."" FormCipher"",

"" Project16""."" Id19"",

"" Project16""."" Id20"",

"" Project16""."" Id21"",

"" Project16""."" Id22"",

"" Project16""."" Id23"",

"" Project16""."" Id24"",

"" Project16""."" Id25"",

"" Project16""."" C9"",

"" Project16""."" Id26"",

"" Project16""."" Id27"",

"" Project16""."" Id28"",

"" Project16""."" Id29"",

"" Project16""."" Value2"",

"" Project16""."" C10"",

"" Project16""."" C11"",

(

SELECT

CAST (SUM("" Extent38""."" LENGTH"") AS int8) AS "" A1""

FROM

"" dbo""."" MessageFiles"" AS "" Extent37""

inner join "" dbo""."" Files"" AS "" Extent38"" ON

"" Extent38""."" Id"" = "" Extent37""."" File_Id""

WHERE

"" Project16""."" Id"" = "" Extent37""."" Message_Id""

AND NOT (8 = CAST (CAST ("" Extent38""."" FileType"" AS int2) AS int4)

AND "" Extent38""."" FileType"" IS NOT NULL)) AS "" C12""

FROM

(

SELECT

"" Project15""."" Id"",

"" Project15""."" Title"",

"" Project15""."" text "",

"" Project15""."" CreationDate"",

"" Project15""."" UploadedDate"",

"" Project15""."" ChainDate"",

"" Project15""."" IsRead"",

"" Project15""."" IsConfidential"",

"" Project15""."" RegistrationNumber"",

"" Project15""."" RegistrationDate"",

"" Project15""."" OutNumber"",

"" Project15""."" OutDate"",

"" Project15""."" CatalogTaskId"",

"" Project15""."" GroupId"",

"" Project15""."" Id1"",

"" Project15""."" Id2"",

"" Project15""."" C1"",

"" Project15""."" C2"",

"" Project15""."" C3"",

"" Project15""."" C4"",

"" Project15""."" C5"",

"" Project15""."" C6"",

"" Project15""."" C7"",

"" Project15""."" C8"",

"" Project15""."" Id3"",

"" Project15""."" OfficialPersonName"",

"" Project15""."" DocumentWriterName"",

"" Project15""."" OfficialPersonPost"",

"" Project15""."" Id4"",

"" Project15""."" Code"",

"" Project15""."" ReplyTaskId"",

"" Project15""."" ReplyFormId"",

"" Project15""."" Id5"",

"" Project15""."" VALUE"",

"" Project15""."" Id6"",

"" Project15""."" Id7"",

"" Project15""."" Id8"",

"" Project15""."" Id9"",

"" Project15""."" Color"",

"" Project15""."" Id10"",

"" Project15""."" Id11"",

"" Project15""."" Id12"",

"" Project15""."" Color1"",

"" Project15""."" Id13"",

"" Project15""."" Id14"",

"" Project15""."" Id15"",

"" Project15""."" Value1"",

"" Project15""."" Id16"",

"" Project15""."" Timeliness"",

"" Project15""."" Id17"",

"" Project15""."" version "",

"" Project15""."" Id18"",

"" Project15""."" Name"",

"" Project15""."" FormCipher"",

"" Project15""."" Id19"",

"" Project15""."" Id20"",

"" Project15""."" Id21"",

"" Project15""."" Id22"",

"" Project15""."" Id23"",

"" Project15""."" Id24"",

"" Project15""."" Id25"",

"" Project15""."" C9"",

"" Project15""."" Id26"",

"" Project15""."" Id27"",

"" Project15""."" Id28"",

"" Project15""."" Id29"",

"" Project15""."" Value2"",

"" Project15""."" C10"",

(

SELECT

CAST (COUNT(1) AS int4) AS "" A1""

FROM

"" dbo""."" Messages"" AS "" Extent34""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent35"" ON

"" Extent35""."" MessageId"" IS NOT NULL

AND "" Extent34""."" Id"" = "" Extent35""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent36"" ON

"" Extent36""."" MessageId"" IS NOT NULL

AND "" Extent34""."" Id"" = "" Extent36""."" MessageId""

WHERE

"" Project15""."" Id"" = "" Extent34""."" ParentId"") AS "" C11""

FROM

(

SELECT

"" Project14""."" Id"",

"" Project14""."" Title"",

"" Project14""."" text "",

"" Project14""."" CreationDate"",

"" Project14""."" UploadedDate"",

"" Project14""."" ChainDate"",

"" Project14""."" IsRead"",

"" Project14""."" IsConfidential"",

"" Project14""."" RegistrationNumber"",

"" Project14""."" RegistrationDate"",

"" Project14""."" OutNumber"",

"" Project14""."" OutDate"",

"" Project14""."" CatalogTaskId"",

"" Project14""."" GroupId"",

"" Project14""."" Id1"",

"" Project14""."" Id2"",

"" Project14""."" C1"",

"" Project14""."" C2"",

"" Project14""."" C3"",

"" Project14""."" C4"",

"" Project14""."" C5"",

"" Project14""."" C6"",

"" Project14""."" C7"",

"" Project14""."" C8"",

"" Project14""."" Id3"",

"" Project14""."" OfficialPersonName"",

"" Project14""."" DocumentWriterName"",

"" Project14""."" OfficialPersonPost"",

"" Project14""."" Id4"",

"" Project14""."" Code"",

"" Project14""."" ReplyTaskId"",

"" Project14""."" ReplyFormId"",

"" Project14""."" Id5"",

"" Project14""."" VALUE"",

"" Project14""."" Id6"",

"" Project14""."" Id7"",

"" Project14""."" Id8"",

"" Project14""."" Id9"",

"" Project14""."" Color"",

"" Project14""."" Id10"",

"" Project14""."" Id11"",

"" Project14""."" Id12"",

"" Project14""."" Color1"",

"" Project14""."" Id13"",

"" Project14""."" Id14"",

"" Project14""."" Id15"",

"" Project14""."" Value1"",

"" Project14""."" Id16"",

"" Project14""."" Timeliness"",

"" Project14""."" Id17"",

"" Project14""."" version "",

"" Project14""."" Id18"",

"" Project14""."" Name"",

"" Project14""."" FormCipher"",

"" Project14""."" Id19"",

"" Project14""."" Id20"",

"" Project14""."" Id21"",

"" Project14""."" Id22"",

"" Project14""."" Id23"",

"" Project14""."" Id24"",

"" Project14""."" Id25"",

"" Project14""."" C9"",

"" Project14""."" Id26"",

"" Project14""."" Id27"",

"" Project14""."" Id28"",

"" Project14""."" Id29"",

"" Project14""."" Value2"",

(

SELECT

CAST (COUNT(1) AS int4) AS "" A1""

FROM

"" dbo""."" Messages"" AS "" Extent31""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent32"" ON

"" Extent32""."" MessageId"" IS NOT NULL

AND "" Extent31""."" Id"" = "" Extent32""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent33"" ON

"" Extent33""."" MessageId"" IS NOT NULL

AND "" Extent31""."" Id"" = "" Extent33""."" MessageId""

WHERE

"" Project14""."" Id"" = "" Extent31""."" ParentId"") AS "" C10""

FROM

(

SELECT

"" Project12""."" Id"",

"" Project12""."" Title"",

"" Project12""."" text "",

"" Project12""."" CreationDate"",

"" Project12""."" UploadedDate"",

"" Project12""."" ChainDate"",

"" Project12""."" IsRead"",

"" Project12""."" IsConfidential"",

"" Project12""."" RegistrationNumber"",

"" Project12""."" RegistrationDate"",

"" Project12""."" OutNumber"",

"" Project12""."" OutDate"",

"" Project12""."" CatalogTaskId"",

"" Project12""."" GroupId"",

"" Project12""."" Id1"",

"" Project12""."" Id2"",

"" Project12""."" C1"",

"" Project12""."" C2"",

"" Project12""."" C3"",

"" Project12""."" C4"",

"" Project12""."" C5"",

"" Project12""."" C6"",

"" Project12""."" C7"",

"" Project12""."" C8"",

"" Project12""."" Id3"",

"" Project12""."" OfficialPersonName"",

"" Project12""."" DocumentWriterName"",

"" Project12""."" OfficialPersonPost"",

"" Project12""."" Id4"",

"" Project12""."" Code"",

"" Project12""."" ReplyTaskId"",

"" Project12""."" ReplyFormId"",

"" Project12""."" Id5"",

"" Project12""."" VALUE"",

"" Project12""."" Id6"",

"" Project12""."" Id7"",

"" Project12""."" Id8"",

"" Project12""."" Id9"",

"" Project12""."" Color"",

"" Project12""."" Id10"",

"" Project12""."" Id11"",

"" Project12""."" Id12"",

"" Project12""."" Color1"",

"" Project12""."" Id13"",

"" Project12""."" Id14"",

"" Project12""."" Id15"",

"" Project12""."" Value1"",

"" Project12""."" Id16"",

"" Project12""."" Timeliness"",

"" Project12""."" Id17"",

"" Project12""."" version "",

"" Project12""."" Id18"",

"" Project12""."" Name"",

"" Project12""."" FormCipher"",

"" Project12""."" Id19"",

"" Project12""."" Id20"",

"" Project12""."" Id21"",

"" Project12""."" Id22"",

"" Project12""."" Id23"",

"" Project12""."" Id24"",

"" Project12""."" Id25"",

"" Project12""."" C9"",

"" Alias11""."" Id"" AS "" Id26"",

"" Alias11""."" Id1"" AS "" Id27"",

"" Alias11""."" Id2"" AS "" Id28"",

"" Extent30""."" Id"" AS "" Id29"",

"" Extent30""."" VALUE"" AS "" Value2""

FROM

(

SELECT

"" Project10""."" Id"",

"" Project10""."" Title"",

"" Project10""."" text "",

"" Project10""."" CreationDate"",

"" Project10""."" UploadedDate"",

"" Project10""."" ChainDate"",

"" Project10""."" IsRead"",

"" Project10""."" IsConfidential"",

"" Project10""."" RegistrationNumber"",

"" Project10""."" RegistrationDate"",

"" Project10""."" OutNumber"",

"" Project10""."" OutDate"",

"" Project10""."" CatalogTaskId"",

"" Project10""."" GroupId"",

"" Project10""."" Id1"",

"" Project10""."" Id2"",

"" Project10""."" C1"",

"" Project10""."" C2"",

"" Project10""."" C3"",

"" Project10""."" C4"",

"" Project10""."" C5"",

"" Project10""."" C6"",

"" Project10""."" C7"",

"" Project10""."" C8"",

"" Project10""."" Id3"",

"" Project10""."" OfficialPersonName"",

"" Project10""."" DocumentWriterName"",

"" Project10""."" OfficialPersonPost"",

"" Project10""."" Id4"",

"" Project10""."" Code"",

"" Project10""."" ReplyTaskId"",

"" Project10""."" ReplyFormId"",

"" Project10""."" Id5"",

"" Project10""."" VALUE"",

"" Project10""."" Id6"",

"" Project10""."" Id7"",

"" Project10""."" Id8"",

"" Project10""."" Id9"",

"" Project10""."" Color"",

"" Project10""."" Id10"",

"" Project10""."" Id11"",

"" Project10""."" Id12"",

"" Project10""."" Color1"",

"" Project10""."" Id13"",

"" Project10""."" Id14"",

"" Project10""."" Id15"",

"" Project10""."" Value1"",

"" Project10""."" Id16"",

"" Project10""."" Timeliness"",

"" Project10""."" Id17"",

"" Project10""."" version "",

"" Project10""."" Id18"",

"" Project10""."" Name"",

"" Project10""."" FormCipher"",

"" Project10""."" Id19"",

"" Project10""."" Id20"",

"" Project10""."" Id21"",

"" Project10""."" Id22"",

"" Alias10""."" Id"" AS "" Id23"",

"" Alias10""."" Id1"" AS "" Id24"",

"" Alias10""."" Id2"" AS "" Id25"",

"" Alias10""."" C1"" AS "" C9""

FROM

(

SELECT

"" Project8""."" Id"",

"" Project8""."" Title"",

"" Project8""."" text "",

"" Project8""."" CreationDate"",

"" Project8""."" UploadedDate"",

"" Project8""."" ChainDate"",

"" Project8""."" IsRead"",

"" Project8""."" IsConfidential"",

"" Project8""."" RegistrationNumber"",

"" Project8""."" RegistrationDate"",

"" Project8""."" OutNumber"",

"" Project8""."" OutDate"",

"" Project8""."" CatalogTaskId"",

"" Project8""."" GroupId"",

"" Project8""."" Id1"",

"" Project8""."" Id2"",

"" Project8""."" C1"",

"" Project8""."" C2"",

"" Project8""."" C3"",

"" Project8""."" C4"",

"" Project8""."" C5"",

"" Project8""."" C6"",

"" Project8""."" C7"",

"" Project8""."" C8"",

"" Project8""."" Id3"",

"" Project8""."" OfficialPersonName"",

"" Project8""."" DocumentWriterName"",

"" Project8""."" OfficialPersonPost"",

"" Project8""."" Id4"",

"" Project8""."" Code"",

"" Project8""."" ReplyTaskId"",

"" Project8""."" ReplyFormId"",

"" Project8""."" Id5"",

"" Project8""."" VALUE"",

"" Project8""."" Id6"",

"" Project8""."" Id7"",

"" Project8""."" Id8"",

"" Project8""."" Id9"",

"" Project8""."" Color"",

"" Project8""."" Id10"",

"" Project8""."" Id11"",

"" Project8""."" Id12"",

"" Project8""."" Color1"",

"" Project8""."" Id13"",

"" Project8""."" Id14"",

"" Project8""."" Id15"",

"" Project8""."" Value1"",

"" Project8""."" Id16"",

"" Project8""."" Timeliness"",

"" Project8""."" Id17"",

"" Project8""."" version "",

"" Project8""."" Id18"",

"" Project8""."" Name"",

"" Project8""."" FormCipher"",

"" Alias9""."" Id"" AS "" Id19"",

"" Alias9""."" Id1"" AS "" Id20"",

"" Alias9""."" Id2"" AS "" Id21"",

"" Extent23""."" Id"" AS "" Id22""

FROM

(

SELECT

"" Project5""."" Id"",

"" Project5""."" Title"",

"" Project5""."" text "",

"" Project5""."" CreationDate"",

"" Project5""."" UploadedDate"",

"" Project5""."" ChainDate"",

"" Project5""."" IsRead"",

"" Project5""."" IsConfidential"",

"" Project5""."" RegistrationNumber"",

"" Project5""."" RegistrationDate"",

"" Project5""."" OutNumber"",

"" Project5""."" OutDate"",

"" Project5""."" CatalogTaskId"",

"" Project5""."" GroupId"",

"" Project5""."" Id1"",

"" Project5""."" Id2"",

"" Project5""."" C1"",

"" Project5""."" C2"",

"" Project5""."" C3"",

"" Project5""."" C4"",

"" Project5""."" C5"",

"" Project5""."" C6"",

"" Project5""."" C7"",

"" Project5""."" C8"",

"" Project5""."" Id3"",

"" Project5""."" OfficialPersonName"",

"" Project5""."" DocumentWriterName"",

"" Project5""."" OfficialPersonPost"",

"" Project5""."" Id4"",

"" Project5""."" Code"",

"" Project5""."" ReplyTaskId"",

"" Project5""."" ReplyFormId"",

"" Project5""."" Id5"",

"" Project5""."" VALUE"",

"" Project5""."" Id6"",

"" Project5""."" Id7"",

"" Project5""."" Id8"",

"" Project5""."" Id9"",

"" Project5""."" Color"",

"" Project5""."" Id10"",

"" Project5""."" Id11"",

"" Alias8""."" Id"" AS "" Id12"",

"" Alias8""."" Color"" AS "" Color1"",

"" Alias8""."" Id1"" AS "" Id13"",

"" Alias8""."" Id2"" AS "" Id14"",

"" Extent16""."" Id"" AS "" Id15"",

"" Extent16""."" VALUE"" AS "" Value1"",

"" Extent17""."" Id"" AS "" Id16"",

"" Extent17""."" Timeliness"",

"" Extent18""."" Id"" AS "" Id17"",

"" Extent18""."" version "",

"" Extent19""."" Id"" AS "" Id18"",

"" Extent19""."" Name"",

"" Extent19""."" FormCipher""

FROM

(

SELECT

"" Project1""."" Id"",

"" Project1""."" Title"",

"" Project1""."" text "",

"" Project1""."" CreationDate"",

"" Project1""."" UploadedDate"",

"" Project1""."" ChainDate"",

"" Project1""."" IsRead"",

"" Project1""."" IsConfidential"",

"" Project1""."" RegistrationNumber"",

"" Project1""."" RegistrationDate"",

"" Project1""."" OutNumber"",

"" Project1""."" OutDate"",

"" Project1""."" CatalogTaskId"",

"" Project1""."" GroupId"",

"" Project1""."" StatusEcId"",

"" Project1""."" Id1"",

"" Project1""."" Id2"",

"" Project1""."" C1"",

"" Project1""."" C2"",

"" Project1""."" C3"",

"" Project1""."" C4"",

"" Project1""."" C5"",

"" Project1""."" C6"",

"" Project1""."" C7"",

"" Project1""."" C8"",

"" Project1""."" Id3"",

"" Project1""."" OfficialPersonName"",

"" Project1""."" DocumentWriterName"",

"" Project1""."" OfficialPersonPost"",

"" Project1""."" Id4"",

"" Project1""."" Code"",

"" Project1""."" ReplyTaskId"",

"" Project1""."" ReplyFormId"",

"" Project1""."" Id5"",

"" Project1""."" VALUE"",

"" Alias6""."" Id"" AS "" Id6"",

"" Alias6""."" Id1"" AS "" Id7"",

"" Alias6""."" Id2"" AS "" Id8"",

"" Alias6""."" Id3"" AS "" Id9"",

"" Alias6""."" Color"",

"" Alias6""."" Id4"" AS "" Id10"",

"" Alias6""."" Id5"" AS "" Id11""

FROM

(

SELECT

"" Join4""."" Id"",

"" Join4""."" Title"",

"" Join4""."" text "",

"" Join4""."" CreationDate"",

"" Join4""."" UploadedDate"",

"" Join4""."" ChainDate"",

"" Join4""."" IsRead"",

"" Join4""."" IsConfidential"",

"" Join4""."" RegistrationNumber"",

"" Join4""."" RegistrationDate"",

"" Join4""."" OutNumber"",

"" Join4""."" OutDate"",

"" Join4""."" CatalogTaskId"",

"" Join4""."" GroupId"",

"" Join4""."" StatusEcId"",

"" Join4""."" Id_Alias2"" AS "" Id1"",

"" Join4""."" Id_Alias3"" AS "" Id2"",

CAST ("" Join4""."" EntityType"" AS int2) AS "" C1"",

CAST ("" Join4""."" MessageType"" AS int2) AS "" C2"",

CAST ("" Join4""."" Status"" AS int2) AS "" C3"",

CAST ("" Join4""."" RowState"" AS int2) AS "" C4"",

CAST ("" Join4""."" MethodExchange"" AS int2) AS "" C5"",

CAST ("" Join4""."" ReplyStage"" AS int2) AS "" C6"",

CAST ("" Join4""."" ChainStatus"" AS int2) AS "" C7"",

CAST ("" Join4""."" Rating"" AS int2) AS "" C8"",

"" Join4""."" Id_Alias4"" AS "" Id3"",

"" Join4""."" OfficialPersonName"",

"" Join4""."" DocumentWriterName"",

"" Join4""."" OfficialPersonPost"",

"" Join4""."" Id_Alias5"" AS "" Id4"",

"" Join4""."" Code"",

"" Join4""."" ReplyTaskId"",

"" Join4""."" ReplyFormId"",

"" Extent6""."" Id"" AS "" Id5"",

"" Extent6""."" VALUE""

FROM

(

SELECT

"" Extent1""."" ChainStatusEcId"",

"" Extent1""."" OwnerId"",

"" Extent1""."" Id"",

"" Extent1""."" Title"",

"" Extent1""."" text "",

"" Extent1""."" CreationDate"",

"" Extent1""."" UploadedDate"",

"" Extent1""."" ChainDate"",

"" Extent1""."" IsRead"",

"" Extent1""."" IsConfidential"",

"" Extent1""."" RegistrationNumber"",

"" Extent1""."" RegistrationDate"",

"" Extent1""."" OutNumber"",

"" Extent1""."" OutDate"",

"" Extent1""."" CatalogTaskId"",

"" Extent1""."" GroupId"",

"" Extent1""."" StatusEcId"",

"" Extent2""."" Id"" AS "" Id_Alias2"",

"" Extent3""."" Id"" AS "" Id_Alias3"",

"" Extent1""."" EntityType"",

"" Extent1""."" MessageType"",

"" Extent1""."" Status"",

"" Extent1""."" RowState"",

"" Extent1""."" MethodExchange"",

"" Extent1""."" ReplyStage"",

"" Extent1""."" ChainStatus"",

"" Extent1""."" Rating"",

"" Extent4""."" Id"" AS "" Id_Alias4"",

"" Extent4""."" OfficialPersonName"",

"" Extent4""."" DocumentWriterName"",

"" Extent4""."" OfficialPersonPost"",

"" Extent5""."" Id"" AS "" Id_Alias5"",

"" Extent5""."" Code"",

"" Extent5""."" ReplyTaskId"",

"" Extent5""."" ReplyFormId""

FROM

"" dbo""."" Messages"" AS "" Extent1""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent2"" ON

"" Extent2""."" MessageId"" IS NOT NULL

AND "" Extent1""."" Id"" = "" Extent2""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent3"" ON

"" Extent3""."" MessageId"" IS NOT NULL

AND "" Extent1""."" Id"" = "" Extent3""."" MessageId""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent4"" ON

"" Extent1""."" Id"" = "" Extent4""."" MessageId""

left outer join "" dbo""."" DictCatalogTasks"" AS "" Extent5"" ON

"" Extent1""."" CatalogTaskId"" = "" Extent5""."" Id""

WHERE

12::int2 != CAST (CAST ("" Extent1""."" EntityType"" AS int2) AS int2)

AND "" Extent1""."" ParentId"" IS NULL) AS "" Join4""

left outer join "" dbo""."" StatusEc"" AS "" Extent6"" ON

"" Join4""."" ChainStatusEcId"" = "" Extent6""."" Id""

WHERE

"" Join4""."" OwnerId"" = $1

OR "" Join4""."" OwnerId"" IS NULL

AND $1 IS NULL) AS "" Project1""

left outer join lateral (

SELECT

"" Project4""."" Id"",

"" Project4""."" Id1"",

"" Project4""."" Id2"",

"" Project4""."" Id3"",

"" Project4""."" Color"",

"" Project4""."" Id4"",

"" Project4""."" Id5""

FROM

(

SELECT

"" Alias7""."" Id"",

"" Alias7""."" Id1"",

"" Alias7""."" Id2"",

"" Extent10""."" Id"" AS "" Id3"",

"" Extent10""."" CreationDate"",

"" Extent10""."" Color"",

"" Extent11""."" Id"" AS "" Id4"",

"" Project3""."" Id"" AS "" Id5""

FROM

(

SELECT

"" Project2""."" Id"",

"" Project2""."" Id1"",

"" Project2""."" Id2""

FROM

(

SELECT

"" Extent7""."" Id"",

"" Extent7""."" CreationDate"",

"" Extent8""."" Id"" AS "" Id1"",

"" Extent9""."" Id"" AS "" Id2""

FROM

"" dbo""."" Messages"" AS "" Extent7""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent8"" ON

"" Extent8""."" MessageId"" IS NOT NULL

AND "" Extent7""."" Id"" = "" Extent8""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent9"" ON

"" Extent9""."" MessageId"" IS NOT NULL

AND "" Extent7""."" Id"" = "" Extent9""."" MessageId""

WHERE

"" Project1""."" Id"" = "" Extent7""."" ParentId"") AS "" Project2""

ORDER BY

"" Project2""."" CreationDate"" DESC

limit 1) AS "" Alias7""

inner join "" dbo""."" MessageReceipts"" AS "" Extent10"" ON

"" Alias7""."" Id"" = "" Extent10""."" MessageId""

left outer join "" dbo""."" StatusEc"" AS "" Extent11"" ON

"" Extent10""."" StatusEcId"" = "" Extent11""."" Id""

left outer join (

SELECT

"" Extent12""."" Id"",

"" Extent12""."" VALUE""

FROM

"" dbo""."" StatusEc"" AS "" Extent12""

WHERE

"" Project1""."" StatusEcId"" = "" Extent12""."" Id"") AS "" Project3"" ON

TRUE = TRUE

WHERE

CASE

WHEN ("" Extent11""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent10""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent11""."" VALUE"")

END = CASE

WHEN ("" Project3""."" Id"" IS NOT NULL) THEN ("" Project3""."" VALUE"")

ELSE (CAST ("" Project1""."" C3"" AS int4))

END

OR CASE

WHEN ("" Extent11""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent10""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent11""."" VALUE"")

END IS NULL

AND CASE

WHEN ("" Project3""."" Id"" IS NOT NULL) THEN ("" Project3""."" VALUE"")

ELSE (CAST ("" Project1""."" C3"" AS int4))

END IS NULL) AS "" Project4""

ORDER BY

"" Project4""."" CreationDate"" DESC

limit 1) AS "" Alias6"" ON

TRUE) AS "" Project5""

left outer join lateral (

SELECT

"" Project7""."" Id"",

"" Project7""."" Color"",

"" Project7""."" Id1"",

"" Project7""."" Id2""

FROM

(

SELECT

"" Extent13""."" Id"",

"" Extent13""."" CreationDate"",

"" Extent13""."" Color"",

"" Extent14""."" Id"" AS "" Id1"",

"" Project6""."" Id"" AS "" Id2""

FROM

"" dbo""."" MessageReceipts"" AS "" Extent13""

left outer join "" dbo""."" StatusEc"" AS "" Extent14"" ON

"" Extent13""."" StatusEcId"" = "" Extent14""."" Id""

left outer join (

SELECT

"" Extent15""."" Id"",

"" Extent15""."" VALUE""

FROM

"" dbo""."" StatusEc"" AS "" Extent15""

WHERE

"" Project5""."" StatusEcId"" = "" Extent15""."" Id"") AS "" Project6"" ON

TRUE = TRUE

WHERE

"" Project5""."" Id"" = "" Extent13""."" MessageId""

AND ( CASE

WHEN ("" Extent14""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent13""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent14""."" VALUE"")

END = CASE

WHEN ("" Project6""."" Id"" IS NOT NULL) THEN ("" Project6""."" VALUE"")

ELSE (CAST ("" Project5""."" C3"" AS int4))

END

OR CASE

WHEN ("" Extent14""."" Id"" IS NULL) THEN (CAST (CAST ("" Extent13""."" ReceiptStatus"" AS int2) AS int4))

ELSE ("" Extent14""."" VALUE"")

END IS NULL

AND CASE

WHEN ("" Project6""."" Id"" IS NOT NULL) THEN ("" Project6""."" VALUE"")

ELSE (CAST ("" Project5""."" C3"" AS int4))

END IS NULL)) AS "" Project7""

ORDER BY

"" Project7""."" CreationDate"" DESC

limit 1) AS "" Alias8"" ON

TRUE

left outer join "" dbo""."" StatusEc"" AS "" Extent16"" ON

"" Project5""."" StatusEcId"" = "" Extent16""."" Id""

left outer join "" dbo""."" MessageData"" AS "" Extent17"" ON

"" Project5""."" Id"" = "" Extent17""."" MessageId""

left outer join "" dbo""."" FormPatterns"" AS "" Extent18"" ON

"" Extent17""."" FormPatternId"" = "" Extent18""."" Id""

left outer join "" dbo""."" DictReportForms"" AS "" Extent19"" ON

"" Extent18""."" ReportFormId"" = "" Extent19""."" Id"") AS "" Project8""

left outer join lateral (

SELECT

"" Project9""."" StatusEcId"",

"" Project9""."" Id"",

"" Project9""."" Id1"",

"" Project9""."" Id2""

FROM

(

SELECT

"" Extent20""."" Id"",

"" Extent20""."" CreationDate"",

"" Extent20""."" StatusEcId"",

"" Extent21""."" Id"" AS "" Id1"",

"" Extent22""."" Id"" AS "" Id2""

FROM

"" dbo""."" Messages"" AS "" Extent20""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent21"" ON

"" Extent21""."" MessageId"" IS NOT NULL

AND "" Extent20""."" Id"" = "" Extent21""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent22"" ON

"" Extent22""."" MessageId"" IS NOT NULL

AND "" Extent20""."" Id"" = "" Extent22""."" MessageId""

WHERE

"" Project8""."" Id"" = "" Extent20""."" ParentId"") AS "" Project9""

ORDER BY

"" Project9""."" CreationDate"" DESC

limit 1) AS "" Alias9"" ON

TRUE

left outer join "" dbo""."" StatusEc"" AS "" Extent23"" ON

"" Alias9""."" StatusEcId"" = "" Extent23""."" Id"") AS "" Project10""

left outer join lateral (

SELECT

"" Project11""."" Id"",

"" Project11""."" Id1"",

"" Project11""."" Id2"",

"" Project11""."" C1""

FROM

(

SELECT

"" Extent24""."" Id"",

"" Extent24""."" CreationDate"",

"" Extent25""."" Id"" AS "" Id1"",

"" Extent26""."" Id"" AS "" Id2"",

CAST ("" Extent24""."" Status"" AS int2) AS "" C1""

FROM

"" dbo""."" Messages"" AS "" Extent24""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent25"" ON

"" Extent25""."" MessageId"" IS NOT NULL

AND "" Extent24""."" Id"" = "" Extent25""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent26"" ON

"" Extent26""."" MessageId"" IS NOT NULL

AND "" Extent24""."" Id"" = "" Extent26""."" MessageId""

WHERE

"" Project10""."" Id"" = "" Extent24""."" ParentId"") AS "" Project11""

ORDER BY

"" Project11""."" CreationDate"" DESC

limit 1) AS "" Alias10"" ON

TRUE) AS "" Project12""

left outer join lateral (

SELECT

"" Project13""."" StatusEcId"",

"" Project13""."" Id"",

"" Project13""."" Id1"",

"" Project13""."" Id2""

FROM

(

SELECT

"" Extent27""."" Id"",

"" Extent27""."" CreationDate"",

"" Extent27""."" StatusEcId"",

"" Extent28""."" Id"" AS "" Id1"",

"" Extent29""."" Id"" AS "" Id2""

FROM

"" dbo""."" Messages"" AS "" Extent27""

left outer join "" dbo""."" AbonentInfo"" AS "" Extent28"" ON

"" Extent28""."" MessageId"" IS NOT NULL

AND "" Extent27""."" Id"" = "" Extent28""."" MessageId""

left outer join "" dbo""."" MessageData"" AS "" Extent29"" ON

"" Extent29""."" MessageId"" IS NOT NULL

AND "" Extent27""."" Id"" = "" Extent29""."" MessageId""

WHERE

"" Project12""."" Id"" = "" Extent27""."" ParentId"") AS "" Project13""

ORDER BY

"" Project13""."" CreationDate"" DESC

limit 1) AS "" Alias11"" ON

TRUE

left outer join "" dbo""."" StatusEc"" AS "" Extent30"" ON

"" Alias11""."" StatusEcId"" = "" Extent30""."" Id"") AS "" Project14"") AS "" Project15"") AS "" Project16"") AS "" Project17"") AS "" Project18"") AS "" Project28"") AS "" Project29""

ORDER BY

"" Project29""."" CreationDate"" DESC offset 110850

limit 10) AS "" Alias1""

left outer join "" dbo""."" MessageFiles"" AS "" Extent61""

inner join "" dbo""."" Files"" AS "" Extent62"" ON

"" Extent62""."" Id"" = "" Extent61""."" File_Id"" ON

"" Alias1""."" Id"" = "" Extent61""."" Message_Id""

AND NOT (8 = CAST (CAST ("" Extent62""."" FileType"" AS int2) AS int4)

AND "" Extent62""."" FileType"" IS NOT NULL)) AS "" Project30""

ORDER BY

"" Project30""."" CreationDate"" DESC ,

"" Project30""."" Id1"" ASC ,

"" Project30""."" Id2"" ASC ,

"" Project30""."" Id3"" ASC ,

"" Project30""."" Id4"" ASC ,

"" Project30""."" Id5"" ASC ,

"" Project30""."" Id7"" ASC ,

"" Project30""."" Id8"" ASC ,

"" Project30""."" Id6"" ASC ,

"" Project30""."" Id9"" ASC ,

"" Project30""."" Id10"" ASC ,

"" Project30""."" Id11"" ASC ,

"" Project30""."" Id12"" ASC ,

"" Project30""."" Id13"" ASC ,

"" Project30""."" Id14"" ASC ,

"" Project30""."" Id15"" ASC ,

"" Project30""."" Id16"" ASC ,

"" Project30""."" Id17"" ASC ,

"" Project30""."" Id18"" ASC ,

"" Project30""."" Id19"" ASC ,

"" Project30""."" Id20"" ASC ,

"" Project30""."" Id21"" ASC ,

"" Project30""."" Id22"" ASC ,

"" Project30""."" Id23"" ASC ,

"" Project30""."" Id24"" ASC ,

"" Project30""."" Id25"" ASC ,

"" Project30""."" Id26"" ASC ,

"" Project30""."" Id27"" ASC ,

"" Project30""."" Id28"" ASC ,

"" Project30""."" Id29"" ASC ,

"" Project30""."" Id"" ASC ,

"" Project30""."" C20"" ASC

Untitled