>SELECT Temp.NoThread, (SELECT COUNT(*) FROM Thread WHERE NoThread = Temp.NoThread) >FROM >(SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp >