<?query --
SELECT DISTINCT
T1.Fld4510_,
CASE WHEN T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x00000048 THEN T80._Fld6406RRef WHEN T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006E THEN T82._Fld6406RRef WHEN T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006F THEN T84._Fld6406RRef WHEN T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006D THEN T86._Fld6406RRef WHEN T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000008A THEN T88._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END,
T14.Fld4510_,
T27.Fld4510_,
T40.Fld4510_,
T53.Fld4510_,
T66.Fld4510_
FROM (SELECT
T2._Fld4500RRef AS Fld4500RRef,
T2._Fld4504_TYPE AS Fld4504_TYPE,
T2._Fld4504_RTRef AS Fld4504_RTRef,
T2._Fld4504_RRRef AS Fld4504_RRRef,
T2._Fld4510 AS Fld4510_,
CAST(SUM(T2._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T2._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T2._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T2._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T2._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T2._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T2._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T2._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T2._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T2._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T2._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T2
LEFT OUTER JOIN dbo._Document72 T3
ON T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x00000048 AND T2._Fld4504_RRRef = T3._IDRRef
LEFT OUTER JOIN dbo._Reference35 T4
ON T3._Fld965RRef = T4._IDRRef
LEFT OUTER JOIN dbo._Document110 T5
ON T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006E AND T2._Fld4504_RRRef = T5._IDRRef
LEFT OUTER JOIN dbo._Reference35 T6
ON T5._Fld2024RRef = T6._IDRRef
LEFT OUTER JOIN dbo._Document111 T7
ON T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006F AND T2._Fld4504_RRRef = T7._IDRRef
LEFT OUTER JOIN dbo._Reference35 T8
ON T7._Fld2069RRef = T8._IDRRef
LEFT OUTER JOIN dbo._Document109 T9
ON T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006D AND T2._Fld4504_RRRef = T9._IDRRef
LEFT OUTER JOIN dbo._Reference35 T10
ON T9._Fld1975RRef = T10._IDRRef
LEFT OUTER JOIN dbo._Document138 T11
ON T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000008A AND T2._Fld4504_RRRef = T11._IDRRef
LEFT OUTER JOIN dbo._Reference35 T12
ON T11._Fld3029RRef = T12._IDRRef
LEFT OUTER JOIN dbo._Reference32 T13
ON T2._Fld4500RRef = T13._IDRRef
WHERE T2._Period >= @P1 AND T2._Period < @P2 AND ((((CASE WHEN T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x00000048 THEN T4._Fld6406RRef WHEN T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006E THEN T6._Fld6406RRef WHEN T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006F THEN T8._Fld6406RRef WHEN T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000006D THEN T10._Fld6406RRef WHEN T2._Fld4504_TYPE = 0x08 AND T2._Fld4504_RTRef = 0x0000008A THEN T12._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P3)) AND (T2._Fld4509RRef = @P4)) AND (T13._Fld5385RRef = @P5))) AND (T2._Fld4511 <> @P6 OR T2._Fld4512 <> @P7 OR T2._Fld4513 <> @P8 OR T2._Fld6624 <> @P9 OR T2._Fld7262 <> @P10 OR T2._Fld7263 <> @P11 OR T2._Fld9811 <> @P12 OR T2._Fld9857 <> @P13 OR T2._Fld10489 <> @P14 OR T2._Fld10490 <> @P15 OR T2._Fld10491 <> @P16)
GROUP BY T2._Fld4500RRef,
T2._Fld4504_TYPE,
T2._Fld4504_RTRef,
T2._Fld4504_RRRef,
T2._Fld4510
HAVING (CAST(SUM(T2._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T2._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T2._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T2._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T2._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T2._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T1
LEFT OUTER JOIN (SELECT
T15._Fld4500RRef AS Fld4500RRef,
T15._Fld4510 AS Fld4510_,
CAST(SUM(T15._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T15._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T15._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T15._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T15._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T15._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T15._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T15._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T15._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T15._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T15._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T15
LEFT OUTER JOIN dbo._Document72 T16
ON T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x00000048 AND T15._Fld4504_RRRef = T16._IDRRef
LEFT OUTER JOIN dbo._Reference35 T17
ON T16._Fld965RRef = T17._IDRRef
LEFT OUTER JOIN dbo._Document110 T18
ON T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006E AND T15._Fld4504_RRRef = T18._IDRRef
LEFT OUTER JOIN dbo._Reference35 T19
ON T18._Fld2024RRef = T19._IDRRef
LEFT OUTER JOIN dbo._Document111 T20
ON T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006F AND T15._Fld4504_RRRef = T20._IDRRef
LEFT OUTER JOIN dbo._Reference35 T21
ON T20._Fld2069RRef = T21._IDRRef
LEFT OUTER JOIN dbo._Document109 T22
ON T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006D AND T15._Fld4504_RRRef = T22._IDRRef
LEFT OUTER JOIN dbo._Reference35 T23
ON T22._Fld1975RRef = T23._IDRRef
LEFT OUTER JOIN dbo._Document138 T24
ON T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000008A AND T15._Fld4504_RRRef = T24._IDRRef
LEFT OUTER JOIN dbo._Reference35 T25
ON T24._Fld3029RRef = T25._IDRRef
LEFT OUTER JOIN dbo._Reference32 T26
ON T15._Fld4500RRef = T26._IDRRef
WHERE T15._Period >= @P17 AND T15._Period < @P18 AND ((((CASE WHEN T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x00000048 THEN T17._Fld6406RRef WHEN T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006E THEN T19._Fld6406RRef WHEN T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006F THEN T21._Fld6406RRef WHEN T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000006D THEN T23._Fld6406RRef WHEN T15._Fld4504_TYPE = 0x08 AND T15._Fld4504_RTRef = 0x0000008A THEN T25._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P19)) AND (T15._Fld4509RRef = @P20)) AND (T26._Fld5385RRef = @P21))) AND (T15._Fld4511 <> @P22 OR T15._Fld4512 <> @P23 OR T15._Fld4513 <> @P24 OR T15._Fld6624 <> @P25 OR T15._Fld7262 <> @P26 OR T15._Fld7263 <> @P27 OR T15._Fld9811 <> @P28 OR T15._Fld9857 <> @P29 OR T15._Fld10489 <> @P30 OR T15._Fld10490 <> @P31 OR T15._Fld10491 <> @P32)
GROUP BY T15._Fld4500RRef,
T15._Fld4510
HAVING (CAST(SUM(T15._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T15._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T15._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T15._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T15._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T15._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T14
ON ((T1.Fld4510_ = T14.Fld4510_) AND (T1.Fld4500RRef = T14.Fld4500RRef))
LEFT OUTER JOIN (SELECT
T28._Fld4510 AS Fld4510_,
CAST(SUM(T28._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T28._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T28._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T28._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T28._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T28._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T28._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T28._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T28._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T28._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T28._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T28
LEFT OUTER JOIN dbo._Document72 T29
ON T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x00000048 AND T28._Fld4504_RRRef = T29._IDRRef
LEFT OUTER JOIN dbo._Reference35 T30
ON T29._Fld965RRef = T30._IDRRef
LEFT OUTER JOIN dbo._Document110 T31
ON T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006E AND T28._Fld4504_RRRef = T31._IDRRef
LEFT OUTER JOIN dbo._Reference35 T32
ON T31._Fld2024RRef = T32._IDRRef
LEFT OUTER JOIN dbo._Document111 T33
ON T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006F AND T28._Fld4504_RRRef = T33._IDRRef
LEFT OUTER JOIN dbo._Reference35 T34
ON T33._Fld2069RRef = T34._IDRRef
LEFT OUTER JOIN dbo._Document109 T35
ON T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006D AND T28._Fld4504_RRRef = T35._IDRRef
LEFT OUTER JOIN dbo._Reference35 T36
ON T35._Fld1975RRef = T36._IDRRef
LEFT OUTER JOIN dbo._Document138 T37
ON T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000008A AND T28._Fld4504_RRRef = T37._IDRRef
LEFT OUTER JOIN dbo._Reference35 T38
ON T37._Fld3029RRef = T38._IDRRef
LEFT OUTER JOIN dbo._Reference32 T39
ON T28._Fld4500RRef = T39._IDRRef
WHERE T28._Period >= @P33 AND T28._Period < @P34 AND ((((CASE WHEN T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x00000048 THEN T30._Fld6406RRef WHEN T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006E THEN T32._Fld6406RRef WHEN T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006F THEN T34._Fld6406RRef WHEN T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000006D THEN T36._Fld6406RRef WHEN T28._Fld4504_TYPE = 0x08 AND T28._Fld4504_RTRef = 0x0000008A THEN T38._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P35)) AND (T28._Fld4509RRef = @P36)) AND (T39._Fld5385RRef = @P37))) AND (T28._Fld4511 <> @P38 OR T28._Fld4512 <> @P39 OR T28._Fld4513 <> @P40 OR T28._Fld6624 <> @P41 OR T28._Fld7262 <> @P42 OR T28._Fld7263 <> @P43 OR T28._Fld9811 <> @P44 OR T28._Fld9857 <> @P45 OR T28._Fld10489 <> @P46 OR T28._Fld10490 <> @P47 OR T28._Fld10491 <> @P48)
GROUP BY T28._Fld4510
HAVING (CAST(SUM(T28._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T28._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T28._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T28._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T28._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T28._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T27
ON (T1.Fld4510_ = T27.Fld4510_)
LEFT OUTER JOIN (SELECT
T41._Fld4510 AS Fld4510_,
CAST(SUM(T41._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T41._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T41._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T41._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T41._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T41._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T41._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T41._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T41._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T41._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T41._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T41
LEFT OUTER JOIN dbo._Document72 T42
ON T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x00000048 AND T41._Fld4504_RRRef = T42._IDRRef
LEFT OUTER JOIN dbo._Reference35 T43
ON T42._Fld965RRef = T43._IDRRef
LEFT OUTER JOIN dbo._Document110 T44
ON T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006E AND T41._Fld4504_RRRef = T44._IDRRef
LEFT OUTER JOIN dbo._Reference35 T45
ON T44._Fld2024RRef = T45._IDRRef
LEFT OUTER JOIN dbo._Document111 T46
ON T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006F AND T41._Fld4504_RRRef = T46._IDRRef
LEFT OUTER JOIN dbo._Reference35 T47
ON T46._Fld2069RRef = T47._IDRRef
LEFT OUTER JOIN dbo._Document109 T48
ON T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006D AND T41._Fld4504_RRRef = T48._IDRRef
LEFT OUTER JOIN dbo._Reference35 T49
ON T48._Fld1975RRef = T49._IDRRef
LEFT OUTER JOIN dbo._Document138 T50
ON T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000008A AND T41._Fld4504_RRRef = T50._IDRRef
LEFT OUTER JOIN dbo._Reference35 T51
ON T50._Fld3029RRef = T51._IDRRef
LEFT OUTER JOIN dbo._Reference32 T52
ON T41._Fld4500RRef = T52._IDRRef
WHERE T41._Period >= @P49 AND T41._Period < @P50 AND ((((CASE WHEN T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x00000048 THEN T43._Fld6406RRef WHEN T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006E THEN T45._Fld6406RRef WHEN T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006F THEN T47._Fld6406RRef WHEN T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000006D THEN T49._Fld6406RRef WHEN T41._Fld4504_TYPE = 0x08 AND T41._Fld4504_RTRef = 0x0000008A THEN T51._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P51)) AND (T41._Fld4509RRef = @P52)) AND (T52._Fld5385RRef = @P53))) AND (T41._Fld4511 <> @P54 OR T41._Fld4512 <> @P55 OR T41._Fld4513 <> @P56 OR T41._Fld6624 <> @P57 OR T41._Fld7262 <> @P58 OR T41._Fld7263 <> @P59 OR T41._Fld9811 <> @P60 OR T41._Fld9857 <> @P61 OR T41._Fld10489 <> @P62 OR T41._Fld10490 <> @P63 OR T41._Fld10491 <> @P64)
GROUP BY T41._Fld4510
HAVING (CAST(SUM(T41._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T41._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T41._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T41._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T41._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T41._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T40
ON (T1.Fld4510_ = T40.Fld4510_)
LEFT OUTER JOIN (SELECT
T54._Fld4510 AS Fld4510_,
CAST(SUM(T54._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T54._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T54._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T54._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T54._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T54._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T54._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T54._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T54._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T54._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T54._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T54
LEFT OUTER JOIN dbo._Document72 T55
ON T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x00000048 AND T54._Fld4504_RRRef = T55._IDRRef
LEFT OUTER JOIN dbo._Reference35 T56
ON T55._Fld965RRef = T56._IDRRef
LEFT OUTER JOIN dbo._Document110 T57
ON T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006E AND T54._Fld4504_RRRef = T57._IDRRef
LEFT OUTER JOIN dbo._Reference35 T58
ON T57._Fld2024RRef = T58._IDRRef
LEFT OUTER JOIN dbo._Document111 T59
ON T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006F AND T54._Fld4504_RRRef = T59._IDRRef
LEFT OUTER JOIN dbo._Reference35 T60
ON T59._Fld2069RRef = T60._IDRRef
LEFT OUTER JOIN dbo._Document109 T61
ON T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006D AND T54._Fld4504_RRRef = T61._IDRRef
LEFT OUTER JOIN dbo._Reference35 T62
ON T61._Fld1975RRef = T62._IDRRef
LEFT OUTER JOIN dbo._Document138 T63
ON T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000008A AND T54._Fld4504_RRRef = T63._IDRRef
LEFT OUTER JOIN dbo._Reference35 T64
ON T63._Fld3029RRef = T64._IDRRef
LEFT OUTER JOIN dbo._Reference32 T65
ON T54._Fld4500RRef = T65._IDRRef
WHERE T54._Period >= @P65 AND T54._Period < @P66 AND ((((CASE WHEN T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x00000048 THEN T56._Fld6406RRef WHEN T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006E THEN T58._Fld6406RRef WHEN T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006F THEN T60._Fld6406RRef WHEN T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000006D THEN T62._Fld6406RRef WHEN T54._Fld4504_TYPE = 0x08 AND T54._Fld4504_RTRef = 0x0000008A THEN T64._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P67)) AND (T54._Fld4509RRef = @P68)) AND (T65._Fld5385RRef = @P69))) AND (T54._Fld4511 <> @P70 OR T54._Fld4512 <> @P71 OR T54._Fld4513 <> @P72 OR T54._Fld6624 <> @P73 OR T54._Fld7262 <> @P74 OR T54._Fld7263 <> @P75 OR T54._Fld9811 <> @P76 OR T54._Fld9857 <> @P77 OR T54._Fld10489 <> @P78 OR T54._Fld10490 <> @P79 OR T54._Fld10491 <> @P80)
GROUP BY T54._Fld4510
HAVING (CAST(SUM(T54._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T54._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T54._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T54._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T54._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T54._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T53
ON (T1.Fld4510_ = T53.Fld4510_)
LEFT OUTER JOIN (SELECT
T67._Fld4510 AS Fld4510_,
CAST(SUM(T67._Fld4511) AS NUMERIC(32, 8)) AS Fld4511Turnover_,
CAST(SUM(T67._Fld4512) AS NUMERIC(33, 8)) AS Fld4512Turnover_,
CAST(SUM(T67._Fld4513) AS NUMERIC(33, 8)) AS Fld4513Turnover_,
CAST(SUM(T67._Fld6624) AS NUMERIC(28, 8)) AS Fld6624Turnover_,
CAST(SUM(T67._Fld7262) AS NUMERIC(33, 8)) AS Fld7262Turnover_,
CAST(SUM(T67._Fld7263) AS NUMERIC(33, 8)) AS Fld7263Turnover_,
CAST(SUM(T67._Fld9811) AS NUMERIC(28, 8)) AS Fld9811Turnover_,
CAST(SUM(T67._Fld9857) AS NUMERIC(28, 8)) AS Fld9857Turnover_,
CAST(SUM(T67._Fld10489) AS NUMERIC(33, 8)) AS Fld10489Turnover_,
CAST(SUM(T67._Fld10490) AS NUMERIC(33, 8)) AS Fld10490Turnover_,
CAST(SUM(T67._Fld10491) AS NUMERIC(33, 8)) AS Fld10491Turnover_
FROM dbo._AccumRgTn4516 T67
LEFT OUTER JOIN dbo._Document72 T68
ON T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x00000048 AND T67._Fld4504_RRRef = T68._IDRRef
LEFT OUTER JOIN dbo._Reference35 T69
ON T68._Fld965RRef = T69._IDRRef
LEFT OUTER JOIN dbo._Document110 T70
ON T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006E AND T67._Fld4504_RRRef = T70._IDRRef
LEFT OUTER JOIN dbo._Reference35 T71
ON T70._Fld2024RRef = T71._IDRRef
LEFT OUTER JOIN dbo._Document111 T72
ON T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006F AND T67._Fld4504_RRRef = T72._IDRRef
LEFT OUTER JOIN dbo._Reference35 T73
ON T72._Fld2069RRef = T73._IDRRef
LEFT OUTER JOIN dbo._Document109 T74
ON T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006D AND T67._Fld4504_RRRef = T74._IDRRef
LEFT OUTER JOIN dbo._Reference35 T75
ON T74._Fld1975RRef = T75._IDRRef
LEFT OUTER JOIN dbo._Document138 T76
ON T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000008A AND T67._Fld4504_RRRef = T76._IDRRef
LEFT OUTER JOIN dbo._Reference35 T77
ON T76._Fld3029RRef = T77._IDRRef
LEFT OUTER JOIN dbo._Reference32 T78
ON T67._Fld4500RRef = T78._IDRRef
WHERE T67._Period >= @P81 AND T67._Period < @P82 AND ((((CASE WHEN T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x00000048 THEN T69._Fld6406RRef WHEN T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006E THEN T71._Fld6406RRef WHEN T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006F THEN T73._Fld6406RRef WHEN T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000006D THEN T75._Fld6406RRef WHEN T67._Fld4504_TYPE = 0x08 AND T67._Fld4504_RTRef = 0x0000008A THEN T77._Fld6406RRef ELSE CAST(NULL AS BINARY(16)) END IN (@P83)) AND (T67._Fld4509RRef = @P84)) AND (T78._Fld5385RRef = @P85))) AND (T67._Fld4511 <> @P86 OR T67._Fld4512 <> @P87 OR T67._Fld4513 <> @P88 OR T67._Fld6624 <> @P89 OR T67._Fld7262 <> @P90 OR T67._Fld7263 <> @P91 OR T67._Fld9811 <> @P92 OR T67._Fld9857 <> @P93 OR T67._Fld10489 <> @P94 OR T67._Fld10490 <> @P95 OR T67._Fld10491 <> @P96)
GROUP BY T67._Fld4510
HAVING (CAST(SUM(T67._Fld4511) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T67._Fld4512) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld4513) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld6624) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T67._Fld7262) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld7263) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld9811) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T67._Fld9857) AS NUMERIC(28, 8))) <> 0.0 OR (CAST(SUM(T67._Fld10489) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld10490) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T67._Fld10491) AS NUMERIC(33, 8))) <> 0.0) T66
ON (T1.Fld4510_ = T66.Fld4510_)
LEFT OUTER JOIN dbo._Document72 T79
ON T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x00000048 AND T1.Fld4504_RRRef = T79._IDRRef
LEFT OUTER JOIN dbo._Reference35 T80
ON T79._Fld965RRef = T80._IDRRef
LEFT OUTER JOIN dbo._Document110 T81
ON T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006E AND T1.Fld4504_RRRef = T81._IDRRef
LEFT OUTER JOIN dbo._Reference35 T82
ON T81._Fld2024RRef = T82._IDRRef
LEFT OUTER JOIN dbo._Document111 T83
ON T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006F AND T1.Fld4504_RRRef = T83._IDRRef
LEFT OUTER JOIN dbo._Reference35 T84
ON T83._Fld2069RRef = T84._IDRRef
LEFT OUTER JOIN dbo._Document109 T85
ON T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000006D AND T1.Fld4504_RRRef = T85._IDRRef
LEFT OUTER JOIN dbo._Reference35 T86
ON T85._Fld1975RRef = T86._IDRRef
LEFT OUTER JOIN dbo._Document138 T87
ON T1.Fld4504_TYPE = 0x08 AND T1.Fld4504_RTRef = 0x0000008A AND T1.Fld4504_RRRef = T87._IDRRef
LEFT OUTER JOIN dbo._Reference35 T88
ON T87._Fld3029RRef = T88._IDRRef
WHERE (NOT (((T1.Fld4510_ = @P97)))) AND (NOT ((T14.Fld4510_ IS NULL))) AND ((((NOT ((T27.Fld4510_ IS NULL))) OR (NOT ((T40.Fld4510_ IS NULL)))) OR (NOT ((T53.Fld4510_ IS NULL)))) OR (NOT ((T66.Fld4510_ IS NULL))))
--?>