www.infinidb.org

SELECT COUNT(UserID), AccountID,UserID, PolicyID,RemoteHost,Categories
 FROM wdsummaries 
WHERE AccountID=6692 AND Categories LIKE '%2381%' 
GROUP BY AccountID,UserID, PolicyID,RemoteHost,Categories 
ORDER BY AccountID;

CREATE TABLE wdSummaries (
  ID BIGINT,
  Proxy char(15) ,
  Minute BIGINT   ,
  Period BIGINT,
  AccountID BIGINT,
  PolicyID BIGINT  ,
  PrimaryGroupID BIGINT  ,
  UserID BIGINT  ,
  BandwidthDelay BIGINT  ,
  ClientIP BIGINT  ,
  Disposition CHAR(20),
  FirstTime bigint  ,
  GetTime BIGINT  ,
  LastTime bigint  ,
  RequestCount BIGINT   ,
  RequestFilterTime BIGINT  ,
  ResponseFilterTime BIGINT  ,
  RequestSize BIGINT   ,
  ResponseSize BIGINT  ,
  TotalTime BIGINT  ,
  WriteTime BIGINT  ,
  Categories char(255),
  Groups char(255) ,
  RemoteHost char(255),
  Rule char(255) ,
  VirusName char(255) 
) ENGINE=InfiniDB DEFAULT CHARSET=utf8;

                ID: 1
             Proxy: prx01h
            Minute: 20832240
            Period: 1
         AccountID: 6692
          PolicyID: 5511
    PrimaryGroupID: NULL
            UserID: NULL
    BandwidthDelay: NULL
          ClientIP: 207069050
       Disposition: auth
         FirstTime: 1249934371192
           GetTime: NULL
          LastTime: 1249934371193
      RequestCount: 1
 RequestFilterTime: 0
ResponseFilterTime: NULL
       RequestSize: 564
      ResponseSize: NULL
         TotalTime: NULL
         WriteTime: NULL
        Categories: NULL
            Groups: NULL
        RemoteHost: images-l3.technoratimedia.com
              Rule: NULL
         VirusName: NULL