Hello all, For our customer accouting I'm trying to find all closed tickets in a certain time frame. I can do that, but when I do that I get accounting tickets for every ticket closed. Now I'm trying to find out how I can select only one accounting record for a group that's closed with a bulk action. I already have got: select * from time_accounting, article, ticket, queue where ( queue.name like 'CUST::%' or queue.name = 'CUST' ) and queue.id=ticket.queue_id and time_accounting.ticket_id=ticket.id and time_accounting.article_id=article.id and date(from_unixtime(article.incoming_time)) between '2010-05-01' and last_day('2010-05-01'); Does anyone have any idea how to determine which tickets are closed in a group? Thanks in advance. Cheers, TonK