I've seen FAR worse
We have a "select" that runs once a month. It takes about 10 hours to run. We call it the "query of death".
It joins together about 100 tables right now. Every month a couple more added.
No, I didn't write it. Not my dept anymore.
Phew.