| Voyage Dates |
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-5-17' AND
custom_itineraries.departure_date < '2013-1-1') AND
custom_itineraries.expedition = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawson's Antarctica - Commonwealth Bay (Bluff to Bluff)
|
2013 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 >= '2013-1-1' AND
custom_itineraries.departure_date < '2014-1-1') AND
custom_itineraries.expedition = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawson's Antarctica - Commonwealth Bay (Bluff to Hobart)
Scott & Shackleton's Antarctica - Ross Sea (Hobart to Bluff)
|
2014 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 >= '2014-1-1' AND
custom_itineraries.departure_date < '2015-1-1') AND
custom_itineraries.expedition = 'Antarctica'
GROUP BY custom_expedition_types.type;
Mawsons Antarctica - Commonwealth Bay (Dunedin to Dunedin)
Mawsons Antarctica - Commonwealth Bay (Dunedin to Hobart)
Scott & Shackletons Antarctica - Ross Sea (Hobart to Dunedin)
|
| 18 Night Mawsons Antarctica - Commonwealth Bay departing 20 December 2012 |
|
|
){kind=link}
){kind=link}
