Yep, I used http://sqlinform.com/ to format it. You can peep it at http://theninjalist.com/.

Heh. Yeah. I honestly don't know why they need such complex queries. I just ran into it when I took another guys' position. I finally...

And to have it narrowed down further, here's the distinct subquery with the issue:

SELECT a.company_id,

a.payee_id,

...

Alright, but you won't like it. I was trying to keep it simple looking so I'd get more replies. :p To be honest, I'd really be okay...