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