Compare Pastes
Differences between the pastes
#174801 (20.04.2021 11:00)
and
#241135 (09.12.2021 05:11).
1 | INSERT INTO pg_temp.tt159 (_Q_001_F_000RRef, _Q_001_F_001RRef, _Q_001_F_002) SELECT T1._Document444_IDRRef, T1._Fld14559RRef, COUNT(DISTINCT T1._Fld14577RRef) FROM _Document444_VT14557 T1 LEFT OUTER JOIN _InfoRg23801 T2 ON (('\\010'::bytea = T2._Fld23805_TYPE AND '\\000\\000\\001\\013'::bytea = T2._Fld23805_RTRef AND T1._Fld14577RRef = T2._Fld23805_RRRef)) AND (T2._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Document444 T3 ON (T1._Document444_IDRRef = T3._IDRRef) AND (T3._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference183 T4 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\267'::bytea AND T2._Fld23805_RRRef = T4._IDRRef) AND (T4._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference192 T5 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\300'::bytea AND T2._Fld23805_RRRef = T5._IDRRef) AND (T5._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25641 T6 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000d)'::bytea AND T2._Fld23805_RRRef = T6._IDRRef) AND (T6._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference274 T7 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\022'::bytea AND T2._Fld23805_RRRef = T7._IDRRef) AND (T7._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference249 T8 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\371'::bytea AND T2._Fld23805_RRRef = T8._IDRRef) AND (T8._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference294 T9 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001&'::bytea AND T2._Fld23805_RRRef = T9._IDRRef) AND (T9._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24509 T10 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000_\\275'::bytea AND T2._Fld23805_RRRef = T10._IDRRef) AND (T10._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference176 T11 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\260'::bytea AND T2._Fld23805_RRRef = T11._IDRRef LEFT OUTER JOIN _Reference23370 T12 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[J'::bytea AND T2._Fld23805_RRRef = T12._IDRRef) AND (T12._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24963 T13 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000a\\203'::bytea AND T2._Fld23805_RRRef = T13._IDRRef) AND (T13._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference257 T14 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\001'::bytea AND T2._Fld23805_RRRef = T14._IDRRef) AND (T14._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25550 T15 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000c\\316'::bytea AND T2._Fld23805_RRRef = T15._IDRRef) AND (T15._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference253 T16 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\375'::bytea AND T2._Fld23805_RRRef = T16._IDRRef) AND (T16._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference137 T17 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\211'::bytea AND T2._Fld23805_RRRef = T17._IDRRef) AND (T17._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference68 T18 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000D'::bytea AND T2._Fld23805_RRRef = T18._IDRRef) AND (T18._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23372 T19 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[L'::bytea AND T2._Fld23805_RRRef = T19._IDRRef) AND (T19._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference118 T20 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000v'::bytea AND T2._Fld23805_RRRef = T20._IDRRef) AND (T20._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference114 T21 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000r'::bytea AND T2._Fld23805_RRRef = T21._IDRRef) AND (T21._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference75 T22 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000K'::bytea AND T2._Fld23805_RRRef = T22._IDRRef) AND (T22._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference177 T23 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\261'::bytea AND T2._Fld23805_RRRef = T23._IDRRef) AND (T23._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference155 T24 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\233'::bytea AND T2._Fld23805_RRRef = T24._IDRRef) AND (T24._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference131 T25 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\203'::bytea AND T2._Fld23805_RRRef = T25._IDRRef) AND (T25._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference163 T26 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\243'::bytea AND T2._Fld23805_RRRef = T26._IDRRef) AND (T26._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference169 T27 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\251'::bytea AND T2._Fld23805_RRRef = T27._IDRRef) AND (T27._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference145 T28 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\221'::bytea AND T2._Fld23805_RRRef = T28._IDRRef) AND (T28._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference291 T29 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001#'::bytea AND T2._Fld23805_RRRef = T29._IDRRef LEFT OUTER JOIN _Reference305 T30 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0011'::bytea AND T2._Fld23805_RRRef = T30._IDRRef) AND (T30._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference115 T31 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000s'::bytea AND T2._Fld23805_RRRef = T31._IDRRef) AND (T31._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference94 T32 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000^'::bytea AND T2._Fld23805_RRRef = T32._IDRRef) AND (T32._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference280 T33 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\030'::bytea AND T2._Fld23805_RRRef = T33._IDRRef) AND (T33._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference266 T34 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\012'::bytea AND T2._Fld23805_RRRef = T34._IDRRef) AND (T34._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference67 T35 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000C'::bytea AND T2._Fld23805_RRRef = T35._IDRRef) AND (T35._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference321 T36 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001A'::bytea AND T2._Fld23805_RRRef = T36._IDRRef LEFT OUTER JOIN _Reference182 T37 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\266'::bytea AND T2._Fld23805_RRRef = T37._IDRRef) AND (T37._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25281 T38 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000b\\301'::bytea AND T2._Fld23805_RRRef = T38._IDRRef) AND (T38._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference27359 T39 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000j\\337'::bytea AND T2._Fld23805_RRRef = T39._IDRRef) AND (T39._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference306 T40 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0012'::bytea AND T2._Fld23805_RRRef = T40._IDRRef) AND (T40._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference196 T41 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\304'::bytea AND T2._Fld23805_RRRef = T41._IDRRef) AND (T41._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference190 T42 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\276'::bytea AND T2._Fld23805_RRRef = T42._IDRRef) AND (T42._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference86 T43 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000V'::bytea AND T2._Fld23805_RRRef = T43._IDRRef) AND (T43._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference320 T44 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001@'::bytea AND T2._Fld23805_RRRef = T44._IDRRef) AND (T44._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference205 T45 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\315'::bytea AND T2._Fld23805_RRRef = T45._IDRRef LEFT OUTER JOIN _Reference297 T46 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001)'::bytea AND T2._Fld23805_RRRef = T46._IDRRef) AND (T46._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference223 T47 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\337'::bytea AND T2._Fld23805_RRRef = T47._IDRRef) AND (T47._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference258 T48 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\002'::bytea AND T2._Fld23805_RRRef = T48._IDRRef) AND (T48._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference302 T49 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001.'::bytea AND T2._Fld23805_RRRef = T49._IDRRef LEFT OUTER JOIN _Reference24704 T50 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000`\\200'::bytea AND T2._Fld23805_RRRef = T50._IDRRef) AND (T50._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference191 T51 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\277'::bytea AND T2._Fld23805_RRRef = T51._IDRRef) AND (T51._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference92 T52 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\\\'::bytea AND T2._Fld23805_RRRef = T52._IDRRef) AND (T52._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference329 T53 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001I'::bytea AND T2._Fld23805_RRRef = T53._IDRRef) AND (T53._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference44 T54 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000,'::bytea AND T2._Fld23805_RRRef = T54._IDRRef) AND (T54._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference245 T55 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\365'::bytea AND T2._Fld23805_RRRef = T55._IDRRef) AND (T55._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference227 T56 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\343'::bytea AND T2._Fld23805_RRRef = T56._IDRRef) AND (T56._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference78 T57 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000N'::bytea AND T2._Fld23805_RRRef = T57._IDRRef) AND (T57._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25120 T58 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000b '::bytea AND T2._Fld23805_RRRef = T58._IDRRef) AND (T58._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference313 T59 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0019'::bytea AND T2._Fld23805_RRRef = T59._IDRRef) AND (T59._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference51 T60 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0003'::bytea AND T2._Fld23805_RRRef = T60._IDRRef) AND (T60._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference98 T61 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000b'::bytea AND T2._Fld23805_RRRef = T61._IDRRef) AND (T61._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference243 T62 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\363'::bytea AND T2._Fld23805_RRRef = T62._IDRRef) AND (T62._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25629 T63 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000d\\035'::bytea AND T2._Fld23805_RRRef = T63._IDRRef) AND (T63._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24572 T64 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000_\\374'::bytea AND T2._Fld23805_RRRef = T64._IDRRef) AND (T64._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference47 T65 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000/'::bytea AND T2._Fld23805_RRRef = T65._IDRRef) AND (T65._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23375 T66 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[O'::bytea AND T2._Fld23805_RRRef = T66._IDRRef) AND (T66._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference27053 T67 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000i\\255'::bytea AND T2._Fld23805_RRRef = T67._IDRRef) AND (T67._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference255 T68 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\377'::bytea AND T2._Fld23805_RRRef = T68._IDRRef) AND (T68._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference113 T69 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000q'::bytea AND T2._Fld23805_RRRef = T69._IDRRef) AND (T69._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference247 T70 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\367'::bytea AND T2._Fld23805_RRRef = T70._IDRRef) AND (T70._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference309 T71 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0015'::bytea AND T2._Fld23805_RRRef = T71._IDRRef LEFT OUTER JOIN _Reference283 T72 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\033'::bytea AND T2._Fld23805_RRRef = T72._IDRRef) AND (T72._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference100 T73 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000d'::bytea AND T2._Fld23805_RRRef = T73._IDRRef) AND (T73._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference213 T74 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\325'::bytea AND T2._Fld23805_RRRef = T74._IDRRef) AND (T74._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference107 T75 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000k'::bytea AND T2._Fld23805_RRRef = T75._IDRRef) AND (T75._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference308 T76 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0014'::bytea AND T2._Fld23805_RRRef = T76._IDRRef) AND (T76._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference322 T77 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001B'::bytea AND T2._Fld23805_RRRef = T77._IDRRef) AND (T77._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23367 T78 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[G'::bytea AND T2._Fld23805_RRRef = T78._IDRRef) AND (T78._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference303 T79 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001/'::bytea AND T2._Fld23805_RRRef = T79._IDRRef) AND (T79._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference103 T80 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000g'::bytea AND T2._Fld23805_RRRef = T80._IDRRef) AND (T80._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference58 T81 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000:'::bytea AND T2._Fld23805_RRRef = T81._IDRRef) AND (T81._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25485 T82 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000c\\215'::bytea AND T2._Fld23805_RRRef = T82._IDRRef) AND (T82._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference197 T83 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\305'::bytea AND T2._Fld23805_RRRef = T83._IDRRef) AND (T83._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference121 T84 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000y'::bytea AND T2._Fld23805_RRRef = T84._IDRRef) AND (T84._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference199 T85 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\307'::bytea AND T2._Fld23805_RRRef = T85._IDRRef) AND (T85._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference328 T86 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001H'::bytea AND T2._Fld23805_RRRef = T86._IDRRef) AND (T86._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference141 T87 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\215'::bytea AND T2._Fld23805_RRRef = T87._IDRRef) AND (T87._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference26181 T88 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000fE'::bytea AND T2._Fld23805_RRRef = T88._IDRRef) AND (T88._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference198 T89 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\306'::bytea AND T2._Fld23805_RRRef = T89._IDRRef) AND (T89._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference124 T90 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000|'::bytea AND T2._Fld23805_RRRef = T90._IDRRef) AND (T90._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference311 T91 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0017'::bytea AND T2._Fld23805_RRRef = T91._IDRRef) AND (T91._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference270 T92 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\016'::bytea AND T2._Fld23805_RRRef = T92._IDRRef) AND (T92._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference271 T93 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\017'::bytea AND T2._Fld23805_RRRef = T93._IDRRef) AND (T93._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference189 T94 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\275'::bytea AND T2._Fld23805_RRRef = T94._IDRRef) AND (T94._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference287 T95 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\037'::bytea AND T2._Fld23805_RRRef = T95._IDRRef) AND (T95._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference279 T96 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\027'::bytea AND T2._Fld23805_RRRef = T96._IDRRef) AND (T96._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference134 T97 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\206'::bytea AND T2._Fld23805_RRRef = T97._IDRRef) AND (T97._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference210 T98 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\322'::bytea AND T2._Fld23805_RRRef = T98._IDRRef LEFT OUTER JOIN _Reference188 T99 T1._Q_001_F_001RRef, T1._Q_001_F_002, T1._Q_001_F_003, T1._Q_001_F_004, T1._Q_001_F_005_TYPE, T1._Q_001_F_005_L, T1._Q_001_F_005_T, T1._Q_001_F_006, T2._Fld23807, T4._Description, COALESCE(CAST(T3._Q_001_F_002 AS NUMERIC(10, 0)),CAST(0 AS NUMERIC)), T2._Fld23802, T1._Q_001_F_009 FROM pg_temp.tt158 T1 LEFT OUTER JOIN _InfoRg23801 T2 ON ((CASE WHEN T1._Q_001_F_008RRef IS NOT NULL THEN '\\010'::bytea END = T2._Fld23805_TYPE AND CASE WHEN T1._Q_001_F_008RRef IS NOT NULL THEN '\\000\\000\\001\\013'::bytea END = T2._Fld23805_RTRef AND T1._Q_001_F_008RRef = T2._Fld23805_RRRef)) AND (T2._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN pg_temp.tt160 T3 ON ((T1._Q_001_F_000TRef = CASE WHEN T3._Q_001_F_000RRef IS NOT NULL THEN '\\000\\000\\001\\274'::bytea END AND T1._Q_001_F_000RRef = T3._Q_001_F_000RRef) AND (T1._Q_001_F_001RRef = T3._Q_001_F_001RRef)) LEFT OUTER JOIN _Reference267 T4 ON (T1._Q_001_F_008RRef = T4._IDRRef) AND (T4._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference169 T5 ON (T1._Q_001_F_001RRef = T5._IDRRef) AND (T5._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference183 T6 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\267'::bytea AND T2._Fld23805_RRRef = T6._IDRRef) AND (T6._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference192 T7 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\300'::bytea AND T2._Fld23805_RRRef = T7._IDRRef) AND (T7._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25641 T8 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000d)'::bytea AND T2._Fld23805_RRRef = T8._IDRRef) AND (T8._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference274 T9 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\022'::bytea AND T2._Fld23805_RRRef = T9._IDRRef) AND (T9._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference249 T10 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\371'::bytea AND T2._Fld23805_RRRef = T10._IDRRef) AND (T10._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference294 T11 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001&'::bytea AND T2._Fld23805_RRRef = T11._IDRRef) AND (T11._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24509 T12 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000_\\275'::bytea AND T2._Fld23805_RRRef = T12._IDRRef) AND (T12._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference176 T13 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\260'::bytea AND T2._Fld23805_RRRef = T13._IDRRef LEFT OUTER JOIN _Reference23370 T14 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[J'::bytea AND T2._Fld23805_RRRef = T14._IDRRef) AND (T14._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24963 T15 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000a\\203'::bytea AND T2._Fld23805_RRRef = T15._IDRRef) AND (T15._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference257 T16 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\001'::bytea AND T2._Fld23805_RRRef = T16._IDRRef) AND (T16._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25550 T17 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000c\\316'::bytea AND T2._Fld23805_RRRef = T17._IDRRef) AND (T17._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference253 T18 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\375'::bytea AND T2._Fld23805_RRRef = T18._IDRRef) AND (T18._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference137 T19 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\211'::bytea AND T2._Fld23805_RRRef = T19._IDRRef) AND (T19._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference68 T20 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000D'::bytea AND T2._Fld23805_RRRef = T20._IDRRef) AND (T20._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23372 T21 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[L'::bytea AND T2._Fld23805_RRRef = T21._IDRRef) AND (T21._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference118 T22 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000v'::bytea AND T2._Fld23805_RRRef = T22._IDRRef) AND (T22._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference114 T23 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000r'::bytea AND T2._Fld23805_RRRef = T23._IDRRef) AND (T23._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference75 T24 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000K'::bytea AND T2._Fld23805_RRRef = T24._IDRRef) AND (T24._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference177 T25 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\261'::bytea AND T2._Fld23805_RRRef = T25._IDRRef) AND (T25._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference155 T26 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\233'::bytea AND T2._Fld23805_RRRef = T26._IDRRef) AND (T26._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference131 T27 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\203'::bytea AND T2._Fld23805_RRRef = T27._IDRRef) AND (T27._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference163 T28 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\243'::bytea AND T2._Fld23805_RRRef = T28._IDRRef) AND (T28._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference169 T29 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\251'::bytea AND T2._Fld23805_RRRef = T29._IDRRef) AND (T29._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference145 T30 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\221'::bytea AND T2._Fld23805_RRRef = T30._IDRRef) AND (T30._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference291 T31 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001#'::bytea AND T2._Fld23805_RRRef = T31._IDRRef LEFT OUTER JOIN _Reference305 T32 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0011'::bytea AND T2._Fld23805_RRRef = T32._IDRRef) AND (T32._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference115 T33 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000s'::bytea AND T2._Fld23805_RRRef = T33._IDRRef) AND (T33._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference94 T34 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000^'::bytea AND T2._Fld23805_RRRef = T34._IDRRef) AND (T34._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference280 T35 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\030'::bytea AND T2._Fld23805_RRRef = T35._IDRRef) AND (T35._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference266 T36 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\012'::bytea AND T2._Fld23805_RRRef = T36._IDRRef) AND (T36._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference67 T37 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000C'::bytea AND T2._Fld23805_RRRef = T37._IDRRef) AND (T37._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference321 T38 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001A'::bytea AND T2._Fld23805_RRRef = T38._IDRRef LEFT OUTER JOIN _Reference182 T39 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\266'::bytea AND T2._Fld23805_RRRef = T39._IDRRef) AND (T39._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25281 T40 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000b\\301'::bytea AND T2._Fld23805_RRRef = T40._IDRRef) AND (T40._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference27359 T41 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000j\\337'::bytea AND T2._Fld23805_RRRef = T41._IDRRef) AND (T41._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference306 T42 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0012'::bytea AND T2._Fld23805_RRRef = T42._IDRRef) AND (T42._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference196 T43 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\304'::bytea AND T2._Fld23805_RRRef = T43._IDRRef) AND (T43._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference190 T44 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\276'::bytea AND T2._Fld23805_RRRef = T44._IDRRef) AND (T44._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference86 T45 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000V'::bytea AND T2._Fld23805_RRRef = T45._IDRRef) AND (T45._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference320 T46 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001@'::bytea AND T2._Fld23805_RRRef = T46._IDRRef) AND (T46._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference205 T47 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\315'::bytea AND T2._Fld23805_RRRef = T47._IDRRef LEFT OUTER JOIN _Reference297 T48 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001)'::bytea AND T2._Fld23805_RRRef = T48._IDRRef) AND (T48._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference223 T49 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\337'::bytea AND T2._Fld23805_RRRef = T49._IDRRef) AND (T49._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference258 T50 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\002'::bytea AND T2._Fld23805_RRRef = T50._IDRRef) AND (T50._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference302 T51 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001.'::bytea AND T2._Fld23805_RRRef = T51._IDRRef LEFT OUTER JOIN _Reference24704 T52 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000`\\200'::bytea AND T2._Fld23805_RRRef = T52._IDRRef) AND (T52._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference191 T53 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\277'::bytea AND T2._Fld23805_RRRef = T53._IDRRef) AND (T53._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference92 T54 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\\\'::bytea AND T2._Fld23805_RRRef = T54._IDRRef) AND (T54._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference329 T55 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001I'::bytea AND T2._Fld23805_RRRef = T55._IDRRef) AND (T55._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference44 T56 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000,'::bytea AND T2._Fld23805_RRRef = T56._IDRRef) AND (T56._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference245 T57 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\365'::bytea AND T2._Fld23805_RRRef = T57._IDRRef) AND (T57._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference227 T58 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\343'::bytea AND T2._Fld23805_RRRef = T58._IDRRef) AND (T58._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference78 T59 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000N'::bytea AND T2._Fld23805_RRRef = T59._IDRRef) AND (T59._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25120 T60 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000b '::bytea AND T2._Fld23805_RRRef = T60._IDRRef) AND (T60._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference313 T61 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0019'::bytea AND T2._Fld23805_RRRef = T61._IDRRef) AND (T61._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference51 T62 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0003'::bytea AND T2._Fld23805_RRRef = T62._IDRRef) AND (T62._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference98 T63 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000b'::bytea AND T2._Fld23805_RRRef = T63._IDRRef) AND (T63._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference243 T64 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\363'::bytea AND T2._Fld23805_RRRef = T64._IDRRef) AND (T64._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25629 T65 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000d\\035'::bytea AND T2._Fld23805_RRRef = T65._IDRRef) AND (T65._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference24572 T66 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000_\\374'::bytea AND T2._Fld23805_RRRef = T66._IDRRef) AND (T66._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference47 T67 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000/'::bytea AND T2._Fld23805_RRRef = T67._IDRRef) AND (T67._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23375 T68 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[O'::bytea AND T2._Fld23805_RRRef = T68._IDRRef) AND (T68._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference27053 T69 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000i\\255'::bytea AND T2._Fld23805_RRRef = T69._IDRRef) AND (T69._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference255 T70 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\377'::bytea AND T2._Fld23805_RRRef = T70._IDRRef) AND (T70._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference113 T71 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000q'::bytea AND T2._Fld23805_RRRef = T71._IDRRef) AND (T71._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference247 T72 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\367'::bytea AND T2._Fld23805_RRRef = T72._IDRRef) AND (T72._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference309 T73 ON T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0015'::bytea AND T2._Fld23805_RRRef = T73._IDRRef LEFT OUTER JOIN _Reference283 T74 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001\\033'::bytea AND T2._Fld23805_RRRef = T74._IDRRef) AND (T74._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference100 T75 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000d'::bytea AND T2._Fld23805_RRRef = T75._IDRRef) AND (T75._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference213 T76 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\325'::bytea AND T2._Fld23805_RRRef = T76._IDRRef) AND (T76._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference107 T77 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000k'::bytea AND T2._Fld23805_RRRef = T77._IDRRef) AND (T77._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference308 T78 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0014'::bytea AND T2._Fld23805_RRRef = T78._IDRRef) AND (T78._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference322 T79 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001B'::bytea AND T2._Fld23805_RRRef = T79._IDRRef) AND (T79._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference23367 T80 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000[G'::bytea AND T2._Fld23805_RRRef = T80._IDRRef) AND (T80._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference303 T81 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001/'::bytea AND T2._Fld23805_RRRef = T81._IDRRef) AND (T81._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference103 T82 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000g'::bytea AND T2._Fld23805_RRRef = T82._IDRRef) AND (T82._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference58 T83 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000:'::bytea AND T2._Fld23805_RRRef = T83._IDRRef) AND (T83._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference25485 T84 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000c\\215'::bytea AND T2._Fld23805_RRRef = T84._IDRRef) AND (T84._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference197 T85 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\305'::bytea AND T2._Fld23805_RRRef = T85._IDRRef) AND (T85._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference121 T86 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000y'::bytea AND T2._Fld23805_RRRef = T86._IDRRef) AND (T86._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference199 T87 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\307'::bytea AND T2._Fld23805_RRRef = T87._IDRRef) AND (T87._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference328 T88 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\001H'::bytea AND T2._Fld23805_RRRef = T88._IDRRef) AND (T88._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference141 T89 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\215'::bytea AND T2._Fld23805_RRRef = T89._IDRRef) AND (T89._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference26181 T90 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000fE'::bytea AND T2._Fld23805_RRRef = T90._IDRRef) AND (T90._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference198 T91 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000\\306'::bytea AND T2._Fld23805_RRRef = T91._IDRRef) AND (T91._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference124 T92 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\000|'::bytea AND T2._Fld23805_RRRef = T92._IDRRef) AND (T92._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference311 T93 ON (T2._Fld23805_TYPE = '\\010'::bytea AND T2._Fld23805_RTRef = '\\000\\000\\0017'::bytea AND T2._Fld23805_RRRef = T93._IDRRef) AND (T93._Fld954 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference270 T94; | |
1 | Can Lasix Cause Dehydration |