doesn't it appear from the volume of code in your solution that it is not optimal. It's clearly like using a sledge hammer to crush a walnut. In the real world no one would bear the overhead of this solution when the others on the page do the same thing without creating tables and certainly without that last join step.

SQL is a non-procedural language, your solution is completely procedural.