May want to creat a temp table and load the top ten records into that and then run your second query aginst the contents of the temp table.