osTicket: How to Query a Ticket Subject for a Report
osTicket can be a little obtuse. The title of a ticket is hidden in the ticket__cdata table, which by default is ost_ticket__cdata in the subject column.
Take a quick peek and you will see it.
SELECT * FROM ost_ticket__cdata LIMIT 4;
Now, knowing what it is called and where to find it, you can use ost_ticket__cdata in your queries. Notice that there are two underscores together in that table name.