We don't charge any convenience fee
We don't charge any convenience fee
SELECT r.starting_from,d.dest_name FROM travshop_datab.promoter_packages p LEFT JOIN travshop_datab.promoter_price r ON p.id=r.package_id LEFT JOIN travshop_datab.hb_destinations d ON d.id=r.starting_from WHERE r.psort='Y' AND r.date_to >='2024-05-06' AND p.id IN (1416,2177,2089,1876,0,1858,1790,1783,1750,1644,2183,1411,1410,1409,1408,1407,91,1405,1404,1403,3490,3818,3549,3492,3390,3088,2876,2756,2753,2752,1406,2726,2725,2718,2423,2421,2422,2314,2209,2184,893,1260,1259,1258,1402,1256,1255,1254,1253,1145,1257,886,776,342,341,340,307,289,560,578,1396,1401,1400,1399,1398,1397,1261,1395,1394,1375,1270,1262,1263,1264,1265,1266,1267,1268,1269,1271,3898,3855,3840,3839,3838,3833,3822,3820) GROUP BY p.id
These are some of our curated packages - designed for the smart traveller in you