return this._mediaBugEntityDB.LotteryOffers
                                        .Where(lo => lo.Id == lotteryOfferId)
                                        .SelectMany(lo => lo.LotteryDrawDates)
                                        .Select(ldd => ldd.Lottery)
                                        .GroupBy(s => new { s.Name, s.CreatedBy, s.ModifiedOn})
                                        .Select(g => new
                                                        { g.Key.Name,
                                                          g.Key.CreatedBy,
                                                          g.Key.ModifiedOn,
                                                          TotalDrawDates = g.Count()
                                                        });