No, because there's nowhere near enough information (and we're hijacking the thread). If you want to discuss that, start a new thread, and read through my 'how to post performance problems' first to see exactly what's needed.

That said, an 'inner select', more properly called a derived table, doesn't minimise the sample. Like a view, the derived table will be unrolled during parsing and exactly how the query is executed depends on the optimiser's choices.