events = database.prepare("select e.eventDate, l.licenceID, l.externalLicenceNumber," +
      " l.licenceTypeKey," +
      " lo.locationName, lo.locationAddress1," +
      " o.organizationName" +
      " from LotteryEvents e" +