Guest User

Untitled

a guest
Apr 10th, 2013
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.07 KB | None | 0 0
  1. SELECT
  2. T1._IDRRef
  3. FROM _Reference61 T1
  4. LEFT OUTER JOIN _Reference93 T2
  5. ON T1._OwnerIDRRef = T2._IDRRef
  6. LEFT OUTER JOIN (SELECT
  7. T4._IDRRef AS IDRRef,
  8. T4._Fld1373RRef AS Fld1373RRef,
  9. T4._Fld1383RRef AS Fld1383RRef,
  10. T4._Fld1389RRef AS Fld1389RRef
  11. FROM _Reference61 T4
  12. WHERE (EXISTS(SELECT
  13. 1
  14. FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
  15. LEFT OUTER JOIN (SELECT DISTINCT
  16. T6._Reference55_IDRRef AS Q_001_F_000RRef
  17. FROM _Reference55_VT1346 T6
  18. WHERE (T6._Fld1348RRef = '\\230\\231\\000"\\025\\241\\351g\\021\\342p/\\017\\277i\\333'::bytea)) T5
  19. ON 1=1
  20. WHERE (NOT ((T5.Q_001_F_000RRef IS NULL))) AND (NOT ((EXISTS(SELECT
  21. 1 AS Q_002_F_000_
  22. FROM _InfoRg20490 T7
  23. LEFT OUTER JOIN _InfoRg20507 T8
  24. 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))
  25. 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
  26. ON T2._Fld1576RRef = T3.IDRRef
  27. WHERE ((EXISTS(SELECT
  28. 1
  29. FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
  30. LEFT OUTER JOIN (SELECT DISTINCT
  31. T10._Reference55_IDRRef AS Q_001_F_000RRef
  32. FROM _Reference55_VT1346 T10
  33. WHERE (T10._Fld1348RRef = '\\230\\231\\000"\\025\\241\\351g\\021\\342p/\\017\\277i\\333'::bytea)) T9
  34. ON 1=1
  35. WHERE (NOT ((T9.Q_001_F_000RRef IS NULL))) AND (NOT ((EXISTS(SELECT
  36. 1 AS Q_002_F_000_
  37. FROM _InfoRg20490 T11
  38. LEFT OUTER JOIN _InfoRg20507 T12
  39. 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))
  40. 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