Reason for change
Change query to take into account database schema changes introduced by ISOC release 4.4.
These changes caused the production application to either hang or crash.
Additional small fixes have also been added.
Test Procedure
The new query has been tested on the development server.
Rollback procedure
Version 0.1.1 can be easily put back in place.