explain SELECT COUNT(DISTINCT main.id) FROM Tickets main
      JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) 
      JOIN CachedGroupMembers CachedGroupMembers_18  ON (CachedGroupMembers_18.GroupId = Groups_1.id ) 
 LEFT JOIN Users Users_3  ON ( Users_3.id = CachedGroupMembers_18.MemberId )
WHERE
(  main.Status != 'deleted' )
AND (
      main.Created > '2010-08-31 14:00:00'
      AND (
            ( Users_3.EmailAddress = 'user1@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user2@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user3@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user4@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user5@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user6@redhat.com' )  
        OR  ( Users_3.EmailAddress = 'user7@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user8@redhat.com' )
        OR  ( Users_3.EmailAddress = 'user9@redhat.com' )
    )
)
AND (main.Type = 'ticket')
AND (main.EffectiveId = main.id)
;
