osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
MySQL Query for getting all open tickets
Database structure is quite confusing for me. Can anybody please advise for the correct MySQL query in case to get a list of all open tickets, including all information like title and - if possible - also the ticket body?
Thank you :-)
P.S. It should basically be the same list like when you click on "open tickets" on upper left side.