SET client_min_messages=error;
SET enable_mergejoin = off;
SET escape_string_warning = off;
SET cpu_operator_cost = 0.001;
set client_encoding = 'utf8';
SET lock_timeout = 20000;

EXPLAIN (ANALYZE, BUFFERS, SETTINGS)
SELECT
CASE WHEN (EXISTS(SELECT
TRUE AS Q_001_F_000_
FROM _InfoRg8199 T23
LEFT OUTER JOIN _InfoRg10621 T24
ON ((T24._Fld10622RRef = T23._Fld8201RRef) AND (T24._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)) AND (T24._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T23._Fld809 = CAST(0 AS NUMERIC))) AND ((T23._Fld8200_TYPE = '\\010'::bytea AND T23._Fld8200_RTRef = '\\000\\000\\000\\177'::bytea AND T23._Fld8200_RRRef = T1._IDRRef) AND (NOT (((T24._Fld10622RRef IS NULL))))))) AND COALESCE(T2.SDBL_RLS_SIGNAL_,TRUE) = TRUE AND COALESCE(T6.SDBL_RLS_SIGNAL_,TRUE) = TRUE AND COALESCE(T18.SDBL_RLS_SIGNAL_,TRUE) = TRUE THEN TRUE ELSE FALSE END,
T1._IDRRef
FROM _Reference127 T1
LEFT OUTER JOIN (SELECT
CASE WHEN (EXISTS(SELECT
TRUE AS Q_001_F_000_
FROM _InfoRg8199 T4
LEFT OUTER JOIN _InfoRg10621 T5
ON ((T5._Fld10622RRef = T4._Fld8201RRef) AND (T5._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)) AND (T5._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T4._Fld809 = CAST(0 AS NUMERIC))) AND ((T4._Fld8200_TYPE = '\\010'::bytea AND T4._Fld8200_RTRef = '\\000\\000\\000\\177'::bytea AND T4._Fld8200_RRRef = T3._Fld12031RRef) AND (NOT (((T5._Fld10622RRef IS NULL))))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_,
T3._Fld809 AS Fld809_,
T3._Fld12031RRef AS Fld12031RRef
FROM _InfoRg12030 T3
WHERE (T3._Fld809 = CAST(0 AS NUMERIC))) T2
ON (T1._IDRRef = T2.Fld12031RRef)
LEFT OUTER JOIN (SELECT
CASE WHEN (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN _Reference312 T8
ON (T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea AND T7._Fld11507_RRRef = T8._IDRRef) AND (T8._Fld809 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference312 T9
ON (T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea AND T7._Fld11509_RRRef = T9._IDRRef) AND (T9._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea) AND EXISTS(SELECT
TRUE AS Q_001_F_000_
FROM _InfoRg8199 T10
LEFT OUTER JOIN _InfoRg10621 T11
ON ((T10._Fld8201RRef = T11._Fld10622RRef)) AND (T11._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T10._Fld809 = CAST(0 AS NUMERIC))) AND ((T10._Fld8200_TYPE = (T8._Fld4781_TYPE) AND T10._Fld8200_RTRef = (T8._Fld4781_RTRef) AND T10._Fld8200_RRRef = (T8._Fld4781_RRRef)) AND (T11._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))) OR (NOT (((T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea)))) AND EXISTS(SELECT
TRUE AS Q_002_F_000_
FROM _InfoRg8199 T12
LEFT OUTER JOIN _InfoRg10621 T13
ON ((T12._Fld8201RRef = T13._Fld10622RRef)) AND (T13._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T12._Fld809 = CAST(0 AS NUMERIC))) AND ((T12._Fld8200_TYPE = T7._Fld11507_TYPE AND T12._Fld8200_RTRef = T7._Fld11507_RTRef AND T12._Fld8200_RRRef = T7._Fld11507_RRRef) AND (T13._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)))) AND ((T7._Fld11509_TYPE = '\\001'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\000\\000'::bytea AND T7._Fld11509_RRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) OR (T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea) AND EXISTS(SELECT
TRUE AS Q_003_F_000_
FROM _InfoRg8199 T14
LEFT OUTER JOIN _InfoRg10621 T15
ON ((T14._Fld8201RRef = T15._Fld10622RRef)) AND (T15._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T14._Fld809 = CAST(0 AS NUMERIC))) AND ((T14._Fld8200_TYPE = (T9._Fld4781_TYPE) AND T14._Fld8200_RTRef = (T9._Fld4781_RTRef) AND T14._Fld8200_RRRef = (T9._Fld4781_RRRef)) AND (T15._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))) OR (NOT (((T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea)))) AND EXISTS(SELECT
TRUE AS Q_004_F_000_
FROM _InfoRg8199 T16
LEFT OUTER JOIN _InfoRg10621 T17
ON ((T16._Fld8201RRef = T17._Fld10622RRef)) AND (T17._Fld809 = CAST(0 AS NUMERIC))
WHERE ((T16._Fld809 = CAST(0 AS NUMERIC))) AND ((T16._Fld8200_TYPE = T7._Fld11509_TYPE AND T16._Fld8200_RTRef = T7._Fld11509_RTRef AND T16._Fld8200_RRRef = T7._Fld11509_RRRef) AND (T17._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_,
T7._Fld809 AS Fld809_,
T7._Fld11509_TYPE AS Fld11509_TYPE,
T7._Fld11509_RTRef AS Fld11509_RTRef,
T7._Fld11509_RRRef AS Fld11509_RRRef,
T7._Fld11508RRef AS Fld11508RRef,
T7._Fld11507_TYPE AS Fld11507_TYPE,
T7._Fld11507_RTRef AS Fld11507_RTRef,
T7._Fld11507_RRRef AS Fld11507_RRRef
FROM _InfoRg11506 T7
WHERE (T7._Fld809 = CAST(0 AS NUMERIC))) T6
ON ('\\010'::bytea = T6.Fld11507_TYPE AND '\\000\\000\\000\\177'::bytea = T6.Fld11507_RTRef AND T1._IDRRef = T6.Fld11507_RRRef) AND (T6.Fld11508RRef = '\\237X\\000PV\\276\\306\\177\\021\\360\\211l\\367\\233\\277\\234'::bytea)
LEFT OUTER JOIN (SELECT
CASE WHEN (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN _Reference147 T20
ON ((T19._Fld8928RRef = T20._IDRRef)) AND (T20._Fld809 = CAST(0 AS NUMERIC))
WHERE (T20._Fld2132_TYPE = '\\010'::bytea AND T20._Fld2132_RTRef = '\\000\\000\\001\\020'::bytea AND T20._Fld2132_RRRef IN ('\\210@\\000PV\\276\\307<\\021\\360\\244\\2439#x\\310'::bytea)) OR (T20._Fld2135 = FALSE) AND EXISTS(SELECT
TRUE AS Q_001_F_000_
FROM _InfoRg8199 T21
WHERE ((T21._Fld809 = CAST(0 AS NUMERIC))) AND (('\\010'::bytea = T21._Fld8200_TYPE AND '\\000\\000\\000\\223'::bytea = T21._Fld8200_RTRef AND T20._IDRRef = T21._Fld8200_RRRef) AND EXISTS(SELECT
TRUE AS Q_002_F_000_
FROM _InfoRg10621 T22
WHERE ((T22._Fld809 = CAST(0 AS NUMERIC))) AND ((T21._Fld8201RRef = T22._Fld10622RRef) AND (T22._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_,
T19._Fld8928RRef AS Fld8928RRef,
T19._Fld8927_TYPE AS Fld8927_TYPE,
T19._Fld8927_RTRef AS Fld8927_RTRef,
T19._Fld8927_RRRef AS Fld8927_RRRef,
T19._Fld809 AS Fld809_
FROM _InfoRg8926 T19
WHERE (T19._Fld809 = CAST(0 AS NUMERIC))) T18
ON ('\\010'::bytea = T18.Fld8927_TYPE AND '\\000\\000\\000\\177'::bytea = T18.Fld8927_RTRef AND T1._IDRRef = T18.Fld8927_RRRef)
WHERE ((T1._Fld809 = CAST(0 AS NUMERIC))) AND ((T1._IDRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (T1._Fld1806RRef = '\\203\\356\\000PV\\276+c\\021\\360\\215L\\342i\\233\\304'::bytea))
