Details
Description
The current query for showing events in the dashboard event summary is not ideal. ORDER BY is end_date DESC with limit 10. We should ORDER BY start_date ASC so current and upcoming events float to the top. The WHERE clause should include events where start date is greater than 7 days ago - so we catch events which have just completed and events which are coming up soon.