I'll need to try to sanitize the query really quickly as the company is quite paranoid about security and information control, but it's basically a very simple query with some outer joins against drop down fields just to produce human readable output. The right joined tables are very small and don't appreciably affect performance if they are removed.