Query #5

)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 = @P1)) 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 = @P2) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T7
WHERE ((T7._Fld595 = @P3)) 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 = @P4) AND (T9._Fld9938_TYPE = T8._Fld784_TYPE AND T9._Fld9938_RTRef = T8._Fld784_RTRef AND T9._Fld9938_RRRef = T8._Fld784_RRRef))
WHERE ((T8._Fld595 = @P5)) AND (T9._Fld595 = @P6)))
WHERE ((T6._Fld595 = @P7)) 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 = @P8)) 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 = @P9)) 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 = @P10))) 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 = @P11)) 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 = @P12) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T17
WHERE ((T17._Fld595 = @P13)) 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 = @P14) AND (T19._Fld9938_TYPE = T18._Fld784_TYPE AND T19._Fld9938_RTRef = T18._Fld784_RTRef AND T19._Fld9938_RRRef = T18._Fld784_RRRef))
WHERE ((T18._Fld595 = @P15)) AND (T19._Fld595 = @P16)))
WHERE ((T16._Fld595 = @P17)) 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 = @P18)) 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