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 = 'Thailand' GROUP BY custom_expedition_types.type;