exec sp_executesql N'SELECT TOP 35
T4._IDRRef,
T4._Marked,
T4._IsMetadata,
CASE WHEN (T4._Folder = 0x00) THEN 0x01 ELSE 0x00 END,
T4._Code,
T4._Description,
T4._Fld1317RRef,
T4._Fld1318,
T4._Fld1319,
T4._Fld1322,
T4._Fld5621RRef,
ISNULL(T6._Fld4793RRef,@P1),
ISNULL(T5._Fld5225RRef,@P2)
FROM _Reference97 T4 WITH(NOLOCK)
LEFT OUTER JOIN _BPr5192 T5 WITH(NOLOCK)
ON ((0x08 = T5._Fld5216_TYPE AND @P3 = T5._Fld5216_RTRef AND T4._IDRRef = T5._Fld5216_RRRef)) AND (T5._Fld327 = 0.0)
LEFT OUTER JOIN _InfoRg4791 T6 WITH(NOLOCK)
ON ((0x08 = T6._Fld4792_TYPE AND @P4 = T6._Fld4792_RTRef AND T4._IDRRef = T6._Fld4792_RRRef)) AND (T6._Fld327 = 0.0)
WHERE (T4._Fld327 = 0.0) AND T4._Description < @P5
ORDER BY (T4._Description) DESC, (T4._IDRRef) DESC
OPTION (FAST 1)',N'@P1 varbinary(16),@P2 varbinary(16),@P3 varbinary(4),@P4 varbinary(4),@P5 nvarchar(4000)',0x00000000000000000000000000000000,0x00000000000000000000000000000000,0x00000061,0x00000061,N'Астрахань'
go