OTRS Query

otrs.sql

/* Today */

select q.name AS queue_name, COUNT(*) AS Tickets
FROM    queue AS q, ticket AS t, article AS a, article_type AS a_t, (
            SELECT  _a.ticket_id, MAX(_a.create_time) AS create_time
            FROM    ticket AS _t, ticket_state AS _t_s, article AS _a
            WHERE   _t_s.name IN ('new', 'open', 'Vendor Assigned', 'Research, Escalated')
            AND     _t.ticket_state_id = _t_s.id
            AND     _a.ticket_id = _t.id
            GROUP   BY _a.ticket_id
        ) a_max
WHERE   q.id = t.queue_id
AND     t.id = a_max.ticket_id
AND     a.create_time = a_max.create_time
AND     a_t.id = a.article_type_id
GROUP   BY q.name
ORDER   BY Tickets DESC

Hello, thanks for sharing this querie, it is a good example for my future queries.
You could share more queries?

YOUr query is too sloww