Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- T1._IDRRef
- FROM _Reference61 T1
- LEFT OUTER JOIN _Reference93 T2
- ON T1._OwnerIDRRef = T2._IDRRef
- LEFT OUTER JOIN (SELECT
- T4._IDRRef AS IDRRef,
- T4._Fld1373RRef AS Fld1373RRef,
- T4._Fld1383RRef AS Fld1383RRef,
- T4._Fld1389RRef AS Fld1389RRef
- FROM _Reference61 T4
- WHERE (EXISTS(SELECT
- 1
- FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
- LEFT OUTER JOIN (SELECT DISTINCT
- T6._Reference55_IDRRef AS Q_001_F_000RRef
- FROM _Reference55_VT1346 T6
- WHERE (T6._Fld1348RRef = '\\230\\231\\000"\\025\\241\\351g\\021\\342p/\\017\\277i\\333'::bytea)) T5
- ON 1=1
- WHERE (NOT ((T5.Q_001_F_000RRef IS NULL))) AND (NOT ((EXISTS(SELECT
- 1 AS Q_002_F_000_
- FROM _InfoRg20490 T7
- LEFT OUTER JOIN _InfoRg20507 T8
- ON ((((T8._Fld20508_TYPE = CASE WHEN CASE WHEN (T7._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T4._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END IS NOT NULL THEN '\\010'::bytea END AND T8._Fld20508_RTRef = CASE WHEN CASE WHEN (T7._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T4._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END IS NOT NULL THEN '\\000\\000\\000y'::bytea END AND T8._Fld20508_RRRef = CASE WHEN (T7._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T4._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END) AND (T8._Fld20509RRef = T7._Fld20492RRef)) AND (T8._Fld20510RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea)) AND (T8._Fld20511RRef = T5.Q_001_F_000RRef))
- WHERE (T7._Fld20491RRef = T5.Q_001_F_000RRef) AND (T7._Fld20492RRef IN ('\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea, '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea)) AND T8._Fld20508_TYPE IS NULL AND T8._Fld20508_RTRef IS NULL AND T8._Fld20508_RRRef IS NULL))))))) T3
- ON T2._Fld1576RRef = T3.IDRRef
- WHERE ((EXISTS(SELECT
- 1
- FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
- LEFT OUTER JOIN (SELECT DISTINCT
- T10._Reference55_IDRRef AS Q_001_F_000RRef
- FROM _Reference55_VT1346 T10
- WHERE (T10._Fld1348RRef = '\\230\\231\\000"\\025\\241\\351g\\021\\342p/\\017\\277i\\333'::bytea)) T9
- ON 1=1
- WHERE (NOT ((T9.Q_001_F_000RRef IS NULL))) AND (NOT ((EXISTS(SELECT
- 1 AS Q_002_F_000_
- FROM _InfoRg20490 T11
- LEFT OUTER JOIN _InfoRg20507 T12
- ON ((((T12._Fld20508_TYPE = CASE WHEN CASE WHEN (T11._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T1._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END IS NOT NULL THEN '\\010'::bytea END AND T12._Fld20508_RTRef = CASE WHEN CASE WHEN (T11._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T1._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END IS NOT NULL THEN '\\000\\000\\000y'::bytea END AND T12._Fld20508_RRRef = CASE WHEN (T11._Fld20492RRef = '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea) THEN COALESCE(T1._Fld1383RRef,'\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) END) AND (T12._Fld20509RRef = T11._Fld20492RRef)) AND (T12._Fld20510RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea)) AND (T12._Fld20511RRef = T9.Q_001_F_000RRef))
- WHERE (T11._Fld20491RRef = T9.Q_001_F_000RRef) AND (T11._Fld20492RRef IN ('\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea, '\\220\\235\\000^L\\257.\\215G,\\007\\323\\015\\235@\\257'::bytea)) AND T12._Fld20508_TYPE IS NULL AND T12._Fld20508_RTRef IS NULL AND T12._Fld20508_RRRef IS NULL))))))) AND ((T1._Marked = FALSE) AND (T1._Fld1383RRef = '\\217\\247\\000\\025\\203\\263\\331\\016\\021\\334\\270\\374\\263O\\350\\010'::bytea) AND (T1._OwnerIDRRef = '\\224-\\000\\026\\324\\031Tx\\021\\334\\264ob\\246\\221^'::bytea) AND (T1._Fld1389RRef IN ('\\271%\\335\\370\\205\\031$eE\\030{\\333VT\\230\\003'::bytea, '\\226:Hw\\310\\342\\236\\265B\\221\\220.Y\\004!\\221'::bytea)) AND (T1._Fld1373RRef IN ('\\244\\031\\355\\015`WP\\374Dw\\250\\010\\253\\020D\\005'::bytea, '\\222.\\275\\351\\002\\037J\\024O\\210q6r/\\370\\023'::bytea)) AND CASE WHEN (((T3.Fld1383RRef = '\\217\\247\\000\\025\\203\\263\\331\\016\\021\\334\\270\\374\\263O\\350\\010'::bytea) AND (T3.Fld1389RRef IN ('\\271%\\335\\370\\205\\031$eE\\030{\\333VT\\230\\003'::bytea, '\\226:Hw\\310\\342\\236\\265B\\221\\220.Y\\004!\\221'::bytea))) AND (T3.Fld1373RRef IN ('\\244\\031\\355\\015`WP\\374Dw\\250\\010\\253\\020D\\005'::bytea, '\\222.\\275\\351\\002\\037J\\024O\\210q6r/\\370\\023'::bytea))) THEN CASE WHEN (T1._IDRRef = T2._Fld1576RRef) THEN TRUE WHEN NOT (T1._IDRRef = T2._Fld1576RRef) THEN FALSE END ELSE CASE WHEN (T1._IDRRef <> T2._Fld1576RRef) THEN TRUE WHEN NOT (T1._IDRRef <> T2._Fld1576RRef) THEN FALSE END END = TRUE) LIMIT 2
Advertisement
Add Comment
Please, Sign In to add comment