// 1.
            var query = from Retailer retailer in context.Retailers
                        join customer in context.Customers on retailer.Customer_Id equals customer.Customer_Id
                        join title in context.Titles on retailer.TitleCode equals title.Code
                        join volume in context.Volumes on title.Title_Id equals volume.Title_Id
                        join address in context.Addresses on customer.Customer_Id equals address.Customer_Id
                        join addressType in context.AddressTypes on address.AddressType_Id equals addressType.AddressType_Id
                        join household in context.Households on address.Household_Id equals household.Household_Id
                        join zip in context.Zips on household.Zip_Id equals zip.Zip_Id
                        join municipality in context.Municipalities on zip.Municipality_Id equals municipality.Municipality_Id
                        join country in context.Countries on household.Country_Id equals country.Country_Id
                        join statistics in context.RetailerDeliveryAggregatedStatistics on
                             new { RetailerNumber = retailer.RetailerNumber, TitleCode = retailer.TitleCode, Date = volume.OnDate } equals
                             new { RetailerNumber = statistics.RetailerNumber, TitleCode = statistics.TitleCode, Date = statistics.Date }
                        where
                        address.IsActivated &&
                        (address.StartDate == null || address.StartDate <= fromDate) &&
                        (address.ExpiryDate == null || address.ExpiryDate >= toDate) &&
                        addressType.Code.Equals("MAIN", StringComparison.CurrentCultureIgnoreCase) &&
                        retailer.TitleCode.Equals(this.exportParameters.TitleCode, StringComparison.CurrentCultureIgnoreCase) &&
                        retailer.ReturnCode.Equals(this.exportParameters.ReturnCode, StringComparison.CurrentCultureIgnoreCase) &&
                        volume.OnDate >= fromDate && volume.OnDate <= toDate
                        orderby retailer.RetailerNumber, statistics.Date
                        select new { retailer, customer, address, addressType, household, municipality, zip, country, statistics, volume };

// 2.
            var query = from Retailer retailer in context.Retailers
                        join customer in context.Customers on retailer.Customer_Id equals customer.Customer_Id
                        join title in context.Titles on retailer.TitleCode equals title.Code
                        join volume in context.Volumes on title.Title_Id equals volume.Title_Id
                        join address in context.Addresses on customer.Customer_Id equals address.Customer_Id
                        join addressType in context.AddressTypes on address.AddressType_Id equals addressType.AddressType_Id
                        join household in context.Households on address.Household_Id equals household.Household_Id
                        join zip in context.Zips on household.Zip_Id equals zip.Zip_Id
                        join municipality in context.Municipalities on zip.Municipality_Id equals municipality.Municipality_Id
                        join country in context.Countries on household.Country_Id equals country.Country_Id
                        join statistics in context.RetailerDeliveryAggregatedStatistics on
                             new { RetailerNumber = retailer.RetailerNumber, TitleCode = retailer.TitleCode, Date = volume.OnDate } equals
                             new { RetailerNumber = statistics.RetailerNumber, TitleCode = statistics.TitleCode, Date = statistics.Date }
                        where
                        address.IsActivated &&
                        (address.StartDate == null || address.StartDate <= fromDate) &&
                        (address.ExpiryDate == null || address.ExpiryDate >= toDate) &&
                        addressType.Code.Equals("MAIN", StringComparison.CurrentCultureIgnoreCase) &&
                        retailer.TitleCode.Equals(this.exportParameters.TitleCode, StringComparison.CurrentCultureIgnoreCase) &&
                        retailer.ReturnCode.Equals(this.exportParameters.ReturnCode, StringComparison.CurrentCultureIgnoreCase) &&
                        statistics.Date >= fromDate && statistics.Date <= toDate
                        orderby retailer.RetailerNumber, statistics.Date
                        select new { retailer, customer, address, addressType, household, municipality, zip, country, statistics, volume };