MySQL: get daily count of items which have a start_date and an end_date I do have tours in a table which do have a start date and an end date, e.g.
