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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
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
0.00
X
Total Price
Calc
Deposit (USD $ 200.00 as down payment per person OR 50% if the price is less than USD 200.00)
Final Balance can be paid in your briefing at our Local office or your hotel in cash