Hmm, that info is stored in the ot_thread_event table, so something like this might help: (change the table prefix to match your install)SELECT ti.number as ticket_number,te.* FROM `ot_thread_event` teLEFT JOIN ot_thread th ON th.object_id = thread_idLEFT JOIN ot_ticket ti ON ti.ticket_id = th.object_idWHERE ti.ticket_id IS NOT NULLORDER BY te.timestamp DESC