AOBSqlCommand.CommandText = "select [t1].[id], [t1].[name] from [evgames] [t1] where [t1].[evtype] in (";
                
int ii;

string ParamName = "";

for (ii =  0 ; ii < EventsTypeArray.Count; ii++)
{
  if (ii >  0 )
    AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + ", ";
  ParamName = "@evtype_" + Convert.ToString(ii);
  AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + ParamName;
  AOBSqlCommand.Parameters.Add(ParamName, OleDbType.Integer,  4 ).Value = (Int32) (EventsTypeArray[ii]);
}

AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + ", 0) and [t1].[id] in (select [t2].[evgame] from [events] [t2] where ([t2].[evdate] + [t2].[evtime]) > @currenttime and [t1].[evtype] = [t2].[evtype]) order by [t1].[name]";

AOBSqlCommand.Parameters.Add("@currenttime", OleDbType.Date).Value = DateTime.UtcNow.AddHours( 3 );

AOBSqlCommand.CommandText = "select [t1].[id], [t1].[name] from [evgames] [t1] where [t1].[evtype] in (";
                
int ii;

string ParamName = "";

for (ii =  0 ; ii < EventsTypeArray.Count; ii++)
{
  if (ii >  0 )
    AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + ", ";
  AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + Convert.ToString((Int32)EventsTypeArray[ii]);
}

AOBSqlCommand.CommandText = AOBSqlCommand.CommandText + ", 0) and [t1].[id] in (select [t2].[evgame] from [events] [t2] where ([t2].[evdate] + [t2].[evtime]) > @currenttime and [t1].[evtype] = [t2].[evtype]) order by [t1].[name]";

AOBSqlCommand.Parameters.Add("@currenttime", OleDbType.Date).Value = DateTime.UtcNow.AddHours( 3 );