MySql Query for All Calendar items

[Bendetta]

Long story short, I'm trying to write a SQL query to select ALL the appointments, but based on how the databases are split up into the mailbox groups, I'm not quite sure how I'd accomplish this. It has to be done with a query because of our analytics software that will be connecting to it.

Does anyone have an idea on how I'd do this, or if you can point me in the right direction it'd be greatly appreciated. Thanks.

[phoenix]

Is this what you're looking for: Account mailbox database structure - Zimbra :: Wiki

[Bendetta]

That's close to what I'm looking for, but not quite there. I can't figure out though how I'd actually query for all calendar events at once though. With some events being on mboxgroup1 through mboxgroup99, I don't know how I'd do a
SELECT * FROM mboxgroups.appointment WHERE type = 11;

without doing SELECT * FROM mboxgroup1.appointment, mboxgroup2.appointment, ... mboxgroup99.appointment;