>Your order by here is strange. I would probably re-write the whole query as
>

>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) X 
>where Row <=10

I do not understand why it would be strange. The 10 records I need to select from Reply are subject to a specific order. To me, this is the clean way to do it.