ticket list: select related items from db, cache some getters