Issue is twofold:
- The query fetches edits made from 00:00 to 23:59 of the start/end dates, regardless of what time was set in the event settings.
- The timestamps shown on the page are in UTC, not the timezone specified for the event.
More context at T206819#4947149