exec sp_executesql N'SELECT DISTINCT
T1._IDRRef,
T1._IDRRef,
T3._Description,
1.0,
CASE WHEN (0x08 = 0x01) THEN T4._Description ELSE T5._Description END,
T1._Description,
CASE WHEN (0x08 = 0x01) THEN T2._Fld9309 ELSE -1.0 END,
T1._Fld1895,
@P1,
T1._Marked
FROM _Reference92 T1 WITH(NOLOCK)
INNER JOIN _InfoRg9306 T2 WITH(NOLOCK)
ON (T1._Fld1899RRef = T2._Fld9308RRef)
LEFT OUTER JOIN _Reference92 T3 WITH(NOLOCK)
ON (T1._IDRRef = T3._IDRRef) AND (T3._Fld547 = 0.0)
LEFT OUTER JOIN _Reference114 T4 WITH(NOLOCK)
ON (T2._Fld9308RRef = T4._IDRRef) AND (T4._Fld547 = 0.0)
LEFT OUTER JOIN _Reference114 T5 WITH(NOLOCK)
ON (T1._Fld1899RRef = T5._IDRRef) AND (T5._Fld547 = 0.0)
WHERE (((T1._Fld547 = 0.0)) AND (T2._Fld547 = 0.0)) AND ((T1._Description LIKE @P2))
UNION ALL SELECT
T6._IDRRef,
T6._IDRRef,
T8._Description,
2.0,
CASE WHEN (0x08 = 0x01) THEN T9._Description ELSE T10._Description END,
T6._Description,
CASE WHEN (0x08 = 0x01) THEN T7._Fld9309 ELSE -1.0 END,
T6._Fld1895,
CAST(@P3 AS NVARCHAR(15)),
T6._Marked
FROM _Reference92 T6 WITH(NOLOCK)
INNER JOIN _InfoRg9306 T7 WITH(NOLOCK)
ON (T6._Fld1899RRef = T7._Fld9308RRef)
LEFT OUTER JOIN _Reference92 T8 WITH(NOLOCK)
ON (T6._IDRRef = T8._IDRRef) AND (T8._Fld547 = 0.0)
LEFT OUTER JOIN _Reference114 T9 WITH(NOLOCK)
ON (T7._Fld9308RRef = T9._IDRRef) AND (T9._Fld547 = 0.0)
LEFT OUTER JOIN _Reference114 T10 WITH(NOLOCK)
ON (T6._Fld1899RRef = T10._IDRRef) AND (T10._Fld547 = 0.0)
WHERE (((T6._Fld547 = 0.0)) AND (T7._Fld547 = 0.0)) AND ((T6._Fld1895 LIKE @P4))
ORDER BY 10, 7 DESC',N'@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000)',N'По наименованию',N'17289%',N'По ИНН',N'17289%'