or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

Sign up to our newsletter and become the first to know about our latest deals and promotions

  • 7 Night Mandalay Pagan Packet Downstream River Cruise from Mandalay to Pagan

    Orient Pandaw, Mandalay Pagan Packet Downstream ex Mandalay to Pagan
    Nights 7 Ship Orient Pandaw
    Star Rating River Departs Mandalay, Myanmar
    Sailing 2019: 5 Oct, 30 Nov, 28 Dec 2020: 11 Jan, 25 Jan, 8 Feb, 7 Mar, 21 Mar
    Ports of Call Mandalay, Mingun, Sagaing, Yandabo, Pakkoku, Salay, Pagan

    Special Pricing SpecialsPrice (Cabins)

    Sailing Dates

    Select a cabin to get pricing. Pricing is approximate.

    NZ $2,759
    Pandaw Cruises
    Orient Pandaw, Mandalay Pagan Packet Downstream ex Mandalay to Pagan

Orient Pandaw

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 100

Total elapsed time: 0.19663572311401

# Query Time
(1) connect 0.0010879039764404
(2) DESCRIBE `specials` 0.0061299800872803
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '7-night-mandalay-pagan-packet-downstream-river-cruise-from-mandalay-to-pagan-1541854') AND (orchid_available = 1) LIMIT 1 0.0021779537200928
(4) DESCRIBE `cruises` 0.0046260356903076
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56009))) 0.0008399486541748
(6) DESCRIBE `avid_specials` 0.0019550323486328
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541854 and class = 'Special') OR (item_id = 56009 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012497901916504
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541854') 0.00038909912109375
(9) DESCRIBE `ships` 0.0038890838623047
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00053501129150391
(11) DESCRIBE `ships` 0.0045349597930908
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00045394897460938
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036501884460449
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041508674621582
(15) DESCRIBE `itineraries` 0.0025160312652588
(16) DESCRIBE `ports` 0.002622127532959
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00067305564880371
(18) DESCRIBE `ports` 0.0023388862609863
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00069594383239746
(20) DESCRIBE `ports` 0.0023951530456543
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0006248950958252
(22) DESCRIBE `specialsailingdates` 0.0023081302642822
(23) DESCRIBE `sailingdates` 0.002593994140625
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518818))) 0.0007021427154541
(25) DESCRIBE `sailingdates` 0.0021309852600098
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518819))) 0.00042819976806641
(27) DESCRIBE `sailingdates` 0.0016298294067383
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518820))) 0.00066590309143066
(29) DESCRIBE `sailingdates` 0.0022420883178711
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518821))) 0.00053691864013672
(31) DESCRIBE `sailingdates` 0.0017948150634766
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518822))) 0.00037407875061035
(33) DESCRIBE `sailingdates` 0.0019819736480713
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518823))) 0.00043106079101562
(35) DESCRIBE `sailingdates` 0.0016839504241943
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518825))) 0.00035810470581055
(37) DESCRIBE `sailingdates` 0.0015320777893066
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518826))) 0.00034999847412109
(39) DESCRIBE `ports` 0.0019378662109375
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00064587593078613
(41) DESCRIBE `ports` 0.0023789405822754
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00075221061706543
(43) DESCRIBE `ports` 0.0019211769104004
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00043797492980957
(45) DESCRIBE `ports` 0.0020840167999268
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00038599967956543
(47) DESCRIBE `ports` 0.0021710395812988
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00048708915710449
(49) DESCRIBE `ports` 0.0018689632415771
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00039792060852051
(51) DESCRIBE `ports` 0.0018038749694824
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00048303604125977
(53) DESCRIBE `ports` 0.0019078254699707
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00046610832214355
(55) DESCRIBE `ports` 0.0020520687103271
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00049614906311035
(57) DESCRIBE `ports` 0.0020239353179932
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00066089630126953
(59) DESCRIBE `ports` 0.0024011135101318
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00047016143798828
(61) DESCRIBE `ports` 0.0037219524383545
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00077605247497559
(63) DESCRIBE `ports` 0.0029230117797852
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00051593780517578
(65) DESCRIBE `ports` 0.0020079612731934
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0003972053527832
(67) DESCRIBE `ports` 0.0018439292907715
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00041699409484863
(69) DESCRIBE `ports` 0.0021779537200928
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00057220458984375
(71) DESCRIBE `ports` 0.0027689933776855
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00070500373840332
(73) DESCRIBE `ports` 0.0028190612792969
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00055694580078125
(75) DESCRIBE `specialsmultipricing` 0.0022950172424316
(76) DESCRIBE `leadpricing` 0.0023930072784424
(77) DESCRIBE `specialspricing` 0.003277063369751
(78) DESCRIBE `cabins` 0.002777099609375
(79) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 9321))) 0.00059819221496582
(80) DESCRIBE `currencies` 0.0021657943725586
(81) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00054216384887695
(82) DESCRIBE `cruiselines` 0.0032980442047119
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00051999092102051
(84) DESCRIBE `orchid_image` 0.0021140575408936
(85) DESCRIBE `cruiselines` 0.0025720596313477
(86) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00046205520629883
(87) DESCRIBE `cruises` 0.007066011428833
(88) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56009') 0.0005950927734375
(89) DESCRIBE `deckplans` 0.0023491382598877
(90) DESCRIBE `cabins` 0.0025370121002197
(91) DESCRIBE `shipphotos` 0.002108097076416
(92) DESCRIBE `cruises` 0.0050449371337891
(93) SELECT `cruises`.* FROM `cruises` WHERE (id IN (11517, 4425, 6056, 4424, 65943, 65945, 49093, 76299, 37235, 45258)) ORDER BY FIND_IN_SET(id, '11517,4425,6056,4424,65943,65945,49093,76299,37235,45258') 0.0018661022186279
(94) DESCRIBE `cruiselines` 0.0037689208984375
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '47', '216', '23', '218', '8', '33', '26', '114', '20', '37', '151', '91', '96', '19', '101', '212', '15', '140', '180', '18', '191', '14', '29')) ORDER BY FIND_IN_SET(id, '120,47,216,23,218,8,33,26,114,20,37,151,91,96,19,101,212,15,140,180,18,191,14,29') 0.0031521320343018
(96) DESCRIBE `ships` 0.005540132522583
(97) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '855', '521', '520', '627', '701', '124', '441', '163', '341', '1282', '1303', '45', '573', '616', '678', '769', '780', '1409', '683', '776', '1402', '1587', '1682', '1772', '1788', '1819', '82', '105', '287', '349', '394', '404', '407', '422', '485', '652', '966', '1013', '1021', '1073', '1262', '1284', '1321', '1330', '1491', '1526', '1672', '1678', '1711', '1746', '1766', '1791', '1808', '66', '253', '290', '325', '332', '352', '406', '420', '451', '508', '542', '585', '665', '674', '770', '795', '907', '933', '1008', '1028', '1029', '1088', '1108', '1157', '1193', '1205', '1283', '1302', '1318', '1319', '1328', '1359', '1398', '1415', '1455', '1539', '1723', '1821')) ORDER BY FIND_IN_SET(id, '517,855,521,520,627,701,124,441,163,341,1282,1303,45,573,616,678,769,780,1409,683,776,1402,1587,1682,1772,1788,1819,82,105,287,349,394,404,407,422,485,652,966,1013,1021,1073,1262,1284,1321,1330,1491,1526,1672,1678,1711,1746,1766,1791,1808,66,253,290,325,332,352,406,420,451,508,542,585,665,674,770,795,907,933,1008,1028,1029,1088,1108,1157,1193,1205,1283,1302,1318,1319,1328,1359,1398,1415,1455,1539,1723,1821') 0.017627954483032
(98) DESCRIBE `cruisetypes` 0.0025899410247803
(99) DESCRIBE `destinations` 0.0036420822143555
(100) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '54', '22', '50', '35', '2', '8', '12', '53', '39', '49', '26', '29', '34', '37', '7', '38', '40', '25', '45')) ORDER BY FIND_IN_SET(id, '43,54,22,50,35,2,8,12,53,39,49,26,29,34,37,7,38,40,25,45') 0.0030369758605957