Sql statement for group by order by
I would like to be able to group events together that are on the same day and also continue to date, state, city.
Also if an event spans multiple dates I would like them to display as below as well (Thursday to Sunday event example)
Current SQL ORDER BY eventdate, event_state, event_city ASC");
More info in PM