select
 d.*
from
 (
  select top (50)
   a.PK
  from
   Content.Table1 a inner loop join 
   containstable(Content.Table1, Title, 'Main') b on b.[KEY] = a.PK
  order by
   a.StartDate desc
 ) c join
 Content.Table1 d on d.PK = c.PK

alter table add TitleWithRecordAge as Title + ' RecordAge:' + cast(datediff(day, getdate(), '99991231') as varchar(10))

create function dbo.fnGetMatchedByDate
(
 @SearchString varchar(100),
 @Date date
)
returns @result table (PK int primary key)
as
begin
 select @SearchString = @SearchString + ' and ' + cast(datediff(day, @Date, '99991231') as varchar(10));

 insert inot @result
  (PK)
  select [KEY] from containstable(Content.Table1, TitleWithRecordAge, @SearchString);

 return;
end;

select
 d.*
from
 (
  select top (50)
   b.PK
  from
   [Таблица чисел] a cross apply 
   dbo.fnGetMatchedByDate('Main', dateadd(day, a.Число, getdate()) b
 ) c join
 Content.Table1 d on d.PK = c.PK