Complex Database query--Help Please

You don't need to use the query builder for everything, just run your query:
https://www.codeigniter.com/user_guide/d...eries.html

It will also be faster, as it dosen't need to be run through some PHP functions on the way.