column alias works in MySQL, but not in cfoutput

I have the attached query that works fine in MySQL, but throws an error "1stpay not a valid identifier name" - like it doesn't recognize the aliases. However, it's recognizing my 2 aliases above. So is it the "if" lines that it's not liking? Ultimately, I'd like to also create a column that adds the values in "1stpay" and "2ndpay", but haven't figured that one out yet in MySQL.

Thanks,
Richard