(@P1 varbinary(16),@P2 numeric(10),@P3 numeric(10),@P4 varbinary(16),@P5 datetime2(3),@P6 numeric(10),@P7 numeric(10),@P8 numeric(10),@P9 numeric(10),@P10 numeric(10),@P11 numeric(10),@P12 varbinary(16),@P13 datetime2(3),@P14 numeric(10),@P15 numeric(10),@P16 numeric(10),@P17 numeric(10),@P18 varbinary(16),@P19 varbinary(16),@P20 numeric(10),@P21 numeric(10),@P22 numeric(10),@P23 numeric(10),@P24 numeric(10),@P25 numeric(10),@P26 datetime2(3),@P27 datetime2(3),@P28 numeric(10),@P29 numeric(10),@P30 numeric(10),@P31 numeric(10),@P32 datetime2(3),@P33 datetime2(3),@P34 numeric(10),@P35 numeric(10),@P36 varbinary(16),@P37 varbinary(16),@P38 varbinary(16),@P39 varbinary(16),@P40 varbinary(16),@P41 datetime2(3),@P42 datetime2(3),@P43 varbinary(16),@P44 varbinary(16),@P45 numeric(10),@P46 numeric(10),@P47 numeric(10),@P48 numeric(10),@P49 numeric(10),@P50 numeric(10),@P51 datetime2(3),@P52 datetime2(3),@P53 numeric(10),@P54 numeric(10),@P55 numeric(10),@P56 numeric(10),@P57 datetime2(3),@P58 datetime2(3),@P59 numeric(10),@P60 numeric(10),@P61 varbinary(16),@P62 varbinary(16),@P63 varbinary(16),@P64 varbinary(16),@P65 varbinary(16),@P66 datetime2(3),@P67 datetime2(3),@P68 numeric(10),@P69 datetime2(3),@P70 varbinary(16),@P71 numeric(10),@P72 numeric(10),@P73 datetime2(3),@P74 varbinary(16),@P75 numeric(10),@P76 numeric(10),@P77 numeric(10),@P78 numeric(10),@P79 numeric(10),@P80 numeric(10),@P81 numeric(10),@P82 numeric(10),@P83 numeric(10),@P84 numeric(10),@P85 numeric(10),@P86 numeric(10),@P87 numeric(10),@P88 numeric(10),@P89 numeric(10),@P90 numeric(10),@P91 numeric(10),@P92 numeric(10),@P93 numeric(10),@P94 numeric(10),@P95 numeric(10),@P96 numeric(10),@P97 numeric(10),@P98 numeric(10),@P99 numeric(10),@P100 numeric(10),@P101 numeric(10),@P102 numeric(10),@P103 numeric(10),@P104 numeric(10),@P105 numeric(10))SELECT T1.AccountRRef, CASE WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000048 THEN T27._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000000B THEN T28._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000039 THEN T29._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002D THEN T30._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000017 THEN T31._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000018 THEN T32._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000022 THEN T33._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000001B THEN T34._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000041 THEN T35._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000027 THEN T36._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000000A THEN T37._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000003E THEN T38._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00001FBF THEN T39._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002F THEN T40._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000033 THEN T41._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000053 THEN T42._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002A THEN T43._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000025 THEN T44._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000042 THEN T45._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000005A THEN T46._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000052 THEN T47._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000028 THEN T48._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000034 THEN T49._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000043 THEN T50._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002E THEN T51._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000045 THEN T52._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000051 THEN T53._Description WHEN T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000059 THEN T54._Description ELSE CAST(NULL AS NVARCHAR(150)) END, T1.Value2_TYPE, T1.Value2_RTRef, T1.Value2_RRRef, T1.Fld7827InitialBalance_, T1.Fld7827Turnover_, T1.Fld7827FinalBalance_, T19.Fld7073_, T23.Fld7073_, T55._Description, T56._Description FROM (SELECT T2.Value3_TYPE AS Value3_TYPE, T2.Value3_RTRef AS Value3_RTRef, T2.Value3_RRRef AS Value3_RRRef, T2.AccountRRef AS AccountRRef, T2.Value2_TYPE AS Value2_TYPE, T2.Value2_RTRef AS Value2_RTRef, T2.Value2_RRRef AS Value2_RRRef, CASE WHEN CAST(SUM(T2.Fld7827Turnover_) AS NUMERIC(28, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Turnover_) AS NUMERIC(28, 2)) END AS Fld7827Turnover_, CASE WHEN CAST(SUM(T2.Fld7827Balance_) AS NUMERIC(27, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Balance_) AS NUMERIC(27, 2)) END AS Fld7827InitialBalance_, CASE WHEN CAST(SUM(T2.Fld7827Balance_ + T2.Fld7827FinalTurnover_) AS NUMERIC(28, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Balance_ + T2.Fld7827FinalTurnover_) AS NUMERIC(28, 2)) END AS Fld7827FinalBalance_ FROM (SELECT CASE WHEN CAST(NULL AS BINARY(1)) IN (0x01) THEN CAST(NULL AS BINARY(1)) END AS Value3_TYPE, CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN 0x00000000 END AS Value3_RTRef, CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P1 END AS Value3_RRRef, T3._AccountRRef AS AccountRRef, T3._Value2_TYPE AS Value2_TYPE, T3._Value2_RTRef AS Value2_RTRef, T3._Value2_RRRef AS Value2_RRRef, T3._Fld7827 AS Fld7827Balance_, T3._Turnover7839 AS Fld7827FinalTurnover_, T3._TurnoverDt7837 - T3._TurnoverCt7838 AS Fld7827Turnover_ FROM dbo._AccRgAT27856 T3 INNER JOIN #tt20 T4 WITH(NOLOCK) ON T4._IDRRef = T3._AccountRRef AND T4._Cnt = @P2 WHERE ((T3._Fld11355 = @P3)) AND (((T3._Fld7824RRef = @P4)) AND T3._Period = @P5 AND (T3._Fld7827 <> @P6 OR T3._TurnoverDt7837 <> @P7 OR T3._TurnoverCt7838 <> @P8 OR T3._Turnover7839 <> @P9)) UNION ALL SELECT T5._Value3_TYPE AS Value3_TYPE, T5._Value3_RTRef AS Value3_RTRef, T5._Value3_RRRef AS Value3_RRRef, T5._AccountRRef AS AccountRRef, T5._Value2_TYPE AS Value2_TYPE, T5._Value2_RTRef AS Value2_RTRef, T5._Value2_RRRef AS Value2_RRRef, T5._Fld7827 AS Fld7827Balance_, T5._Turnover7839 AS Fld7827FinalTurnover_, T5._TurnoverDt7837 - T5._TurnoverCt7838 AS Fld7827Turnover_ FROM dbo._AccRgAT37857 T5 INNER JOIN #tt20 T6 WITH(NOLOCK) ON T6._IDRRef = T5._AccountRRef AND T6._Cnt = @P10 WHERE ((T5._Fld11355 = @P11)) AND (((T5._Fld7824RRef = @P12)) AND T5._Period = @P13 AND (T5._Fld7827 <> @P14 OR T5._TurnoverDt7837 <> @P15 OR T5._TurnoverCt7838 <> @P16 OR T5._Turnover7839 <> @P17)) UNION ALL SELECT CASE WHEN T8._ED3 = 0x01 THEN T12._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value3_TYPE, CASE WHEN T8._ED3 = 0x01 THEN T12._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN 0x00000000 END END AS Value3_RTRef, CASE WHEN T8._ED3 = 0x01 THEN T12._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P18 END END AS Value3_RRRef, T7._AccountDtRRef AS AccountRRef, CASE WHEN T8._ED2 = 0x01 THEN T10._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value2_TYPE, CASE WHEN T8._ED2 = 0x01 THEN T10._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN 0x00000000 END END AS Value2_RTRef, CASE WHEN T8._ED2 = 0x01 THEN T10._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P19 END END AS Value2_RRRef, CAST(@P20 AS NUMERIC(21, 2)) AS Fld7827Balance_, CAST(CASE WHEN T8._BRF1 = 0x01 THEN T7._Fld7827 ELSE @P21 END AS NUMERIC(21, 2)) AS Fld7827FinalTurnover_, CAST(CASE WHEN T8._RF1 = 0x01 THEN T7._Fld7827 ELSE @P22 END AS NUMERIC(22, 2)) AS Fld7827Turnover_ FROM dbo._AccRg7823 T7 INNER JOIN #tt19 T8 WITH(NOLOCK) ON T8._IDRRef = T7._AccountDtRRef LEFT OUTER JOIN dbo._Acc7_ExtDim7816 T9 ON (T9._Acc7_IDRRef = T7._AccountDtRRef AND T9._LineNo = @P23) AND (T9._Fld11355 = @P24) LEFT OUTER JOIN dbo._AccRgED7859 T10 ON (T10._RecorderTRef = T7._RecorderTRef AND T10._RecorderRRef = T7._RecorderRRef AND T10._LineNo = T7._LineNo AND T10._Period = T7._Period AND T10._Correspond = @P25 AND T10._KindRRef = T9._DimKindRRef AND T10._Period >= @P26 AND T10._Period <= @P27) AND (T10._Fld11355 = @P28) LEFT OUTER JOIN dbo._Acc7_ExtDim7816 T11 ON (T11._Acc7_IDRRef = T7._AccountDtRRef AND T11._LineNo = @P29) AND (T11._Fld11355 = @P30) LEFT OUTER JOIN dbo._AccRgED7859 T12 ON (T12._RecorderTRef = T7._RecorderTRef AND T12._RecorderRRef = T7._RecorderRRef AND T12._LineNo = T7._LineNo AND T12._Period = T7._Period AND T12._Correspond = @P31 AND T12._KindRRef = T11._DimKindRRef AND T12._Period >= @P32 AND T12._Period <= @P33) AND (T12._Fld11355 = @P34) WHERE ((T7._Fld11355 = @P35)) AND (T7._Active = 0x01 AND T7._AccountDtRRef <> @P36 AND (((T7._AccountDtRRef IN (@P37, @P38, @P39)))) AND ((T7._Fld7824RRef = @P40)) AND T7._Period >= @P41 AND T7._Period <= @P42) UNION ALL SELECT CASE WHEN T14._ED3 = 0x01 THEN T18._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value3_TYPE, CASE WHEN T14._ED3 = 0x01 THEN T18._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN 0x00000000 END END AS Value3_RTRef, CASE WHEN T14._ED3 = 0x01 THEN T18._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P43 END END AS Value3_RRRef, T13._AccountCtRRef AS AccountRRef, CASE WHEN T14._ED2 = 0x01 THEN T16._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value2_TYPE, CASE WHEN T14._ED2 = 0x01 THEN T16._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN 0x00000000 END END AS Value2_RTRef, CASE WHEN T14._ED2 = 0x01 THEN T16._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P44 END END AS Value2_RRRef, CAST(@P45 AS NUMERIC(21, 2)) AS Fld7827Balance_, CAST(CASE WHEN T14._BRF1 = 0x01 THEN -T13._Fld7827 ELSE @P46 END AS NUMERIC(21, 2)) AS Fld7827FinalTurnover_, CAST(CASE WHEN T14._RF1 = 0x01 THEN -T13._Fld7827 ELSE @P47 END AS NUMERIC(22, 2)) AS Fld7827Turnover_ FROM dbo._AccRg7823 T13 INNER JOIN #tt19 T14 WITH(NOLOCK) ON T14._IDRRef = T13._AccountCtRRef LEFT OUTER JOIN dbo._Acc7_ExtDim7816 T15 ON (T15._Acc7_IDRRef = T13._AccountCtRRef AND T15._LineNo = @P48) AND (T15._Fld11355 = @P49) LEFT OUTER JOIN dbo._AccRgED7859 T16 ON (T16._RecorderTRef = T13._RecorderTRef AND T16._RecorderRRef = T13._RecorderRRef AND T16._LineNo = T13._LineNo AND T16._Period = T13._Period AND T16._Correspond = @P50 AND T16._KindRRef = T15._DimKindRRef AND T16._Period >= @P51 AND T16._Period <= @P52) AND (T16._Fld11355 = @P53) LEFT OUTER JOIN dbo._Acc7_ExtDim7816 T17 ON (T17._Acc7_IDRRef = T13._AccountCtRRef AND T17._LineNo = @P54) AND (T17._Fld11355 = @P55) LEFT OUTER JOIN dbo._AccRgED7859 T18 ON (T18._RecorderTRef = T13._RecorderTRef AND T18._RecorderRRef = T13._RecorderRRef AND T18._LineNo = T13._LineNo AND T18._Period = T13._Period AND T18._Correspond = @P56 AND T18._KindRRef = T17._DimKindRRef AND T18._Period >= @P57 AND T18._Period <= @P58) AND (T18._Fld11355 = @P59) WHERE ((T13._Fld11355 = @P60)) AND (T13._Active = 0x01 AND T13._AccountCtRRef <> @P61 AND (((T13._AccountCtRRef IN (@P62, @P63, @P64)))) AND ((T13._Fld7824RRef = @P65)) AND T13._Period >= @P66 AND T13._Period <= @P67)) T2 GROUP BY T2.Value3_TYPE, T2.Value3_RTRef, T2.Value3_RRRef, T2.AccountRRef, T2.Value2_TYPE, T2.Value2_RTRef, T2.Value2_RRRef HAVING (CASE WHEN CAST(SUM(T2.Fld7827Turnover_) AS NUMERIC(28, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Turnover_) AS NUMERIC(28, 2)) END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld7827Balance_) AS NUMERIC(27, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Balance_) AS NUMERIC(27, 2)) END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld7827Balance_ + T2.Fld7827FinalTurnover_) AS NUMERIC(28, 2)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld7827Balance_ + T2.Fld7827FinalTurnover_) AS NUMERIC(28, 2)) END) <> 0.0) T1 LEFT OUTER JOIN (SELECT T22._Fld7071RRef AS Fld7071RRef, T22._Fld7073 AS Fld7073_, T22._Fld7072RRef AS Fld7072RRef FROM (SELECT T21._Fld7070RRef AS Fld7070RRef, T21._Fld7071RRef AS Fld7071RRef, MAX(T21._Period) AS MAXPERIOD_ FROM dbo._InfoRg7069 T21 WHERE ((T21._Fld11355 = @P68)) AND (T21._Period <= @P69 AND T21._Active = 0x01 AND ((T21._Fld7070RRef = @P70))) GROUP BY T21._Fld7070RRef, T21._Fld7071RRef) T20 INNER JOIN dbo._InfoRg7069 T22 ON T20.Fld7070RRef = T22._Fld7070RRef AND T20.Fld7071RRef = T22._Fld7071RRef AND T20.MAXPERIOD_ = T22._Period WHERE (T22._Fld11355 = @P71)) T19 ON (T1.Value3_TYPE = CASE WHEN T19.Fld7071RRef IS NOT NULL THEN 0x08 END AND T1.Value3_RTRef = CASE WHEN T19.Fld7071RRef IS NOT NULL THEN 0x0000002E END AND T1.Value3_RRRef = T19.Fld7071RRef) LEFT OUTER JOIN (SELECT T26._Fld7071RRef AS Fld7071RRef, T26._Fld7073 AS Fld7073_, T26._Fld7072RRef AS Fld7072RRef FROM (SELECT T25._Fld7070RRef AS Fld7070RRef, T25._Fld7071RRef AS Fld7071RRef, MAX(T25._Period) AS MAXPERIOD_ FROM dbo._InfoRg7069 T25 WHERE ((T25._Fld11355 = @P72)) AND (T25._Period <= @P73 AND T25._Active = 0x01 AND ((T25._Fld7070RRef = @P74))) GROUP BY T25._Fld7070RRef, T25._Fld7071RRef) T24 INNER JOIN dbo._InfoRg7069 T26 ON T24.Fld7070RRef = T26._Fld7070RRef AND T24.Fld7071RRef = T26._Fld7071RRef AND T24.MAXPERIOD_ = T26._Period WHERE (T26._Fld11355 = @P75)) T23 ON (T1.Value3_TYPE = CASE WHEN T23.Fld7071RRef IS NOT NULL THEN 0x08 END AND T1.Value3_RTRef = CASE WHEN T23.Fld7071RRef IS NOT NULL THEN 0x0000002E END AND T1.Value3_RRRef = T23.Fld7071RRef) LEFT OUTER JOIN dbo._Reference72 T27 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000048 AND T1.Value3_RRRef = T27._IDRRef) AND (T27._Fld11355 = @P76) LEFT OUTER JOIN dbo._Reference11 T28 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000000B AND T1.Value3_RRRef = T28._IDRRef) AND (T28._Fld11355 = @P77) LEFT OUTER JOIN dbo._Reference57 T29 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000039 AND T1.Value3_RRRef = T29._IDRRef) AND (T29._Fld11355 = @P78) LEFT OUTER JOIN dbo._Reference45 T30 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002D AND T1.Value3_RRRef = T30._IDRRef) AND (T30._Fld11355 = @P79) LEFT OUTER JOIN dbo._Reference23 T31 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000017 AND T1.Value3_RRRef = T31._IDRRef) AND (T31._Fld11355 = @P80) LEFT OUTER JOIN dbo._Reference24 T32 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000018 AND T1.Value3_RRRef = T32._IDRRef) AND (T32._Fld11355 = @P81) LEFT OUTER JOIN dbo._Reference34 T33 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000022 AND T1.Value3_RRRef = T33._IDRRef) AND (T33._Fld11355 = @P82) LEFT OUTER JOIN dbo._Reference27 T34 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000001B AND T1.Value3_RRRef = T34._IDRRef) AND (T34._Fld11355 = @P83) LEFT OUTER JOIN dbo._Reference65 T35 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000041 AND T1.Value3_RRRef = T35._IDRRef) AND (T35._Fld11355 = @P84) LEFT OUTER JOIN dbo._Reference39 T36 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000027 AND T1.Value3_RRRef = T36._IDRRef) AND (T36._Fld11355 = @P85) LEFT OUTER JOIN dbo._Reference10 T37 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000000A AND T1.Value3_RRRef = T37._IDRRef) AND (T37._Fld11355 = @P86) LEFT OUTER JOIN dbo._Reference62 T38 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000003E AND T1.Value3_RRRef = T38._IDRRef) AND (T38._Fld11355 = @P87) LEFT OUTER JOIN dbo._Reference8127 T39 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00001FBF AND T1.Value3_RRRef = T39._IDRRef) AND (T39._Fld11355 = @P88) LEFT OUTER JOIN dbo._Reference47 T40 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002F AND T1.Value3_RRRef = T40._IDRRef) AND (T40._Fld11355 = @P89) LEFT OUTER JOIN dbo._Reference51 T41 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000033 AND T1.Value3_RRRef = T41._IDRRef) AND (T41._Fld11355 = @P90) LEFT OUTER JOIN dbo._Reference83 T42 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000053 AND T1.Value3_RRRef = T42._IDRRef) AND (T42._Fld11355 = @P91) LEFT OUTER JOIN dbo._Reference42 T43 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002A AND T1.Value3_RRRef = T43._IDRRef) AND (T43._Fld11355 = @P92) LEFT OUTER JOIN dbo._Reference37 T44 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000025 AND T1.Value3_RRRef = T44._IDRRef) AND (T44._Fld11355 = @P93) LEFT OUTER JOIN dbo._Reference66 T45 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000042 AND T1.Value3_RRRef = T45._IDRRef) AND (T45._Fld11355 = @P94) LEFT OUTER JOIN dbo._Reference90 T46 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000005A AND T1.Value3_RRRef = T46._IDRRef) AND (T46._Fld11355 = @P95) LEFT OUTER JOIN dbo._Reference82 T47 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000052 AND T1.Value3_RRRef = T47._IDRRef) AND (T47._Fld11355 = @P96) LEFT OUTER JOIN dbo._Reference40 T48 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000028 AND T1.Value3_RRRef = T48._IDRRef) AND (T48._Fld11355 = @P97) LEFT OUTER JOIN dbo._Reference52 T49 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000034 AND T1.Value3_RRRef = T49._IDRRef) AND (T49._Fld11355 = @P98) LEFT OUTER JOIN dbo._Reference67 T50 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000043 AND T1.Value3_RRRef = T50._IDRRef) AND (T50._Fld11355 = @P99) LEFT OUTER JOIN dbo._Reference46 T51 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x0000002E AND T1.Value3_RRRef = T51._IDRRef) AND (T51._Fld11355 = @P100) LEFT OUTER JOIN dbo._Reference69 T52 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000045 AND T1.Value3_RRRef = T52._IDRRef) AND (T52._Fld11355 = @P101) LEFT OUTER JOIN dbo._Reference81 T53 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000051 AND T1.Value3_RRRef = T53._IDRRef) AND (T53._Fld11355 = @P102) LEFT OUTER JOIN dbo._Reference89 T54 ON (T1.Value3_TYPE = 0x08 AND T1.Value3_RTRef = 0x00000059 AND T1.Value3_RRRef = T54._IDRRef) AND (T54._Fld11355 = @P103) LEFT OUTER JOIN dbo._Reference12 T55 ON (T19.Fld7072RRef = T55._IDRRef) AND (T55._Fld11355 = @P104) LEFT OUTER JOIN dbo._Reference12 T56 ON (T23.Fld7072RRef = T56._IDRRef) AND (T56._Fld11355 = @P105)