| Voyage Dates |
2010 Departures
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-7-29' AND
custom_itineraries.departure_date < '2011-1-1') AND
custom_itineraries.expedition = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawson's Antarctica - Commonwealth Bay
|
2011 Departures
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 = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawson's Antarctica - Commonwealth Bay
Scott & Shackleton's Antarctica - Ross Sea Region
|
2012 Departures
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 >= '2012-1-1' AND
custom_itineraries.departure_date < '2013-1-1') AND
custom_itineraries.expedition = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawson's Antarctica - Commonwealth Bay
Scott & Shackleton's Antarctica - Ross Sea
|
| -1 Night departing 1 January 1970 |
|
|
){kind=link}
