>select * from (select T.Numero, T.Title, T.Url, T.AddDate, row_number() >over (partition by R.NoThread order by R.NoThread) as Row from Thread T LEFT JOIN Reply R on T.NoThread = R.NoThread where T.NoMember = @NoMember) X >where Row <=10 >This query takes very long so I had to stop it. There must be something in it which is not properly performed.