OSTicket Ambil daftar tiket dan siapa yang meminta

osticket_daftar.sql

select tt.created, tt.number, ht.topic, tc.subject, ts.name as 'STATUS', u.name, uc.phone, ue.address from ost_thread t 
inner join ost_ticket tt on t.id = tt.ticket_id
inner join ost_ticket__cdata tc on tc.ticket_id = tt.ticket_id
inner join ost_ticket_status ts on ts.id = tt.status_id
inner join ost_user u on tt.user_id = u.id
inner join ost_user__cdata uc on uc.user_id = u.id
inner join ost_user_email ue on ue.user_id = u.id
inner join ost_help_topic ht on ht.topic_id = tt.topic_id
where t.object_type = 'T' 
-- and tt.number = 506581
-- and year(tt.created) >= 2020
order by t.created desc