Ok, first of all, Coldfusion's query of a query does not perform very efficiently and should probably be avoided if possible.
I believe you can simplify your code a great deal. Since both of your database queries are in the same datasource, you can do everything in one <cfquery>
To start, try...