SELECT
T9._IDRRef,
T9._Marked,
CASE WHEN T9._PredefinedID > '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea THEN TRUE ELSE FALSE END,
CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN '\\001'::bytea END,
CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN T10._Fld6001RRef WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea END,
T9._Fld669RRef,
T9._Fld670RRef,
T9._Fld5993RRef,
T9._Fld671,
T9._Fld672,
T9._Code,
T9._Description,
T9._Fld5994,
T9._Fld707RRef
FROM _Reference5975 T9
LEFT OUTER JOIN _Reference5975_VT5998 T10
ON ((T10._Reference5975_IDRRef = T9._IDRRef) AND (T10._Fld6000RRef = '\\243\\245\\000PV\\001\\014*\\021\\355{\\035\\215\\340\\202R'::bytea) AND (T10._Fld6003 = FALSE)) AND (T10._Fld313 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference82 T11
ON (T10._Fld6001RRef = T11._IDRRef) AND (T11._Fld313 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference113 T12
ON (T9._Fld669RRef = T12._IDRRef) AND (T12._Fld313 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference113 T13
ON (T9._Fld670RRef = T13._IDRRef) AND (T13._Fld313 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference73 T14
ON (T9._Fld5993RRef = T14._IDRRef) AND (T14._Fld313 = CAST(0 AS NUMERIC))
LEFT OUTER JOIN _Reference141 T15
ON (T9._Fld707RRef = T15._IDRRef) AND (T15._Fld313 = CAST(0 AS NUMERIC))
WHERE (((T9._Fld313 = CAST(0 AS NUMERIC))) AND (T9._IDRRef IN
(SELECT
T16._Reference5975_IDRRef AS Q_001_F_000RRef
FROM _Reference5975_VT6004 T16
WHERE ((T16._Fld313 = CAST(0 AS NUMERIC))) AND ((T16._Fld6006RRef = '\\243\\250\\000PV\\001\\014*\\021\\355\\202\\314k\\007\\342q'::bytea) AND (T16._Fld6007_TYPE = '\\005'::bytea AND T16._Fld6007_L = FALSE AND T16._Fld6007_N = CAST(0 AS NUMERIC) AND T16._Fld6007_T = '0001-01-01 00:00:00'::timestamp AND (T16._Fld6007_S)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar AND T16._Fld6007_RTRef = '\\000\\000\\000\\000'::bytea AND T16._Fld6007_RRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea))) OR ((CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN CASE WHEN T11._Description IS NOT NULL THEN '\\005'::bytea END WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN '\\001'::bytea END = '\\005'::bytea AND (CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN T11._Description WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN ''::mvarchar END)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR (CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN CASE WHEN T11._Fld1196 IS NOT NULL THEN '\\005'::bytea END WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN '\\001'::bytea END = '\\005'::bytea AND (CASE WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000R'::bytea) THEN T11._Fld1196 WHEN (CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\010'::bytea END = '\\001'::bytea AND CASE WHEN T10._Fld6001RRef IS NOT NULL THEN '\\000\\000\\000R'::bytea END = '\\000\\000\\000\\000'::bytea AND T10._Fld6001RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) THEN ''::mvarchar END)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar)) OR ((T9._Code)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T9._Description)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T12._Description)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T13._Description)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T14._Fld1105)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T9._Fld5994)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar) OR ((T15._Description)::mvarchar LIKE '%ном%'::mvarchar ESCAPE '/'::mvarchar))) AND T9._Code < '0000000092'::mvarchar
ORDER BY (T9._Code) DESC, (T9._IDRRef) DESC LIMIT 35