We did infrastructural changes to provide more object oriented approach and to maintain both SQL (native) and HQL (nhibernate). Implemented native SQL query for itembox query.

There is a parameter with id 394 (DatabaseQueryMode) to switch between SQL/HQL.