[otrs] mysql query to get unanswered tickets and oldest ticket

I would like to run a MySQL query that tells me how many unanswered tickets I have in the entire OTRS database and the date of the oldest one. This is so I can insert it into a cgi page I use to check the overall status of my website. Then I dont have to login to OTRS to see if I need to clear it out. I browsed through the tables today and couldnt really figure it out. Any help appreciated.