Which tables stores the ticket age? I am interesting in the closing time and how long the ticket stayed in the queue. I tried time_accountiung and ticket_history. mysql> select * from time_accounting where ticket_id=197; +----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+ | id | ticket_id | article_id | time_unit | create_time | create_by | change_time | change_by | +----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+ | 64 | 197 | 472 | 1 | 2004-08-13 10:30:55 | 10 | 2004-08-13 10:30:55 | 10 | +----+-----------+------------+-----------+---------------------+-----------+---------------------+-----------+ 1 row in set (0.00 sec) mysql> select id, ticket_id, create_time, change_time from ticket_history where id=1815; +------+-----------+---------------------+---------------------+ | id | ticket_id | create_time | change_time | +------+-----------+---------------------+---------------------+ | 1815 | 197 | 2004-08-12 11:42:58 | 2004-08-12 11:42:58 | +------+-----------+---------------------+---------------------+