This query is awful! It joins five tables, has a couple of subqueries and hardcoded values so that the query needs to hard-parsed on very call.
That said: I was foolish enough to pick up calendar maintainership :) I'm currently haggling with the tcl procs that generate html.
The datamodel is quite broken, so are the queries. (Read the comments, they are fairly funny). It'll take some time for me to correct this though.
If you are willing to help me, my first question would be: Wtf is time_spans and time_intervals and why is being used in this d?mned calendar?
