Top 4 Query

40.938=TotalDurationSec,3.411=AvgDurationSec,12=Execs,,4,Sql="SELECT TOP 25
T1._IDRRef,
T1._Description,
T1._Code,
T1._Fld1033,
T1._Fld1038RRef,
T1._Fld1028RRef,
T58._Fld885,
T59._Fld885,
T2.Q_001_F_001_,
T12.Q_001_F_001_,
T22.Q_001_F_001_,
T32.Q_001_F_001_,
T42.Q_001_F_001_,
T52.Q_001_F_001_,
T54.Q_001_F_001_,
T56.Q_001_F_001_,
T1._Marked,
T1._ParentIDRRef,
CASE WHEN (T1._Folder = 0x00) THEN 0x01 ELSE 0x00 END,
CASE WHEN T1._PredefinedID > 0x00000000000000000000000000000000 THEN 0x01 ELSE 0x00 END,
T1._Fld1040RRef,
T1._Fld12739RRef
FROM dbo._Reference42 T1
LEFT OUTER JOIN (SELECT
T3._Reference42_IDRRef AS Q_001_F_000RRef,
T3._Fld1050 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference42_VT1046 T3
INNER JOIN dbo._Reference42 T4
ON T3._Reference42_IDRRef = T4._IDRRef AND T3._Fld595 = T4._Fld595
WHERE (((T3._Fld595 = ?)) AND (((T4._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T5
INNER JOIN dbo._Reference21 T6
ON (((T5._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T7
WHERE ((T7._Fld595 = ?)) AND ((T7._Fld12065RRef = T5._IDRRef) AND (T7._Fld12066RRef = T6._IDRRef)))) AND T6._IDRRef IN
(SELECT
T8._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T8
INNER JOIN dbo._InfoRg9937 T9
ON ((T9._Fld9939_TYPE = 0x08 AND T9._Fld9939_RTRef = 0x00000095 AND T9._Fld9939_RRRef = ?) AND (T9._Fld9938_TYPE = T8._Fld784_TYPE AND T9._Fld9938_RTRef = T8._Fld784_RTRef AND T9._Fld9938_RRRef = T8._Fld784_RRRef))
WHERE ((T8._Fld595 = ?)) AND (T9._Fld595 = ?)))
WHERE ((T6._Fld595 = ?)) AND ((CASE WHEN T4._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T4._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T10
WHERE ((T10._Fld595 = ?)) AND ((T10._Fld12072RRef = T6._IDRRef) AND (T10._Fld12073_TYPE = CASE WHEN T4._Fld12836RRef IS NOT NULL THEN 0x08 END AND T10._Fld12073_RTRef = CASE WHEN T4._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T10._Fld12073_RRRef = T4._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T11
WHERE ((T11._Fld595 = ?)) AND ((T11._Fld12199RRef = T6._IDRRef) AND T11._Fld12200_TYPE = CASE WHEN T4._Fld12836RRef IS NOT NULL THEN 0x08 END AND T11._Fld12200_RTRef = CASE WHEN T4._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T11._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T3._Fld1049RRef = ?))) T2
ON (T1._IDRRef = T2.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T13._Reference42_IDRRef AS Q_001_F_000RRef,
T13._Fld1050 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference42_VT1046 T13
INNER JOIN dbo._Reference42 T14
ON T13._Reference42_IDRRef = T14._IDRRef AND T13._Fld595 = T14._Fld595
WHERE (((T13._Fld595 = ?)) AND (((T14._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T15
INNER JOIN dbo._Reference21 T16
ON (((T15._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T17
WHERE ((T17._Fld595 = ?)) AND ((T17._Fld12065RRef = T15._IDRRef) AND (T17._Fld12066RRef = T16._IDRRef)))) AND T16._IDRRef IN
(SELECT
T18._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T18
INNER JOIN dbo._InfoRg9937 T19
ON ((T19._Fld9939_TYPE = 0x08 AND T19._Fld9939_RTRef = 0x00000095 AND T19._Fld9939_RRRef = ?) AND (T19._Fld9938_TYPE = T18._Fld784_TYPE AND T19._Fld9938_RTRef = T18._Fld784_RTRef AND T19._Fld9938_RRRef = T18._Fld784_RRRef))
WHERE ((T18._Fld595 = ?)) AND (T19._Fld595 = ?)))
WHERE ((T16._Fld595 = ?)) AND ((CASE WHEN T14._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T14._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T20
WHERE ((T20._Fld595 = ?)) AND ((T20._Fld12072RRef = T16._IDRRef) AND (T20._Fld12073_TYPE = CASE WHEN T14._Fld12836RRef IS NOT NULL THEN 0x08 END AND T20._Fld12073_RTRef = CASE WHEN T14._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T20._Fld12073_RRRef = T14._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T21
WHERE ((T21._Fld595 = ?)) AND ((T21._Fld12199RRef = T16._IDRRef) AND T21._Fld12200_TYPE = CASE WHEN T14._Fld12836RRef IS NOT NULL THEN 0x08 END AND T21._Fld12200_RTRef = CASE WHEN T14._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T21._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T13._Fld1049RRef = ?))) T12
ON (T1._IDRRef = T12.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T23._Reference42_IDRRef AS Q_001_F_000RRef,
T23._Fld1050 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference42_VT1046 T23
INNER JOIN dbo._Reference42 T24
ON T23._Reference42_IDRRef = T24._IDRRef AND T23._Fld595 = T24._Fld595
WHERE (((T23._Fld595 = ?)) AND (((T24._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T25
INNER JOIN dbo._Reference21 T26
ON (((T25._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T27
WHERE ((T27._Fld595 = ?)) AND ((T27._Fld12065RRef = T25._IDRRef) AND (T27._Fld12066RRef = T26._IDRRef)))) AND T26._IDRRef IN
(SELECT
T28._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T28
INNER JOIN dbo._InfoRg9937 T29
ON ((T29._Fld9939_TYPE = 0x08 AND T29._Fld9939_RTRef = 0x00000095 AND T29._Fld9939_RRRef = ?) AND (T29._Fld9938_TYPE = T28._Fld784_TYPE AND T29._Fld9938_RTRef = T28._Fld784_RTRef AND T29._Fld9938_RRRef = T28._Fld784_RRRef))
WHERE ((T28._Fld595 = ?)) AND (T29._Fld595 = ?)))
WHERE ((T26._Fld595 = ?)) AND ((CASE WHEN T24._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T24._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T30
WHERE ((T30._Fld595 = ?)) AND ((T30._Fld12072RRef = T26._IDRRef) AND (T30._Fld12073_TYPE = CASE WHEN T24._Fld12836RRef IS NOT NULL THEN 0x08 END AND T30._Fld12073_RTRef = CASE WHEN T24._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T30._Fld12073_RRRef = T24._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T31
WHERE ((T31._Fld595 = ?)) AND ((T31._Fld12199RRef = T26._IDRRef) AND T31._Fld12200_TYPE = CASE WHEN T24._Fld12836RRef IS NOT NULL THEN 0x08 END AND T31._Fld12200_RTRef = CASE WHEN T24._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T31._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T23._Fld1049RRef = ?))) T22
ON (T1._IDRRef = T22.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T33._Reference42_IDRRef AS Q_001_F_000RRef,
T33._Fld1050 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference42_VT1046 T33
INNER JOIN dbo._Reference42 T34
ON T33._Reference42_IDRRef = T34._IDRRef AND T33._Fld595 = T34._Fld595
WHERE (((T33._Fld595 = ?)) AND (((T34._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T35
INNER JOIN dbo._Reference21 T36
ON (((T35._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T37
WHERE ((T37._Fld595 = ?)) AND ((T37._Fld12065RRef = T35._IDRRef) AND (T37._Fld12066RRef = T36._IDRRef)))) AND T36._IDRRef IN
(SELECT
T38._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T38
INNER JOIN dbo._InfoRg9937 T39
ON ((T39._Fld9939_TYPE = 0x08 AND T39._Fld9939_RTRef = 0x00000095 AND T39._Fld9939_RRRef = ?) AND (T39._Fld9938_TYPE = T38._Fld784_TYPE AND T39._Fld9938_RTRef = T38._Fld784_RTRef AND T39._Fld9938_RRRef = T38._Fld784_RRRef))
WHERE ((T38._Fld595 = ?)) AND (T39._Fld595 = ?)))
WHERE ((T36._Fld595 = ?)) AND ((CASE WHEN T34._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T34._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T40
WHERE ((T40._Fld595 = ?)) AND ((T40._Fld12072RRef = T36._IDRRef) AND (T40._Fld12073_TYPE = CASE WHEN T34._Fld12836RRef IS NOT NULL THEN 0x08 END AND T40._Fld12073_RTRef = CASE WHEN T34._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T40._Fld12073_RRRef = T34._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T41
WHERE ((T41._Fld595 = ?)) AND ((T41._Fld12199RRef = T36._IDRRef) AND T41._Fld12200_TYPE = CASE WHEN T34._Fld12836RRef IS NOT NULL THEN 0x08 END AND T41._Fld12200_RTRef = CASE WHEN T34._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T41._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T33._Fld1049RRef = ?))) T32
ON (T1._IDRRef = T32.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T43._Reference42_IDRRef AS Q_001_F_000RRef,
T43._Fld1050 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference42_VT1046 T43
INNER JOIN dbo._Reference42 T44
ON T43._Reference42_IDRRef = T44._IDRRef AND T43._Fld595 = T44._Fld595
WHERE (((T43._Fld595 = ?)) AND (((T44._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T45
INNER JOIN dbo._Reference21 T46
ON (((T45._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T47
WHERE ((T47._Fld595 = ?)) AND ((T47._Fld12065RRef = T45._IDRRef) AND (T47._Fld12066RRef = T46._IDRRef)))) AND T46._IDRRef IN
(SELECT
T48._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T48
INNER JOIN dbo._InfoRg9937 T49
ON ((T49._Fld9939_TYPE = 0x08 AND T49._Fld9939_RTRef = 0x00000095 AND T49._Fld9939_RRRef = ?) AND (T49._Fld9938_TYPE = T48._Fld784_TYPE AND T49._Fld9938_RTRef = T48._Fld784_RTRef AND T49._Fld9938_RRRef = T48._Fld784_RRRef))
WHERE ((T48._Fld595 = ?)) AND (T49._Fld595 = ?)))
WHERE ((T46._Fld595 = ?)) AND ((CASE WHEN T44._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T50
WHERE ((T50._Fld595 = ?)) AND ((T50._Fld12072RRef = T46._IDRRef) AND (T50._Fld12073_TYPE = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END AND T50._Fld12073_RTRef = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T50._Fld12073_RRRef = T44._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T51
WHERE ((T51._Fld595 = ?)) AND ((T51._Fld12199RRef = T46._IDRRef) AND T51._Fld12200_TYPE = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END AND T51._Fld12200_RTRef = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T51._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T43._Fld1049RRef = ?))) T42
ON (T1._IDRRef = T42.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T53._Reference47_IDRRef AS Q_001_F_000RRef,
T53._Fld1155 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference47_VT1151 T53
WHERE ((T53._Fld595 = ?)) AND ((T53._Fld1154RRef = ?))) T52
ON (T1._Fld1028RRef = T52.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T55._Reference47_IDRRef AS Q_001_F_000RRef,
T55._Fld1155 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference47_VT1151 T55
WHERE ((T55._Fld595 = ?)) AND ((T55._Fld1154RRef = ?))) T54
ON (T1._Fld1028RRef = T54.Q_001_F_000RRef)
LEFT OUTER JOIN (SELECT
T57._Reference47_IDRRef AS Q_001_F_000RRef,
T57._Fld1155 COLLATE Latin1_General_CI_AS AS Q_001_F_001_
FROM dbo._Reference47_VT1151 T57
WHERE ((T57._Fld595 = ?)) AND ((T57._Fld1154RRef = ?))) T56
ON (T1._Fld1028RRef = T56.Q_001_F_000RRef)
LEFT OUTER JOIN dbo._Reference24 T58
ON (T1._Fld1037RRef = T58._IDRRef) AND (T58._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference24 T59
ON (T1._Fld1032RRef = T59._IDRRef) AND (T59._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference47 T60
ON (T1._Fld1028RRef = T60._IDRRef) AND (T60._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference64 T61
ON (T1._Fld1040RRef = T61._IDRRef) AND (T61._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference64 T62
ON (T1._Fld12739RRef = T62._IDRRef) AND (T62._Fld595 = ?)
WHERE (((T1._Fld595 = ?)) AND (((T1._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T63
INNER JOIN dbo._Reference21 T64
ON (((T63._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T65
WHERE ((T65._Fld595 = ?)) AND ((T65._Fld12065RRef = T63._IDRRef) AND (T65._Fld12066RRef = T64._IDRRef)))) AND T64._IDRRef IN
(SELECT
T66._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T66
INNER JOIN dbo._InfoRg9937 T67
ON ((T67._Fld9939_TYPE = 0x08 AND T67._Fld9939_RTRef = 0x00000095 AND T67._Fld9939_RRRef = ?) AND (T67._Fld9938_TYPE = T66._Fld784_TYPE AND T67._Fld9938_RTRef = T66._Fld784_RTRef AND T67._Fld9938_RRRef = T66._Fld784_RRRef))
WHERE ((T66._Fld595 = ?)) AND (T67._Fld595 = ?)))
WHERE ((T64._Fld595 = ?)) AND ((CASE WHEN T1._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T1._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T68
WHERE ((T68._Fld595 = ?)) AND ((T68._Fld12072RRef = T64._IDRRef) AND (T68._Fld12073_TYPE = CASE WHEN T1._Fld12836RRef IS NOT NULL THEN 0x08 END AND T68._Fld12073_RTRef = CASE WHEN T1._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T68._Fld12073_RRRef = T1._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T69
WHERE ((T69._Fld595 = ?)) AND ((T69._Fld12199RRef = T64._IDRRef) AND T69._Fld12200_TYPE = CASE WHEN T1._Fld12836RRef IS NOT NULL THEN 0x08 END AND T69._Fld12200_RTRef = CASE WHEN T1._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T69._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((((T1._IDRRef IN (?)) AND ((((((T1._Code LIKE ? ESCAPE '/') OR (T60._Description LIKE ? ESCAPE '/')) OR (T1._Description LIKE ? ESCAPE '/')) OR (T1._Fld1033 LIKE ? ESCAPE '/')) OR (T61._Description LIKE ? ESCAPE '/')) OR (T62._Description LIKE ? ESCAPE '/'))) OR ((((((T22.Q_001_F_001_ LIKE ? ESCAPE '/') OR (T2.Q_001_F_001_ LIKE ? ESCAPE '/')) OR (T32.Q_001_F_001_ LIKE ? ESCAPE '/')) OR (T54.Q_001_F_001_ LIKE ? ESCAPE '/')) OR (T56.Q_001_F_001_ LIKE ? ESCAPE '/')) OR (T52.Q_001_F_001_ LIKE ? ESCAPE '/'))))
ORDER BY (T1._Description), (T1._IDRRef)
"

29.330=TotalDurationSec,1.173=AvgDurationSec,25=Execs,,4,Sql="SELECT TOP 30
CASE WHEN (T208._Fld9869RRef = ?) THEN 1.0 WHEN (T208._Fld9869RRef = ?) THEN 2.0 ELSE 0.0 END,
CASE WHEN (ISNULL(CAST(T209.Fld10324Balance_ AS NUMERIC(33, 2)),0.0) > 0.0) THEN CASE WHEN ((ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0)) = 0.0) THEN 4.0 WHEN (ISNULL(CAST(T140.Fld10992Turnover_ AS NUMERIC(27, 2)),0.0) <= (ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0))) THEN 3.0 WHEN ((ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0)) < (CAST(ISNULL(CAST(T140.Fld10992Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0)) THEN 5.0 ELSE 6.0 END ELSE CASE WHEN ((ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0)) = 0.0) THEN 0.0 WHEN (ISNULL(CAST(T140.Fld10992Turnover_ AS NUMERIC(27, 2)),0.0) <= (ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0))) THEN 3.0 WHEN ((ISNULL(CAST(T140.Fld10994Turnover_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T140.Fld10993Turnover_ AS NUMERIC(27, 2)),0.0)) < (CAST(ISNULL(CAST(T140.Fld10992Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0)) THEN 1.0 ELSE 2.0 END END,
T116._IDRRef,
T116._Marked,
T116._Number,
T116._Date_Time,
T116._Posted,
T116._Fld6560RRef,
T184.Fld1028RRef,
T116._Fld6562,
T116._Fld6563RRef,
T116._Fld6571,
T116._Fld6576RRef,
T116._Fld6582RRef,
T213._Fld1918RRef,
CASE WHEN (((T213._Fld1918RRef = ?) OR (T213._Fld1918RRef = ?)) AND (T116._Fld6583 = 0x00)) THEN ? ELSE CASE WHEN (T213._Fld1918RRef = ?) THEN ? ELSE ? END END,
T116._Fld6583,
CASE WHEN ((T120.Fld11502Balance_ < 0.0) AND (T130.Fld10544Balance_ > 0.0)) THEN ((-1.0 * T120.Fld11502Balance_) + T130.Fld10544Balance_) WHEN (T120.Fld11502Balance_ < 0.0) THEN -(T120.Fld11502Balance_) WHEN (T130.Fld10544Balance_ > 0.0) THEN T130.Fld10544Balance_ ELSE 0.0 END,
CASE WHEN ((T120.Fld11502Balance_ > 0.0) AND (T130.Fld10544Balance_ < 0.0)) THEN ((-1.0 * T130.Fld10544Balance_) + T120.Fld11502Balance_) WHEN (T120.Fld11502Balance_ > 0.0) THEN T120.Fld11502Balance_ WHEN (T130.Fld10544Balance_ < 0.0) THEN -(T130.Fld10544Balance_) ELSE 0.0 END,
T154._Fld1050,
T164._Fld1050,
T193._Fld885,
T205._Fld1155,
T206._Fld1155,
T207._Fld1155,
T116._Fld6587RRef,
T214._Fld1191
FROM dbo._Const8711 T115
INNER JOIN dbo._Document268 T116
LEFT OUTER JOIN (SELECT
T118.Fld11207RRef AS Fld11207RRef,
CAST(SUM(T118.Fld11210Balance_) AS NUMERIC(21, 8)) AS Fld11210InitialBalance_,
CAST(SUM(T118.Fld11210Receipt_) AS NUMERIC(32, 8)) AS Fld11210Receipt_,
CAST(SUM(T118.Fld11210Expense_) AS NUMERIC(32, 8)) AS Fld11210Expense_,
CAST(SUM(T118.Fld11211Balance_) AS NUMERIC(21, 8)) AS Fld11211InitialBalance_,
CAST(SUM(T118.Fld11211Receipt_) AS NUMERIC(33, 8)) AS Fld11211Receipt_,
CAST(SUM(T118.Fld11211Expense_) AS NUMERIC(33, 8)) AS Fld11211Expense_
FROM (SELECT
T119._Fld11207RRef AS Fld11207RRef,
CAST(SUM(0.0) AS NUMERIC(15, 8)) AS Fld11210Balance_,
CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN T119._Fld11210 ELSE 0.0 END) AS NUMERIC(26, 8)) AS Fld11210Receipt_,
CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN 0.0 ELSE T119._Fld11210 END) AS NUMERIC(26, 8)) AS Fld11210Expense_,
CAST(SUM(0.0) AS NUMERIC(15, 8)) AS Fld11211Balance_,
CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN T119._Fld11211 ELSE 0.0 END) AS NUMERIC(27, 8)) AS Fld11211Receipt_,
CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN 0.0 ELSE T119._Fld11211 END) AS NUMERIC(27, 8)) AS Fld11211Expense_
FROM dbo._AccumRg11205 T119
WHERE ((T119._Fld595 = ?)) AND (T119._Active) = 0x01
GROUP BY T119._Fld11207RRef
HAVING (CAST(SUM(0.0) AS NUMERIC(15, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN T119._Fld11210 ELSE 0.0 END) AS NUMERIC(26, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN 0.0 ELSE T119._Fld11210 END) AS NUMERIC(26, 8))) <> 0.0 OR (CAST(SUM(0.0) AS NUMERIC(15, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN T119._Fld11211 ELSE 0.0 END) AS NUMERIC(27, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T119._RecordKind = 0.0 THEN 0.0 ELSE T119._Fld11211 END) AS NUMERIC(27, 8))) <> 0.0) T118
GROUP BY T118.Fld11207RRef
HAVING (CAST(SUM(T118.Fld11210Balance_) AS NUMERIC(21, 8))) <> 0.0 OR (CAST(SUM(T118.Fld11210Receipt_) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T118.Fld11210Expense_) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T118.Fld11211Balance_) AS NUMERIC(21, 8))) <> 0.0 OR (CAST(SUM(T118.Fld11211Receipt_) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T118.Fld11211Expense_) AS NUMERIC(33, 8))) <> 0.0) T117
ON (T117.Fld11207RRef = T116._IDRRef)
LEFT OUTER JOIN (SELECT
T121._Fld11496RRef AS Fld11496RRef,
CAST(SUM(T121._Fld11502) AS NUMERIC(33, 8)) AS Fld11502Balance_
FROM dbo._AccumRgT11507 T121
WHERE (((T121._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T122
ON ((T121._Fld11496RRef = T122._IDRRef)) AND (T122._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T123
INNER JOIN dbo._Reference21 T124
ON (((T123._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T125
WHERE ((T125._Fld595 = ?)) AND ((T125._Fld12065RRef = T123._IDRRef) AND (T125._Fld12066RRef = T124._IDRRef)))) AND T124._IDRRef IN
(SELECT
T126._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T126
INNER JOIN dbo._InfoRg9937 T127
ON ((T127._Fld9939_TYPE = 0x08 AND T127._Fld9939_RTRef = 0x00000095 AND T127._Fld9939_RRRef = ?) AND (T127._Fld9938_TYPE = T126._Fld784_TYPE AND T127._Fld9938_RTRef = T126._Fld784_RTRef AND T127._Fld9938_RRRef = T126._Fld784_RRRef))
WHERE ((T126._Fld595 = ?)) AND (T127._Fld595 = ?)))
WHERE ((T124._Fld595 = ?)) AND ((CASE WHEN T122._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T122._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T128
WHERE ((T128._Fld595 = ?)) AND ((T128._Fld12072RRef = T124._IDRRef) AND (T128._Fld12073_TYPE = CASE WHEN T122._Fld12836RRef IS NOT NULL THEN 0x08 END AND T128._Fld12073_RTRef = CASE WHEN T122._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T128._Fld12073_RRRef = T122._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T129
WHERE ((T129._Fld595 = ?)) AND ((T129._Fld12199RRef = T124._IDRRef) AND T129._Fld12200_TYPE = CASE WHEN T122._Fld12836RRef IS NOT NULL THEN 0x08 END AND T129._Fld12200_RTRef = CASE WHEN T122._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T129._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T121._Period = ? AND (T121._Fld11502 <> ?) AND (T121._Fld11502 <> ?))
GROUP BY T121._Fld11496RRef
HAVING (CAST(SUM(T121._Fld11502) AS NUMERIC(33, 8))) <> 0.0) T120
ON (T116._Fld6560RRef = T120.Fld11496RRef)
LEFT OUTER JOIN (SELECT
T131._Fld10538RRef AS Fld10538RRef,
CAST(SUM(T131._Fld10544) AS NUMERIC(33, 8)) AS Fld10544Balance_
FROM dbo._AccumRgT10549 T131
WHERE (((T131._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T132
ON ((T131._Fld10538RRef = T132._IDRRef)) AND (T132._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T133
INNER JOIN dbo._Reference21 T134
ON (((T133._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T135
WHERE ((T135._Fld595 = ?)) AND ((T135._Fld12065RRef = T133._IDRRef) AND (T135._Fld12066RRef = T134._IDRRef)))) AND T134._IDRRef IN
(SELECT
T136._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T136
INNER JOIN dbo._InfoRg9937 T137
ON ((T137._Fld9939_TYPE = 0x08 AND T137._Fld9939_RTRef = 0x00000095 AND T137._Fld9939_RRRef = ?) AND (T137._Fld9938_TYPE = T136._Fld784_TYPE AND T137._Fld9938_RTRef = T136._Fld784_RTRef AND T137._Fld9938_RRRef = T136._Fld784_RRRef))
WHERE ((T136._Fld595 = ?)) AND (T137._Fld595 = ?)))
WHERE ((T134._Fld595 = ?)) AND ((CASE WHEN T132._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T132._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T138
WHERE ((T138._Fld595 = ?)) AND ((T138._Fld12072RRef = T134._IDRRef) AND (T138._Fld12073_TYPE = CASE WHEN T132._Fld12836RRef IS NOT NULL THEN 0x08 END AND T138._Fld12073_RTRef = CASE WHEN T132._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T138._Fld12073_RRRef = T132._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T139
WHERE ((T139._Fld595 = ?)) AND ((T139._Fld12199RRef = T134._IDRRef) AND T139._Fld12200_TYPE = CASE WHEN T132._Fld12836RRef IS NOT NULL THEN 0x08 END AND T139._Fld12200_RTRef = CASE WHEN T132._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T139._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T131._Period = ? AND (T131._Fld10544 <> ?) AND (T131._Fld10544 <> ?))
GROUP BY T131._Fld10538RRef
HAVING (CAST(SUM(T131._Fld10544) AS NUMERIC(33, 8))) <> 0.0) T130
ON (T116._Fld6560RRef = T130.Fld10538RRef)
LEFT OUTER JOIN (SELECT
T141._Fld10987_TYPE AS Fld10987_TYPE,
T141._Fld10987_RTRef AS Fld10987_RTRef,
T141._Fld10987_RRRef AS Fld10987_RRRef,
CAST(SUM(T141._Fld10993) AS NUMERIC(33, 8)) AS Fld10993Turnover_,
CAST(SUM(T141._Fld10992) AS NUMERIC(33, 8)) AS Fld10992Turnover_,
CAST(SUM(T141._Fld10994) AS NUMERIC(33, 8)) AS Fld10994Turnover_
FROM dbo._AccumRgTn10995 T141
WHERE ((T141._Fld595 = ?)) AND ((T141._Fld10993 <> ? OR T141._Fld10992 <> ? OR T141._Fld10994 <> ?))
GROUP BY T141._Fld10987_TYPE,
T141._Fld10987_RTRef,
T141._Fld10987_RRRef
HAVING (CAST(SUM(T141._Fld10993) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T141._Fld10992) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T141._Fld10994) AS NUMERIC(33, 8))) <> 0.0) T140
ON (0x08 = T140.Fld10987_TYPE AND 0x0000010C = T140.Fld10987_RTRef AND T116._IDRRef = T140.Fld10987_RRRef)
LEFT OUTER JOIN (SELECT
T143._Fld11247RRef AS Fld11247RRef,
CAST(SUM(T143._Fld11254) AS NUMERIC(32, 8)) AS Fld11254Turnover_,
CAST(SUM(T143._Fld11255) AS NUMERIC(33, 8)) AS Fld11255Turnover_,
CAST(SUM(T143._Fld11256) AS NUMERIC(33, 8)) AS Fld11256Turnover_
FROM dbo._AccumRgTn11257 T143
WHERE ((T143._Fld595 = ?)) AND ((T143._Fld11254 <> ? OR T143._Fld11255 <> ? OR T143._Fld11256 <> ?))
GROUP BY T143._Fld11247RRef
HAVING (CAST(SUM(T143._Fld11254) AS NUMERIC(32, 8))) <> 0.0 OR (CAST(SUM(T143._Fld11255) AS NUMERIC(33, 8))) <> 0.0 OR (CAST(SUM(T143._Fld11256) AS NUMERIC(33, 8))) <> 0.0) T142
ON (T116._IDRRef = T142.Fld11247RRef)
LEFT OUTER JOIN (SELECT
T148._Period AS Period_,
T148._Fld9258RRef AS Fld9258RRef,
T148._Fld9259 AS Fld9259_,
T148._Fld9260 AS Fld9260_
FROM (SELECT
T146._Fld9258RRef AS Fld9258RRef,
MAX(T146._Period) AS MAXPERIOD_
FROM dbo._InfoRg9257 T146
WHERE ((T146._Fld595 = ?)) AND ((T146._Fld9258RRef IN
(SELECT
T147._Fld8427RRef AS Q_001_F_000RRef
FROM dbo._Const8426 T147
WHERE (T147._Fld595 = ?))))
GROUP BY T146._Fld9258RRef) T145
INNER JOIN dbo._InfoRg9257 T148
ON T145.Fld9258RRef = T148._Fld9258RRef AND T145.MAXPERIOD_ = T148._Period
WHERE (T148._Fld595 = ?)) T144
ON 1=1
LEFT OUTER JOIN (SELECT
T153._Period AS Period_,
T153._Fld9258RRef AS Fld9258RRef,
T153._Fld9259 AS Fld9259_,
T153._Fld9260 AS Fld9260_
FROM (SELECT
T151._Fld9258RRef AS Fld9258RRef,
MAX(T151._Period) AS MAXPERIOD_
FROM dbo._InfoRg9257 T151
WHERE ((T151._Fld595 = ?)) AND ((T151._Fld9258RRef IN
(SELECT
T152._Fld8712RRef AS Q_001_F_000RRef
FROM dbo._Const8711 T152
WHERE (T152._Fld595 = ?))))
GROUP BY T151._Fld9258RRef) T150
INNER JOIN dbo._InfoRg9257 T153
ON T150.Fld9258RRef = T153._Fld9258RRef AND T150.MAXPERIOD_ = T153._Period
WHERE (T153._Fld595 = ?)) T149
ON 1=1
LEFT OUTER JOIN dbo._Reference42_VT1046 T154
INNER JOIN (SELECT
T156._Folder AS Folder_,
T156._Fld12836RRef AS Fld12836RRef,
T156._IDRRef AS IDRRef,
T156._Fld595 AS Fld595_
FROM dbo._Reference42 T156
WHERE (((T156._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T157
INNER JOIN dbo._Reference21 T158
ON (((T157._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T159
WHERE ((T159._Fld595 = ?)) AND ((T159._Fld12065RRef = T157._IDRRef) AND (T159._Fld12066RRef = T158._IDRRef)))) AND T158._IDRRef IN
(SELECT
T160._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T160
INNER JOIN dbo._InfoRg9937 T161
ON ((T161._Fld9939_TYPE = 0x08 AND T161._Fld9939_RTRef = 0x00000095 AND T161._Fld9939_RRRef = ?) AND (T161._Fld9938_TYPE = T160._Fld784_TYPE AND T161._Fld9938_RTRef = T160._Fld784_RTRef AND T161._Fld9938_RRRef = T160._Fld784_RRRef))
WHERE ((T160._Fld595 = ?)) AND (T161._Fld595 = ?)))
WHERE ((T158._Fld595 = ?)) AND ((CASE WHEN T156._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T156._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T162
WHERE ((T162._Fld595 = ?)) AND ((T162._Fld12072RRef = T158._IDRRef) AND (T162._Fld12073_TYPE = CASE WHEN T156._Fld12836RRef IS NOT NULL THEN 0x08 END AND T162._Fld12073_RTRef = CASE WHEN T156._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T162._Fld12073_RRRef = T156._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T163
WHERE ((T163._Fld595 = ?)) AND ((T163._Fld12199RRef = T158._IDRRef) AND T163._Fld12200_TYPE = CASE WHEN T156._Fld12836RRef IS NOT NULL THEN 0x08 END AND T163._Fld12200_RTRef = CASE WHEN T156._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T163._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) T155
ON T154._Reference42_IDRRef = T155.IDRRef AND T154._Fld595 = T155.Fld595_
ON (((T116._Fld6560RRef = T154._Reference42_IDRRef) AND (T154._Fld1049RRef = ?))) AND (T154._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference42_VT1046 T164
INNER JOIN (SELECT
T166._Folder AS Folder_,
T166._Fld12836RRef AS Fld12836RRef,
T166._IDRRef AS IDRRef,
T166._Fld595 AS Fld595_
FROM dbo._Reference42 T166
WHERE (((T166._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T167
INNER JOIN dbo._Reference21 T168
ON (((T167._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T169
WHERE ((T169._Fld595 = ?)) AND ((T169._Fld12065RRef = T167._IDRRef) AND (T169._Fld12066RRef = T168._IDRRef)))) AND T168._IDRRef IN
(SELECT
T170._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T170
INNER JOIN dbo._InfoRg9937 T171
ON ((T171._Fld9939_TYPE = 0x08 AND T171._Fld9939_RTRef = 0x00000095 AND T171._Fld9939_RRRef = ?) AND (T171._Fld9938_TYPE = T170._Fld784_TYPE AND T171._Fld9938_RTRef = T170._Fld784_RTRef AND T171._Fld9938_RRRef = T170._Fld784_RRRef))
WHERE ((T170._Fld595 = ?)) AND (T171._Fld595 = ?)))
WHERE ((T168._Fld595 = ?)) AND ((CASE WHEN T166._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T166._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T172
WHERE ((T172._Fld595 = ?)) AND ((T172._Fld12072RRef = T168._IDRRef) AND (T172._Fld12073_TYPE = CASE WHEN T166._Fld12836RRef IS NOT NULL THEN 0x08 END AND T172._Fld12073_RTRef = CASE WHEN T166._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T172._Fld12073_RRRef = T166._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T173
WHERE ((T173._Fld595 = ?)) AND ((T173._Fld12199RRef = T168._IDRRef) AND T173._Fld12200_TYPE = CASE WHEN T166._Fld12836RRef IS NOT NULL THEN 0x08 END AND T173._Fld12200_RTRef = CASE WHEN T166._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T173._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) T165
ON T164._Reference42_IDRRef = T165.IDRRef AND T164._Fld595 = T165.Fld595_
ON (((T116._Fld6560RRef = T164._Reference42_IDRRef) AND (T164._Fld1049RRef = ?))) AND (T164._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference42_VT1046 T174
INNER JOIN (SELECT
T176._Folder AS Folder_,
T176._Fld12836RRef AS Fld12836RRef,
T176._IDRRef AS IDRRef,
T176._Fld595 AS Fld595_
FROM dbo._Reference42 T176
WHERE (((T176._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T177
INNER JOIN dbo._Reference21 T178
ON (((T177._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T179
WHERE ((T179._Fld595 = ?)) AND ((T179._Fld12065RRef = T177._IDRRef) AND (T179._Fld12066RRef = T178._IDRRef)))) AND T178._IDRRef IN
(SELECT
T180._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T180
INNER JOIN dbo._InfoRg9937 T181
ON ((T181._Fld9939_TYPE = 0x08 AND T181._Fld9939_RTRef = 0x00000095 AND T181._Fld9939_RRRef = ?) AND (T181._Fld9938_TYPE = T180._Fld784_TYPE AND T181._Fld9938_RTRef = T180._Fld784_RTRef AND T181._Fld9938_RRRef = T180._Fld784_RRRef))
WHERE ((T180._Fld595 = ?)) AND (T181._Fld595 = ?)))
WHERE ((T178._Fld595 = ?)) AND ((CASE WHEN T176._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T176._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T182
WHERE ((T182._Fld595 = ?)) AND ((T182._Fld12072RRef = T178._IDRRef) AND (T182._Fld12073_TYPE = CASE WHEN T176._Fld12836RRef IS NOT NULL THEN 0x08 END AND T182._Fld12073_RTRef = CASE WHEN T176._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T182._Fld12073_RRRef = T176._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T183
WHERE ((T183._Fld595 = ?)) AND ((T183._Fld12199RRef = T178._IDRRef) AND T183._Fld12200_TYPE = CASE WHEN T176._Fld12836RRef IS NOT NULL THEN 0x08 END AND T183._Fld12200_RTRef = CASE WHEN T176._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T183._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) T175
ON T174._Reference42_IDRRef = T175.IDRRef AND T174._Fld595 = T175.Fld595_
ON (((T116._Fld6560RRef = T174._Reference42_IDRRef) AND (T174._Fld1049RRef = ?))) AND (T174._Fld595 = ?)
LEFT OUTER JOIN (SELECT
T185._Fld1032RRef AS Fld1032RRef,
T185._Fld1037RRef AS Fld1037RRef,
T185._Fld1028RRef AS Fld1028RRef,
T185._Folder AS Folder_,
T185._Description COLLATE Latin1_General_CI_AS AS Description_,
T185._Fld12836RRef AS Fld12836RRef,
T185._IDRRef AS IDRRef,
T185._Fld595 AS Fld595_
FROM dbo._Reference42 T185
WHERE ((((T185._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T186
INNER JOIN dbo._Reference21 T187
ON (((T186._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T188
WHERE ((T188._Fld595 = ?)) AND ((T188._Fld12065RRef = T186._IDRRef) AND (T188._Fld12066RRef = T187._IDRRef)))) AND T187._IDRRef IN
(SELECT
T189._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T189
INNER JOIN dbo._InfoRg9937 T190
ON ((T190._Fld9939_TYPE = 0x08 AND T190._Fld9939_RTRef = 0x00000095 AND T190._Fld9939_RRRef = ?) AND (T190._Fld9938_TYPE = T189._Fld784_TYPE AND T190._Fld9938_RTRef = T189._Fld784_RTRef AND T190._Fld9938_RRRef = T189._Fld784_RRRef))
WHERE ((T189._Fld595 = ?)) AND (T190._Fld595 = ?)))
WHERE ((T187._Fld595 = ?)) AND ((CASE WHEN T185._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T185._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T191
WHERE ((T191._Fld595 = ?)) AND ((T191._Fld12072RRef = T187._IDRRef) AND (T191._Fld12073_TYPE = CASE WHEN T185._Fld12836RRef IS NOT NULL THEN 0x08 END AND T191._Fld12073_RTRef = CASE WHEN T185._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T191._Fld12073_RRRef = T185._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T192
WHERE ((T192._Fld595 = ?)) AND ((T192._Fld12199RRef = T187._IDRRef) AND T192._Fld12200_TYPE = CASE WHEN T185._Fld12836RRef IS NOT NULL THEN 0x08 END AND T192._Fld12200_RTRef = CASE WHEN T185._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T192._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T185._Fld595 = ?)) T184
ON T116._Fld6560RRef = T184.IDRRef
LEFT OUTER JOIN dbo._Reference24 T193
ON ((T184.Fld1037RRef = T193._IDRRef)) AND (T193._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference24 T194
ON ((T184.Fld1032RRef = T194._IDRRef)) AND (T194._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference42_VT1046 T195
INNER JOIN (SELECT
T197._Folder AS Folder_,
T197._Fld12836RRef AS Fld12836RRef,
T197._IDRRef AS IDRRef,
T197._Fld595 AS Fld595_
FROM dbo._Reference42 T197
WHERE (((T197._Folder = 0x00) OR EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T198
INNER JOIN dbo._Reference21 T199
ON (((T198._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T200
WHERE ((T200._Fld595 = ?)) AND ((T200._Fld12065RRef = T198._IDRRef) AND (T200._Fld12066RRef = T199._IDRRef)))) AND T199._IDRRef IN
(SELECT
T201._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T201
INNER JOIN dbo._InfoRg9937 T202
ON ((T202._Fld9939_TYPE = 0x08 AND T202._Fld9939_RTRef = 0x00000095 AND T202._Fld9939_RRRef = ?) AND (T202._Fld9938_TYPE = T201._Fld784_TYPE AND T202._Fld9938_RTRef = T201._Fld784_RTRef AND T202._Fld9938_RRRef = T201._Fld784_RRRef))
WHERE ((T201._Fld595 = ?)) AND (T202._Fld595 = ?)))
WHERE ((T199._Fld595 = ?)) AND ((CASE WHEN T197._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T197._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T203
WHERE ((T203._Fld595 = ?)) AND ((T203._Fld12072RRef = T199._IDRRef) AND (T203._Fld12073_TYPE = CASE WHEN T197._Fld12836RRef IS NOT NULL THEN 0x08 END AND T203._Fld12073_RTRef = CASE WHEN T197._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T203._Fld12073_RRRef = T197._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T204
WHERE ((T204._Fld595 = ?)) AND ((T204._Fld12199RRef = T199._IDRRef) AND T204._Fld12200_TYPE = CASE WHEN T197._Fld12836RRef IS NOT NULL THEN 0x08 END AND T204._Fld12200_RTRef = CASE WHEN T197._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T204._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) T196
ON T195._Reference42_IDRRef = T196.IDRRef AND T195._Fld595 = T196.Fld595_
ON (((T116._Fld6560RRef = T195._Reference42_IDRRef) AND (T195._Fld1049RRef = ?))) AND (T195._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference47_VT1151 T205
ON (((T184.Fld1028RRef = T205._Reference47_IDRRef) AND (T205._Fld1154RRef = ?))) AND (T205._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference47_VT1151 T206
ON (((T184.Fld1028RRef = T206._Reference47_IDRRef) AND (T206._Fld1154RRef = ?))) AND (T206._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference47_VT1151 T207
ON (((T184.Fld1028RRef = T207._Reference47_IDRRef) AND (T207._Fld1154RRef = ?))) AND (T207._Fld595 = ?)
LEFT OUTER JOIN dbo._InfoRg9867 T208
ON ((T208._Fld9868_TYPE = 0x08 AND T208._Fld9868_RTRef = 0x0000010C AND T208._Fld9868_RRRef = T116._IDRRef)) AND (T208._Fld595 = ?)
LEFT OUTER JOIN (SELECT
T210.Fld10321RRef AS Fld10321RRef,
CAST(SUM(T210.Fld10324Balance_) AS NUMERIC(38, 8)) AS Fld10324Balance_
FROM (SELECT
T211._Fld10321RRef AS Fld10321RRef,
CAST(SUM(T211._Fld10324) AS NUMERIC(33, 8)) AS Fld10324Balance_
FROM dbo._AccumRgT10325 T211
WHERE ((T211._Fld595 = ?)) AND (T211._Period = ? AND (T211._Fld10324 <> ?) AND (T211._Fld10324 <> ?))
GROUP BY T211._Fld10321RRef
HAVING (CAST(SUM(T211._Fld10324) AS NUMERIC(33, 8))) <> 0.0
UNION ALL SELECT
T212._Fld10321RRef AS Fld10321RRef,
CAST(CAST(SUM(CASE WHEN T212._RecordKind = 0.0 THEN -T212._Fld10324 ELSE T212._Fld10324 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2)) AS Fld10324Balance_
FROM dbo._AccumRg10317 T212
WHERE ((T212._Fld595 = ?)) AND (T212._Period >= ? AND T212._Period < ? AND T212._Active = 0x01)
GROUP BY T212._Fld10321RRef
HAVING (CAST(CAST(SUM(CASE WHEN T212._RecordKind = 0.0 THEN -T212._Fld10324 ELSE T212._Fld10324 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2))) <> 0.0) T210
GROUP BY T210.Fld10321RRef
HAVING (CAST(SUM(T210.Fld10324Balance_) AS NUMERIC(38, 8))) <> 0.0) T209
ON (T116._IDRRef = T209.Fld10321RRef)
ON 1=1
LEFT OUTER JOIN dbo._Reference123 T213
ON (T116._Fld6582RRef = T213._IDRRef) AND (T213._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference51 T214
ON (T116._Fld6563RRef = T214._IDRRef) AND (T214._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference28 T215
ON (T116._Fld6576RRef = T215._IDRRef) AND (T215._Fld595 = ?)
LEFT OUTER JOIN dbo._Reference47 T216
ON (T184.Fld1028RRef = T216._IDRRef) AND (T216._Fld595 = ?)
WHERE (((((T115._Fld595 = ?) AND (T116._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T217
ON ((T116._Fld6560RRef = T217._IDRRef)) AND (T217._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T218
INNER JOIN dbo._Reference21 T219
ON (((T218._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_006_F_000_
FROM dbo._InfoRg11709 T220
WHERE ((T220._Fld595 = ?)) AND ((T220._Fld12065RRef = T218._IDRRef) AND (T220._Fld12066RRef = T219._IDRRef)))) AND T219._IDRRef IN
(SELECT
T221._Reference21_IDRRef AS Q_007_F_000RRef
FROM dbo._Reference21_VT782 T221
INNER JOIN dbo._InfoRg9937 T222
ON ((T222._Fld9939_TYPE = 0x08 AND T222._Fld9939_RTRef = 0x00000095 AND T222._Fld9939_RRRef = ?) AND (T222._Fld9938_TYPE = T221._Fld784_TYPE AND T222._Fld9938_RTRef = T221._Fld784_RTRef AND T222._Fld9938_RRRef = T221._Fld784_RRRef))
WHERE ((T221._Fld595 = ?)) AND (T222._Fld595 = ?)))
WHERE ((T219._Fld595 = ?)) AND ((0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T223
WHERE ((T223._Fld595 = ?)) AND ((T223._Fld12072RRef = T219._IDRRef) AND (T223._Fld12073_TYPE = 0x08 AND T223._Fld12073_RTRef = 0x0000001C AND T223._Fld12073_RRRef = T116._Fld6576RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T224
WHERE ((T224._Fld595 = ?)) AND ((T224._Fld12199RRef = T219._IDRRef) AND T224._Fld12200_TYPE = 0x08 AND T224._Fld12200_RTRef = 0x0000001C AND (T224._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END) AND (CASE WHEN T217._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T217._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11710 T225
WHERE ((T225._Fld595 = ?)) AND ((T225._Fld12072RRef = T219._IDRRef) AND (T225._Fld12073_TYPE = CASE WHEN T217._Fld12836RRef IS NOT NULL THEN 0x08 END AND T225._Fld12073_RTRef = CASE WHEN T217._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T225._Fld12073_RRRef = T217._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_005_F_000_
FROM dbo._InfoRg11715 T226
WHERE ((T226._Fld595 = ?)) AND ((T226._Fld12199RRef = T219._IDRRef) AND T226._Fld12200_TYPE = CASE WHEN T217._Fld12836RRef IS NOT NULL THEN 0x08 END AND T226._Fld12200_RTRef = CASE WHEN T217._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T226._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T116._IDRRef IN
(SELECT
T227._INVALUELISTRRef AS INVALUELISTRRef
FROM #tt T227 WITH(NOLOCK)
WHERE T227._INVALUELISTRRef IS NOT NULL) AND ((((T215._Description LIKE ? ESCAPE '/') OR (T184.Description_ LIKE ? ESCAPE '/')) OR (T214._Description LIKE ? ESCAPE '/')) OR (T116._Number LIKE ? ESCAPE '/'))) OR (((((((T154._Fld1050 LIKE ? ESCAPE '/') OR (T193._Fld885 LIKE ? ESCAPE '/')) OR (T164._Fld1050 LIKE ? ESCAPE '/')) OR (T216._Description LIKE ? ESCAPE '/')) OR (T205._Fld1155 LIKE ? ESCAPE '/')) OR (T206._Fld1155 LIKE ? ESCAPE '/')) OR (T207._Fld1155 LIKE ? ESCAPE '/')))) AND ((T116._IDRRef IN
(SELECT
T228._INVALUELISTRRef AS INVALUELISTRRef
FROM #tt T228 WITH(NOLOCK)
WHERE T228._INVALUELISTRRef IS NOT NULL) AND ((((T215._Description LIKE ? ESCAPE '/') OR (T184.Description_ LIKE ? ESCAPE '/')) OR (T214._Description LIKE ? ESCAPE '/')) OR (T116._Number LIKE ? ESCAPE '/'))) OR (((((((T154._Fld1050 LIKE ? ESCAPE '/') OR (T193._Fld885 LIKE ? ESCAPE '/')) OR (T164._Fld1050 LIKE ? ESCAPE '/')) OR (T216._Description LIKE ? ESCAPE '/')) OR (T205._Fld1155 LIKE ? ESCAPE '/')) OR (T206._Fld1155 LIKE ? ESCAPE '/')) OR (T207._Fld1155 LIKE ? ESCAPE '/')))) AND T116._Date_Time < ?
ORDER BY (T116._Date_Time) DESC, (T116._IDRRef) DESC
OPTION (FAST 1)
",Context=DynamicList.GetData : Document.PurchaseOrder.Form.ListForm.Attribute.List