So you can avoid this c**p:
That is a segment from a 114 line SQL statement, JOINing across 9 tables!
Whenever a developer has to change this, he or she must
test (externally), the recompile the Class, rebuild the war, and redeploy.
Besides the minimal performance hit, storing SQL in XML will give you (if you do it right), tools like myBatis can really help.
WP