updated query in method _getOfferingsForCalendarWithinDateRange() to account for recent schema changes to offering_x_* JOIN tables.