@srkirkland any reason you are using left outer joins?  I'm pretty sure you can use inner joins which are usually much faster.