query: SELECT custom_expedition_types.id, custom_expedition_types.type FROM custom_itineraries INNER JOIN custom_expedition_types ON custom_itineraries.expedition_type_id = custom_expedition_types.id WHERE ( custom_itineraries.departure_date > '2010-9-4' AND custom_itineraries.departure_date < '2011-1-1') AND custom_itineraries.expedition = 'New Zealand' GROUP BY custom_expedition_types.type;

query: SELECT custom_expedition_types.id, custom_expedition_types.type FROM custom_itineraries INNER JOIN custom_expedition_types ON custom_itineraries.expedition_type_id = custom_expedition_types.id WHERE ( custom_itineraries.departure_date >= '2011-1-1' AND custom_itineraries.departure_date < '2012-1-1') AND custom_itineraries.expedition = 'New Zealand' GROUP BY custom_expedition_types.type;