1.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
2.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
3.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
4.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
5.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
6.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
7.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
8.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
9.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
10.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
11.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
12.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
13.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
14.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
15.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
16.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
17.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
18.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
19.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
20.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
21.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
22.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
23.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
24.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
25.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
26.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
27.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
28.
SELECT T.*, CASE WHEN price_2019 IS NULL OR price_2019 = 0 THEN price ELSE price_2019 END AS p2019, CASE WHEN price_2020 IS NULL THEN price ELSE price_2020 END AS p2020 FROM trip AS T LEFT JOIN (SELECT id_trip, MAX(CASE WHEN year = '2019' THEN price ELSE 0 END) AS price_2019, MAX(CASE WHEN year = '2020' THEN price ELSE 0 END) AS price_2020 FROM `trip_price` GROUP BY id_trip) AS P ON T.id_trip = P.id_trip ORDER BY name Other
Total
Deposit (USD $ 300.00 as down payment per person OR 50% if the price is less than USD $300).
Final Balance can be paid in your briefing at our Local office or your hotel in cash